ETL Developer

Job description

**Development / ETL Developer** The ETL Developer will play a critical role in designing, building, and maintaining integration process flows for the **Digital Integration Hub** (DIH), centralized integration platform for Trading and Asset Services. This role is focused on ETL development, data transformation, API integrations, and secure, scalable workflow design using industry leading tool , Adeptia. You will work closely with Product Owners, Business Analysts, QA, DevOps, and the Scrum Master to deliver high ‑ quality , secure, and reliable integration solutions that support DIH’s strategic roadmap. **Position Responsibilities:** - Design, develop, test, and maintain DIH integration connectors using ETL tool Adeptia. - Build and optimize ETL workflows that extract, transform, validate, and load data across internal and external systems. - Implement API integrations (REST/SOAP) using modern authentication methods (OAuth, JWT, API keys). - Map source and destination fields, define transformation logic, and ensure data accuracy and consistency. - Write clean, maintainable, and secure integration logic following development standards. - Create process flows, sequence diagrams, and technical documentation to support development and maintenance. - Assist engineering teams with design changes and architectural improvements. - Collaborate with QA engineers to define acceptance criteria, test strategies, and quality gates. - Support automated testing and CI/CD pipeline improvements. - Troubleshoot defects, identify root causes, and implement corrective actions. - Ensure all integration workflows follow secure coding practices and security standards. - Support security reviews, audits, and remediation activities throughout the development lifecycle. - Collaborate with DevOps on deployments, environment configuration, and pipeline automation. - Provide technical input for release notes, documentation, and training materials. **Position Requirements:** - Bachelor’s degree in software engineering, computer science or other related discipline or the equivalent combination of education, training, or work experience - Experience designing complex multi ‑ step ETL pipelines with branching logic, conditional flows, and error handling using tools such as Adeptia, Azure Data Factory, Informatica, or similar platforms ( **Adeptia preferred** ) - Strong SQL skills and familiarity with JavaScript, or equivalent programming language - Familiarity with secure coding practices, especially around data movement and API consumption - Knowledge of CI/CD pipelines, automated testing, and DevOps practices - Understanding of data modeling concepts, including schemas, transformations, and data lineage - **Ideal candidate has previous experience in the FinTech industry with exposure to financial markets, private equity, or investment accounting** - Knowledge of end-to-end software development life cycles, e.g., Agile, SAFeAgile - Strong interpersonal communication skills - Excellent written, verbal communication and presentation skills - Ability to collaborate with globally distributed teams. - Strong analytical, problem-solving, and time management skills **About Digital Integration Hub** Digital Integration Hub (DIH) team is structured horizontally across Trading & Asset Services business and aims to build and rebuild digital connectors between internal products as well as third-party partners. DIH seeks to integrate products and solutions using modern integration standards and best practices. DIH works with business/solution leaders responsible for key ecosystems to meet integration requirements aimed at linking products and solutions to provide a more automated, unified experience for our clients. DIH is a centralized home for strategic integrations, established to build, enhance, maintain, and support strategic integrations.