Overview
Skills
Job Details
We are currently looking for strong DataStage Developer for our client in Toronto, Ontario, Please find the detail description below. Kindly let me know your interest.
Role: DataStage Developer
Location: Toronto, Ontario
Duration: Long term
Job Description:
Must-have
8+ years of experience working in complex and time-sensitive development environment
Extensive hands-on experience in ETL data-stage
Extensive hands-on complex SQL experience (MSSQL Server, Teradata)
Extensive experience in creating stored procedure and Unix shell scripting
Support at-scale testing to enable simulations, UAT and reporting
Nice to Have:
Working knowledge of Kafka
Working knowledge of JCL/Zeke
What will you do?
Strong experience in design and implement data pipelines
Strong PL/SQL and SQL skills in relational database environment
Strong Unix shell scripting skills
Create and review technical design documents, understand how the design will be used in the code development process, and facilitate meetings to design, troubleshoot, and execute projects
Participate in walkthrough reviews of technical specifications, programs, code, and unit test plans
Plan design/implementation activities, ensure technical solution quality, provide third-level support for various technologies, and drive technical platform evolution and improvements
Present technical topics at regular team meetings and manage low-level planning of work packages
Estimate activities/tasks required to perform design, coding, and unit testing
Excellent interpersonal and highly developed communication skills (verbal and written)
Ensure ETL pipelines are produced with the highest quality standards, metadata and validated for completeness and accuracy
Work closely with development teams to learn about needs, current processes and to promote best practices.
Knowledge of the Software Development Life Cycle (SDLC) - Agile, Waterfall, and Iterative methods
Working knowledge GitHub, CI/CD Pipeline