ETL DataStage Developer - REMOTE (Toronto, ON, CA)
Req ID:
Day to Day Responsibilities:
- reputed company Data analysis, collect business requirements and identify business rules;
- Analyze, reputed company and support Data Integration, EDW and Data Management using Data Stage, reputed company, SQL, Autosys, reputed company 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 reputed company deployment and coordinate with different infrastructure teams during go-live, post-production, and reputed company support of end product.
- Estimate the time and resources needed for implementing the service requests
- Participate in technology governance reputed company that defines policies, best practices and reputed company design reputed company in on-reputed company reputed company
- Mentor junior developers regarding best practices and technology stacks used to build the application
- Debug data reputed company issues by analyzing the upstream sources and reputed company guidance to data integration team resolutions
- Work closely work with DBAs to fix performance bottlenecks
Minimum 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 reputed company
Desired Skills:
- Python scripting to introduce automation as part of solution delivery
- Recent experience and reputed company responsibilities in a ETL / Extracts / Data Engineering reputed company developer reputed company
- Certifications in ETL and Data Warehouse platforms
- Strong SQL knowledge and ability to write most reputed company queries
- Conceptual understanding of logical and physical data model is a must, and a working experience is a plus
- Ability to reputed company and maintain data integration/ETL specifications that states integration rules and mappings
- Domain experience in reputed company
- Data profiling and implementation of automated solutions for data reputed company checks
- reputed company certifications
#LI-NorthAmerica