ETL DataStage Developer - REMOTE
NTT Data View all jobs
- Toronto, ON
- Permanent
- Full-time
- 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
- 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
- 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
- Strong SQL knowledge and ability to write most complex queries
- Conceptual understanding of logical and physical data model is a must, and a working experience is a plus
- Ability to develop and maintain data integration/ETL specifications that states integration rules and mappings
- Domain experience in Healthcare
- Data profiling and implementation of automated solutions for data quality checks
- Databricks certifications