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.
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
Part of the $4.8 billion RPG Group, we’re a community of 10,000+ innovators across 30+ global locations, including Milpitas, Seattle, Princeton, Cape Town, London, Zurich, Singapore, and Mexico City. Explore Life at Zensar and join us to Grow. Own. Achieve. Learn. to be the best version of yourself.
We believe the best work happens when individuality is celebrated, growth is encouraged, and well-being is prioritized. We are an equal employment opportunity (EEO) and affirmative action employer, committed to creating an inclusive workplace. All qualified applicants will be considered without regard to race, creed, color, ancestry, religion, sex, national origin, citizenship, age, sexual orientation, gender identity, disability, marital status, family medical leave status, or protected veteran status.
Skills Required
- Bachelor's degree in software engineering, computer science, or related field (or equivalent experience)
- Experience designing complex multi-step ETL pipelines with branching logic, conditional flows, and error handling using Adeptia, Azure Data Factory, Informatica, or similar
- Experience with Adeptia (preferred)
- Strong SQL skills
- Familiarity with JavaScript or an equivalent programming language
- Experience implementing API integrations (REST/SOAP) and using modern authentication methods (OAuth, JWT, API keys)
- Familiarity with secure coding practices for 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
- Previous experience in FinTech or exposure to financial markets, private equity, or investment accounting (ideal)
- Knowledge of end-to-end SDLC and Agile/SAFeAgile methodologies
- Strong interpersonal, written, verbal communication and presentation skills
- Ability to collaborate with globally distributed teams
- Strong analytical, problem-solving, and time management skills
Zensar Technologies Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Zensar Technologies and has not been reviewed or approved by Zensar Technologies.
-
Retirement Support — A 401(k) with company match and immediate vesting is highlighted, with broad fund options available.
-
Wellbeing & Lifestyle Benefits — Work-life balance, remote/hybrid flexibility, and supportive teams are emphasized as strengths that enhance the overall experience.
-
Parental & Family Support — Inclusive policies such as parental leave and access to EAP and dependent medical coverage are promoted across regions.
Zensar Technologies Insights
What We Do
Zensar is a leading experience, engineering, and technology solutions company. We conceptualize, build, and manage digital products for Forbes Global 2000 clients across the hi-tech engineering, banking and financial services, insurance, manufacturing and consumer services verticals. With proven excellence across five core areas, including experience services, advanced engineering services, data engineering and analytics, foundation services, and application services, our solutions leverage industry-leading platforms to help our clients be competitive, agile, and disruptive while moving with velocity through change and opportunity. Zensar’s expansive ecosystem of 60+ technology partners, including Oracle, Salesforce, SAP, Guidewire, Automation Anywhere, Adobe, and UiPath, enables us to deliver comprehensive solutions to clients, facilitating seamless integration and allowing them to leverage cutting-edge technologies and tools for enhanced business outcomes. Zensar is part of the USD 4.4 billion RPG Group. With headquarters in Pune, India, our 10,500+ employees, representing over 50 nationalities, work from 30+ locations across North America, UK/Europe, and South Africa. Visit us at www.zensar.com
