Overview
Data EngineerOffshore - India6 months Contract
Job Description
We are seeking a Data Engineer with strong expertise in SQL and ETL processes to support banking data quality data pipelines, regulatory reporting, and data quality initiatives. The role involves building and optimizing data structures, implementing validation rules, and collaborating with governance and compliance teams. Experience in the banking domain and tools like Informatica and Azure Data Factory is essential.
Mandatory skills
- Strong proficiency in SQL for writing complex queries, joins, data transformations, and aggregations
- Proven experience in building tables, views, and data structures within enterprise Data Warehouses and Data Lakes
- Strong understanding of data warehousing concepts, such as Slowly Changing Dimensions (SCDs), data normalization, and star/snowflake schemas
- Practical experience in Azure Data Factory (ADF) for orchestrating data pipelines and managing ingestion workflows
Desired Skills
· Exposure to data cataloging, metadata management, and lineage tracking using Informatica EDC or Axon
· Experience implementing Data Quality rules for banking use cases such as completeness, consistency, uniqueness, and validity
· Familiarity with banking systems and data domains such as Flexcube, HRMS, CRM, Risk, Compliance, and IBG reporting
· Understanding of regulatory and audit readiness needs for Central Bank and internal governance forums
Roles & Responsibilities
· Write optimized SQL scripts to extract, transform, and load (ETL) data from multiple banking source systems
· Design and implement staging and reporting layer structures, aligned to business requirements and regulatory frameworks
· Apply data validation logic based on predefined business rules and data governance requirements
· Collaborate with Data Governance, Risk, and Compliance teams to embed lineage, ownership, and metadata into datasets
· Monitor scheduled jobs and resolve ETL failures to ensure SLA adherence for reporting and operational dashboards
· Support production deployment, UAT sign-off, and issue resolution for data products across business units
Overall years of experience
5–8 years
Relevant years of experience
3–6 years in banking-focused data engineering roles with hands-on SQL, ETL, and DQ rule implementation
Industry & Education background
· Bachelor's or Master's Degree in Computer Science, Information Systems, Data Engineering, or related fields
· Banking domain experience is mandatory, especially in areas related to regulatory reporting, compliance, and enterprise data governance
Job Type: Contractual / Temporary
Contract length: 6 months
Pay: ₹150,000.00 - ₹170,000.00 per month
Work Location: Remote
Application Deadline: 04/05/2025