Senior Data Warehouse Engineer - BFSI Domain

Job Description

Data Warehouse Engineer / Lead – Banking & Financial Domain

Experience

Required:

8–10 years

• Strong technical knowledge in Data Warehouse systems.
• Knowledge and experience in the Banking and Financial domain (minimum 8 years).
• Experience in ETL processes and developing SSIS packages.
• Ability to lead and mentor a team of developers.
• Ability to understand requirements and manage complete data warehouse systems.

• Strong expertise in ETL and Data Warehouse development.
• Hands‑on experience with MS SSIS for ETL package development.
• Experience with SSRS for reporting and dashboarding.
• Strong database skills including IBM Netezza, MS SQL Server, Sybase.
• Experience with AWS Redshift or AWS Glue for cloud‑based data warehousing.

• Experience with AWS Cloud services such as Spark, Redshift, and EMR.
• Knowledge of lending systems and functional processes in banking.
• Experience with MDM systems for customer demographics management.
• Understanding of retail and commercial deposit systems (Core Banking, Canadian banking domain).
• Strong solution knowledge in AWS Cloud and hands‑on experience with ETL processes like Kafka message processing, batch interface data injection, and other business‑layer processes.

• Data Warehouse
• IBM Data Management
• IT
• Database: MS SQL Server