• We are seeking an experienced Lead ETL Engineer & Data Modeller to design and lead data integration, ETL, and data modelling initiatives for a banking client. The role will focus on building robust and scalable data pipelines, audit and reconciliation frameworks, and data structures supporting transaction/message processing, monitoring, and regulatory requirements.

  Key Responsibilities

  • Lead the design and development of ETL/ELT pipelines for large-scale banking data integration requirements.

  • Design and implement data structures and tables for message tracking, audit logs, error queues, status history, and corrected/validated values.

  • Develop robust audit, reconciliation, exception-handling, and data quality frameworks.

  • Design scalable data models to support operational, analytical, reporting, and regulatory requirements.

  • Develop and optimize ETL workflows using Informatica and Snowflake.

  • Ensure accurate and traceable movement of data across source, staging, transformation, and target systems.

  • Implement mechanisms for data validation, error handling, data lineage, reconciliation, and auditability.

  • Work closely with Solution Architects, Data Architects, application teams, business stakeholders, and infrastructure teams to define integration requirements.

  • Optimize ETL processes and Snowflake workloads for performance, scalability, reliability, and cost efficiency.

  • Establish standards and best practices for ETL development, data modelling, coding, testing, deployment, and documentation.

  • Lead technical design reviews and provide guidance to ETL developers and data engineers.

  • Ensure solutions comply with the bank’s data governance, security, privacy, and regulatory requirements.

  • Troubleshoot complex data and integration issues and provide root-cause analysis and remediation.

Desired Candidate Profile

• 8+ years of experience in ETL development, data engineering, and data modelling, with experience in a banking or financial services environment preferred.

• Strong hands-on expertise in Snowflake and Informatica.

• Strong understanding of ETL/ELT architecture, data integration patterns, and enterprise data modelling.

• Proven experience designing audit trails, reconciliation frameworks, error handling, exception management, and data quality controls.

• Strong SQL skills and experience working with large-scale datasets.

• Experience with relational databases, data warehouses, and cloud-based data platforms.

• Good understanding of data lineage, metadata, data governance, and master/reference data concepts.

• Experience working with high-volume, mission-critical data integration environments.

• Strong understanding of data security, access controls, encryption, and regulatory compliance within banking environments.

Preferred

• Experience with UAE banking clients and CBUAE regulatory requirements.

• Exposure to banking transactions, payments, financial messaging, or reconciliation systems.

• Experience with cloud platforms such as AWS or Azure.

• Familiarity with CI/CD, DevOps, Git, and automated ETL deployment practices.

• Experience leading ETL/data engineering teams and coordinating with multiple technology and business stakeholders.

Key Competencies

• Strong analytical and problem-solving skills.

• Excellent understanding of data architecture and integration design.

• Strong leadership and stakeholder management capabilities.

• Attention to detail with a strong focus on data accuracy, traceability, and auditability.

• Ability to work effectively in a high-volume, regulated banking environment.

Skills

ETL development

Snowflake

Informatica