Data Pipeline & Integration Engineer

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Etl Development & Implementation
• Designs, develops, and maintains ETL pipelines using Informatica and related tools.
• Buils mappings, workflows, and sessions to support data ingestion and transformation.
• Implements transformations including joins, aggregations, parameterization, and error handling.
• Ensures ETL jobs are restartable, efficient, and aligned with SLAs and dependencies.
• Minimal scripting in Python and orchestration for API integrations, event driven patterns
• Production Support & Stability
• Monsitors and supports production ETL pipelines and scheduled jobs.
• Troubleshoots ETL failures, analyze logs, and identify root causes.
• Solves defects and data issues within defined timelines.
• Contributes to improving pipeline reliability and reducing recurring issues.
• Data Integration & Data Warehouse
• Designs and maintains data flows across staging, ODS, and data warehouse layers.
• Develops and maintains data interfaces across systems and applications.
• Suports data acquisition strategies and integration patterns.
• Data Pipeline Optimization & Quality
• Optimizes ETL processes for performance and scalability.
• Implements validation checks, reconciliation processes, and data quality controls.
• Suports compliance with data governance and audit requirements.
• Collaboration & Coordination
• Works with business analysts and stakeholders to refine data requirements.
• Coordinates with QA, scheduling, and downstream consumers for deployment and execution.
• Participates in Agile or hybrid delivery models.
• Standards, Documentation & Governance
• Follows coding standards, naming conventions, and documentation practices.
• Participates in code reviews and design walkthroughs.
• Maintains documentation for pipelines and interfaces.
• Modern Data Platform Exposure
• Gains exposure to cloud and modern platforms such as Snowflake, AWS, dbt, and streaming technologies.
• Suports hybrid architecture environments combining legacy ETL and modern platforms.
• Compliance & Risk
• Suports audit, reconciliation, and data lineage requirements.
• Supports compliance with data governance and audit requirements.
• Identifies and reports suspicious activity.

EDUCATION

• Bachelor's Degree in Computer Science, Information Systems, or related field

EXPERIENCE

• 4+ years of experience in ETL / data engineering / data integration
• Hands-on experience with Informatica (PowerCenter / IDMC)
• Strong SQL and relational database experience
• Exposure to modern data platforms tools such as Snowflake, AWS, dbt, or other cloud-based data environments, and their orchestration tools
• Familiarity with Agile or hybrid delivery models
• Hands-on experience with Informatica ETL tools, including mappings, workflows, and sessions
• Experience supporting production data pipelines with defined SLAs and dependencies
• Exposure to modern data platforms such as Snowflake, AWS, dbt, and cloud-based data environments

KNOWLEDGE, SKILLS AND ABILITIES

• Understanding of ETL/ELT and data pipeline design
• Understanding of data governance, security, and regulatory requirements in banking environments
• Understanding of data quality, reconciliation, and audit requirements
• Strong understanding of ETL/ELT concepts, data integration, and pipeline orchestration
• Solid knowledge of data warehouse architecture, including staging, ODS, and enterprise data warehouse layers
• Strong SQL skills and experience querying relational databases
• Ability to troubleshoot ETL failures, analyze logs, and identify root causes
• Understanding of data quality, reconciliation, and audit requirements
• Ability to follow and contribute to coding standards, documentation, and best practices
• Strong analytical and problem-solving skills
• Strong attention to detail and operational discipline
• Ability to collaborate with cross-functional teams including QA, business analysts, and downstream consumers
• Familiarity with Agile or hybrid delivery models
• Understanding of data governance, security, and regulatory requirements in banking environments