Credit-Datastage Developer

Cynet Systems; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading company is seeking a highly experienced Data Engineer with strong SQL and ETL expertise to design and implement data pipelines. The role emphasizes high-quality standards and requires excellent communication skills to work with various development teams. The ideal candidate will have a deep understanding of the Software Development Life Cycle and be proficient in managing complex data processing tasks.

Qualifications

• 8+ years of experience in development environments.
• Extensive hands-on experience with ETL and SQL.
• Knowledge of Software Development Life Cycle (SDLC) methods.

Responsibilities

• Design and implement data pipelines with quality standards.
• Create technical documents and facilitate meetings for design and troubleshooting.
• Support at-scale testing for UAT and reporting.

Skills

SQL

ETL

Communication

Interpersonal Skills

GitHub

SDLC Knowledge

Job description

• Strong experience in design and implement data pipelines.
• Strong PL / SQL and SQL skills in relational database environment.
• 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.