Data Engineer

Responsibilities:

• Build and maintain data warehouse and data marts, including ODS and internal departmental marts.
• Gather, process, maintain, and analyze large datasets, ensuring data accuracy and quality.
• Design, automate, and support ETL pipelines and data flows across multiple applications.
• Create logical and physical data flow models and mapping designs for ETL processes.
• Strong SQL skills (performance tuning, index management) and solid understanding of database structures.
• Strong understanding of data modeling concepts.
• Familiarity with SQL and NoSQL storage, and Big Data technologies (Hive, Impala, YARN, Kafka, etc.).

Informatica-specific requirements:

• Hands-on experience with Informatica PowerCenter development (mappings, sessions, workflows).
• Strong knowledge of Informatica transformations (e.g., Lookup, Joiner, Aggregator, Expression, Router, Sorter) and performance tuning.
• Experience with Informatica Developer.
• Experience with Informatica B2B is a plus.
• Ability to design, automate, monitor, and troubleshoot ETL jobs, including scheduling.

Banking sector requirements (preferred):

• Previous experience in the banking sector, preferably business banking, including working with banking datasets.
• Strong understanding of data quality and reconciliation expectations in banking environments.
• Experience working in regulated environments and change control practices is a strong plus.