Credit- DataStage developer

J&M Group; Toronto; On-site; CAD 100,000 - 130,000; Full time

Job summary

A leading company in Toronto seeks an experienced ETL Developer with over 8 years in data pipeline design and SQL expertise. The role demands strong interpersonal skills and a solid understanding of complex development environments, focusing on best practices and team collaboration.

Qualifications

• 8+ years in complex development environments.
• Hands-on experience in ETL data-stage.
• Extensive SQL experience with MSSQL Server and Teradata.

Responsibilities

• Design and implement data pipelines with high quality standards.
• Create technical design documents and facilitate project meetings.
• Estimate tasks for design, coding, and unit testing.

Skills

Communication

SQL

Unix Shell Scripting

GitHub

Job description

Job Description

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
  
  

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