Ab Initio Developer

Overview You will design and optimize high-volume data integration pipelines for financial services clients using Ab Initio, collaborating with data architects and analysts. You’ll translate complex business requirements into scalable solutions, focusing on secure, efficient data processing within a regulated environment. This role sits in Deloitte’s AI & Engineering team, shaping data platforms and analytics capabilities to drive client success. You’ll work cross-functionally to deliver robust ETL solutions and maintain clear technical documentation, with a strong emphasis on quality and delivery under tight deadlines. Compensation / Benefitsbenefits package for project-delivery professionalscompetitive compensationdiscretionary annual incentive program ResponsibilitiesDesign, build, test, and deploy high-volume ETL solutions on the Ab Initio platform, including FDC Gateway integrationsPerform data analysis, mapping, and source-to-target integration across heterogeneous systemsWrite and optimize SQL/PLSQL for Oracle databases to maximize throughput and reduce latencyCollaborate with business analysts and data architects to translate requirements into scalable technical solutionsManage tight deadlines and adapt to changing client expectations in a fast-paced, regulated settingCreate and maintain technical documentation, data lineage, and SOPs to ensure knowledge transfer and sustainability Key requirements4+ years of data engineering and ETL development experience in Financial Services4+ years hands-on Ab Initio ETL development experience with FDC GatewayOracle database experience with advanced SQL/PLSQL, execution plan analysis, and performance tuningExperience with data warehousing methodologies (Kimball, Inmon) and dimensional modeling (Star/Snowflake)Robust error-handling, data reconciliation, and reject-processing frameworks for financial pipelinesExperience integrating ETL deployments into CI/CD pipelines with Git, Jenkins, or Azure DevOpsclear and concise communicationresilience under pressureproblem solvingAb Initio ETL developmentFDC Gateway integrationsOracle SQL/PLSQL