This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
The ETL DataStage Developer role requires a minimum of 8 years of experience in data integration, with a strong focus on DataStage and SQL. The candidate will be responsible for developing ETL processes, collaborating with teams, and mentoring junior developers. A degree in Computer Science is preferred, along with certifications in ETL and Data Warehousing. This remote position offers an opportunity to work with leading technologies in a dynamic environment.
Job Responsibility:
Perform Data analysis, collect business requirements and identify business rules
Analyze, develop and support Data Integration, EDW and Data Management using Data Stage, Teradata, SQL, Autosys, Oracle etc. platforms and tools
Collaborate with data modelling team to define data integration logic
Create data mapping necessary to fulfill the requirements
Build and test new ETL programs to fulfill the service requests
Automate the ETL processes and pipelines using scripting and Autosys
Participate in Unit Testing, assist QA team in Integration Testing, and support Business team for UAT
Participate in code deployment and coordinate with different infrastructure teams during go-live, post-production, and continued support of end product
Estimate the time and resources needed for implementing the service requests
Participate in technology governance groups that defines policies, best practices and make design decisions in on-going projects
Mentor junior developers regarding best practices and technology stacks used to build the application
Debug data quality issues by analyzing the upstream sources and provide guidance to data integration team resolutions
Work closely work with DBAs to fix performance bottlenecks
Requirements:
8+ total years experience in data integration (ETL)
5 years solution development using DataStage suite
5 years of experience in RDBMS / Data Warehousing platforms, preferably Teradata
Nice to have:
Python scripting
Recent experience and clear responsibilities in a ETL / Extracts / Data Engineering lead developer capacity
Certifications in ETL and Data Warehouse platforms
Strong SQL knowledge and ability to write most complex queries
Conceptual understanding of logical and physical data model
Ability to develop and maintain data integration/ETL specifications
Domain experience in Healthcare
Data profiling and implementation of automated solutions for data quality checks