Senior ETL Developer

Zodiac Solutions Inc — Canada · Posted ~1 hour ago

Senior

Skills

ETL development Informatica PowerCenter IICS SQL Oracle MS SQL IDMC

🔓 Log in to save this job, tailor your resume & track your apply process — 7 days free, no card needed.

Log in to add to target list

Summary ✨ AI‑Generated

A large-scale technology environment is seeking a Senior ETL Developer to design and implement data integration solutions, optimize SQL processes, and support reliable data workflows.

Highlights

Experienced data engineering role focused on enterprise ETL solutions, data processing, reporting, and collaboration with business stakeholders.

Description

* 8–10 years of overall ETL development experience in large IT organizations * Minimum 5 years of strong hands-on development experience with Informatica PowerCenter and at least 2 years with IICS/IDMC * Design, develop, and implement ETL solutions using Informatica Intelligent Cloud Services (IICS) and IDMC * Translate detailed specifications into ETL process design and development * Analyze, design, develop, test, and document ETL processes following industry best practices * Strong hands-on experience in SQL with databases such as Oracle and MS SQL * Develop and optimize complex SQL queries for data processing and reporting * Build data sources, reports, dashboards, and KPIs to support business needs * Work with Subject Matter Experts and stakeholders to understand requirements and design data solutions * Perform unit testing and support SIT/QA and production troubleshooting * Use scripting languages such as VB, Shell, or Perl to support ETL processes * Collaborate with cross-functional Agile teams including developers, architects, and business analysts * Prepare design documentation, review artifacts, and provide training and support to users * Strong understanding of Agile methodologies and tools such as Jira and Bitbucket * Excellent communication, client management, and stakeholder engagement skills * Ability to solve complex problems and deliver high-quality solutions