Lead ETL Engineer & Data Modeller

TAT IT Technolgies; Fujairah; On-site; AED 180,000 - 300,000; Full time

Job summary

Lead ETL Engineer & Data Modeller with Snowflake and Informatica to design, build, and optimize large-scale data integration solutions for a banking client in Fujairah, UAE.

You will implement audit logs, reconciliation tables, and status histories, ensure data accuracy and regulatory compliance, and collaborate with analysts and data architects.

Qualifications

• Advanced Informatica ETL pipelines for large-scale banking data.
• Strong Snowflake data warehousing and performance optimization.
• Experience with audit, reconciliation, and regulatory compliance.

Responsibilities

• Lead ETL pipeline design and implementation using Informatica and Snowflake.
• Develop logical and physical data models to support audit and reconciliation.
• Build audit logs, error queues, status history, and data corrections.
• Collaborate with analysts, architects, and compliance teams.

Skills

Snowflake

Informatica

ETL design

Data modelling

Data quality

Tools

Informatica PowerCenter/Cloud

Job description

We have an urgent requirement for Lead ETL Engineer & Data Modeller with strong expertise in Snowflake and Informatica in banking domain for one of our banking clients in Fujairah, UAE

core technical expertise (Snowflake, Informatica, ETL, data modelling)

• -Must Advanced expertise in Informatica for building, optimizing, and managing large‑scale ETL pipelines, including audit and reconciliation frameworks.--
• Must Strong ability to design conceptual, logical, and physical data models, with a focus on message tracking, audit logs, error queues, status history, and corrected values.--
• Must Deep knowledge of Snowflake for scalable data warehousing, integration, and performance optimization in banking environments.--
• Must Leading enterprise‑level data integration projects, ensuring high availability, scalability, and reliability.--

Must

Banking Domain--

Must

Role Overview

We are seeking a Lead ETL Engineer & Data Modeller with strong expertise in Snowflake and Informatica to design, build, and optimize large‑scale data integration solutions. The role focuses on creating robust frameworks for message tracking, audit logs, error queues, status history, and corrected values, ensuring data accuracy and compliance in a banking environment.

Key Responsibilities

• ETL Design & Development: Lead the design and implementation of ETL pipelines using Informatica and Snowflake for large‑scale banking data integration projects.
• Data Modelling: Develop logical and physical data models to support audit, reconciliation, and compliance frameworks.
• Audit & Reconciliation Frameworks: Build and maintain tables for message tracking, audit logs, error queues, status history, and corrected values to ensure transparency and regulatory compliance.
• Performance & Optimization: Optimize ETL workflows, monitor data pipelines, and ensure high availability, scalability, and performance across banking systems.
• Collaboration: Work closely with business analysts, data architects, and compliance teams to align solutions with banking regulations and business needs.

Required Skills

• Expertise in Snowflake and Informatica PowerCenter/Cloud.
• Strong data modelling skills (conceptual, logical, physical).
• Experience in ETL design, development, and optimization.
• Knowledge of audit, reconciliation, and compliance frameworks in banking.
• Proven track record in large‑scale data integration projects.

Preferred Experience

• Banking or financial services domain exposure.
• Ability to design frameworks for regulatory compliance, audit readiness, and reconciliation accuracy.
• Strong problem‑solving, leadership, and mentoring skills.

Key Deliverables

• Robust ETL pipelines supporting mission‑critical banking operations.
• Accurate and auditable data flows with reconciliation frameworks.
• Optimized data models ensuring scalability and compliance.
• Documentation of ETL processes, audit logs, and reconciliation reports.

Skills: data modeller,etl,snowflake