Senior ETL Developer

Randstad Digital; Markham; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company is seeking an ETL Developer for a 6-month contract in Markham. The role involves designing ETL processes, optimizing SQL queries, and collaborating with teams in the finance sector. Candidates should possess strong communication skills, problem-solving ability, and relevant experience in ETL and database management.

Qualifications

• Proven experience as an ETL Developer, preferably with Informatica and complex SQL queries.
• Experience in the insurance industry and data warehousing concepts.
• Strong communication skills and ability to draft business requirements.

Responsibilities

• Design, develop, and maintain ETL processes and optimize SQL queries.
• Collaborate with teams to ensure data integrity and produce ad hoc reports.
• Document specifications and improve ETL process performance.

Skills

SQL

ETL

Problem-Solving

Data Analysis

Collaboration

Education

Informatica Certified Professional (ICP)

SQL Associate Certification

Tools

Informatica PowerCenter

PostgreSQL

Control-M

ASG ZENA

Unix

SAP Business Objects

Qlik

Python

Power BI

Job description

Number of Positions : 1, Duration : 6 months initial contract

Location : Markham, ON, CA

Must be eligible to work in Canada

Work Schedule : 3 days onsite in Markham, 7 hours per day (non-negotiable)

Roles and Responsibilities :

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into finance systems.
• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.
• Monitor daily / monthly jobs and resolve failures as needed.
• Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.
• Build ad hoc reports based on business requirements.
• Perform data analysis and troubleshooting to resolve data-related issues.
• Implement data quality checks and validation processes.
• Build complex finance calculations using Postgres stored procedures or ETL processes.
• Monitor and improve the performance of ETL processes and database systems.
• Document technical specifications and maintain comprehensive documentation of ETL processes.
• Stay updated with industry trends and best practices in ETL and database management.

Maur have skills / experience / qualifications :

• Proven experience as an ETL Developer (Informatica PowerCenter 10.5.7 and Informatica BDM).
• Proven experience as a Database Developer, with hands-on experience in writing DDLs and DMLs for relational databases.
• Experience in writing complex SQL queries for ad hoc reporting.
• Experience in the insurance industry and understanding underwriting data terminology.
• Experience with automation tools like Control-M, ASG ZENA, and Unix scripting.
• Experience with reporting tools such as SAP Business Objects and Qlik.
• Knowledge of data warehousing concepts and best practices.
• Excellent problem-solving skills and attention to detail.
• Experience with Agile methodology and JIRA.
• Strong communication and collaboration skills.
• Ability to draft and understand business requirement documents.
• Ability to work independently and in a team.

Preferred Qualifications :

• Informatica Certified Professional (ICP) and / or Informatica Foundation Level Certifications.
• Experience with database systems like Oracle, Postgres, MySQL; SQL Associate Certification is a plus.
• Knowledge of data visualization tools such as Qlik, Python, Power BI, SAP BO.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Information Technology
• IT Services and IT Consulting, Insurance, and Financial Services

This job posting is active and accepting applications.

J-18808-Ljbffr

Create a job alert for this search