ETL DataStage Developer - REMOTE

NTT DATA Services•Toronto, ON

27d•Remote

About The Position

NTT DATA is seeking an ETL DataStage Developer to join their team. This role is responsible for performing data analysis, collecting business requirements, and identifying business rules. The developer will analyze, develop, and support Data Integration, EDW, and Data Management using platforms and tools such as Data Stage, Teradata, SQL, Autosys, and Oracle. They will collaborate with the data modeling team to define data integration logic, create data mappings, and build and test new ETL programs. The role also involves automating ETL processes and pipelines, participating in testing phases (Unit, Integration, UAT), and supporting code deployment and post-production activities. Additionally, the developer will estimate time and resources, participate in technology governance groups, mentor junior developers, debug data quality issues, and work with DBAs to resolve 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
Strong SQL knowledge and ability to write most complex queries
Conceptual understanding of logical and physical data model is a must
Ability to develop and maintain data integration/ETL specifications that states integration rules and mappings

Nice To Haves

Python scripting to introduce automation as part of solution delivery
Recent experience and clear responsibilities in a ETL / Extracts / Data Engineering lead developer capacity
Certifications in ETL and Data Warehouse platforms
Working experience with logical and physical data models
Domain experience in Healthcare
Data profiling and implementation of automated solutions for data quality checks
Databricks certifications

Responsibilities

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