ETL Developer - 2729

ETL Developer - 2729

Duration: Until end of Dec 2025 (possibility of extension)

Location: Hybrid - 3 days a week required in the Markham office

Skills:

• Experience in the insurance industry & able to understand underwriting data terminology.

• Experience in supporting finance systems.

• Proven experience as an ETL Developer (Informatica PowerCenter and Informatica BDM)

• Proven experience as Database Developer, hands on experience in writing DDLS and DMLS for relational databases

• Experience in writing complex SQL queries for Adhoc reporting.

• Experience on automation tools like Control-M, ASG ZENA Experience in writing Unix scripts.

• Experience in any Reporting tool (SAP Business Objects, Qlik Reporting)

• Knowledge of data warehousing concepts and best practices.

• Excellent problem-solving skills and attention to detail.

• Experience in Agile methodology & JIRA.

• Above average communication and collaboration skills.

• Proficiency in drafting and comprehending business requirement documents.

• Ability to work both independently and as part of a team.

Preferred Qualifications:

• Informatica Certified Professional (ICP) and/or Informatica Foundation Level Certifications (IDMC, CDCG, MDM etc.)

• Experience with database systems (e.g., Oracle, Postgres, MySQL). SQL Associate Certification an asset.

• Knowledge of data visualization tools (e.g., Qlik, Python, Power BI, SAP BO ).

Responsibilities:

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our finance systems.

• Develop and optimize complex SQL queries and stored procedures in PostgreSQL.

• Monitor daily/monthly jobs and resolve failures (if any)

• Collaborate with finance and insurance teams to understand data requirements and ensure data integrity and accuracy.

• Build Adhoc reports as per Business requirements.

• Perform data analysis and troubleshooting to resolve data-related issues.

• Implement data quality checks and validation processes.

• Provide solutions by building complexed Finance calculations using Postgres store procedure or ETL.

• Monitor and improve the performance of ETL processes and database systems.

• Document technical specifications and maintain comprehensive documentation of ETL processes and database schemas.

• Stay up to date with the latest industry trends and best practices in ETL and database management.