[Hiring] ETL Developer @Zensar

Role Description

The ETL Developer will play a critical role in designing, building, and maintaining integration process flows for the Digital Integration Hub (DIH), a 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 the 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.

• 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.

Qualifications

• 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, SAFe Agile.
• 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.

Company Description

The 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.