Datastage Developer

Job Description: Datastage Developer

Toronto, ON - Hybrid (4 Days WFO)

6-12 months

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 Git Hub, CI/CD Pipeline

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