Description

Design, build, and optimize complex data pipelines and SQL logic for Oracle and SQL Server environments.

This role is hybrid.

Responsibilities

• Design and optimize complex stored procedures, CTEs, and window functions across Oracle and SQL Server.
• Build and maintain scalable ETL/ELT pipelines using Azure Data Factory, focusing on parameterization and incremental loads.
• Lead execution plan analysis and indexing strategies to resolve high-volume data bottlenecks.
• Manage trigger management, monitoring, and automated reconciliation logic for enterprise data flows.
• Lead large-scale data migrations while maintaining strict data quality and governance controls.

Required Skills

• 5+ years of advanced SQL expertise in Oracle and SQL Server.
• Proven experience building modular data transformation frameworks in production using Azure Data Factory.
• Strong understanding of Change Data Capture (CDC) patterns and data validation frameworks.
• Ability to analyze execution plans and implement advanced indexing strategies.
• Experience in Financial Services or similarly regulated sectors.
• Proficiency with Azure DevOps and Git for version control and CI/CD.
• Bachelor’s degree in CS, Engineering, or a related technical field.

Key Skills

Education

Any Graduate