ETL Developer at Zensar

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.

At Zensar, we’re “experience-led everything”. We are committed to

conceptualizing, designing, engineering, marketing, and managing digital

solutions and experiences for over 130 leading enterprises. We are a company

driven by a bold purpose: Together, we shape experiences for better futures.

Whether for our clients, our people, or the world around us, this belief powers

everything we do. At the heart of our culture is ONE with Client – a set of four

core values that reflect who we are and how we work: One Zensar, Nurturing,

Empowering, and Client Focus.

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

[https://www.zensar.com/careers/] and join us to Grow. Own. Achieve. Learn.

[https://www.youtube.com/embed/i2NZsiQqVnU?autoplay=1&fs=1] 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.