Zensar Technologies Logo

Zensar Technologies

ETL Developer

Posted 2 Days Ago
Be an Early Applicant
In-Office or Remote
2 Locations
Entry level
In-Office or Remote
2 Locations
Entry level
The ETL Developer will design, build, and maintain integration processes for the Digital Integration Hub, focusing on ETL development, API integrations, and workflow design.
The summary above was generated by AI

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 highquality, 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. 

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

Bachelor’s degree in software engineering, computer science or other related discipline or the equivalent combination of education, training, or work experience 

Top Skills

Adeptia
APIs
Azure Data Factory
DevOps
Informatica
JavaScript
Jwt
Oauth
SQL
HQ

Zensar Technologies Pune, Mahārāshtra, IND Office

Zensar Knowledge Park, Kharadi, Plot # 4, MIDC, Pune, Maharashtra, India, 411014

Similar Jobs

7 Days Ago
Remote
India
Mid level
Mid level
Insurance • Consulting
The ETL Developer will design and maintain ETL workflows using SSIS, optimize ETL jobs, ensure data accuracy, and collaborate with teams to enhance ETL processes.
Top Skills: Actimize UdmAmlSQLSsisTalend
7 Days Ago
Remote
Hinjawadi, Pune, Mahārāshtra, IND
Senior level
Senior level
Fintech • Financial Services
The GCP Data Engineer will design, develop, and deploy scalable data solutions on Google Cloud Platform, optimizing data pipelines and collaborating with teams to enhance analytics infrastructures.
Top Skills: Apache AirflowApache BeamBigQueryCi/CdCloud Deployment ManagerCloud StorageData StudioDataflowDataprocGitGoogle Cloud PlatformInformaticaJavaJenkinsKafkaNoSQLPub/SubPythonScalaScikit-LearnSQLTableauTalendTensorFlowTerraform
21 Days Ago
Remote
IN
Expert/Leader
Expert/Leader
Artificial Intelligence • Information Technology • Machine Learning • Software • Virtual Reality • Analytics
The Principal Engineer, ETL is responsible for leading ETL projects, providing strategic insight, and driving technical excellence within the organization.
Top Skills: ETL

What you need to know about the Pune Tech Scene

Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account