Informatica Developer

Tekshapers

Toronto

On-site

CAD 90,000 - 120,000

Full time

5 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Tekshapers in Canada is seeking an experienced ETL developer to lead the design, development, and optimization of large-scale data integration using Informatica PowerCenter and IICS/IDMC in a Toronto-based role. You will translate specifications into ETL designs, develop processes, write complex SQL for data processing and reporting, and build data sources, dashboards, and KPIs to support business needs.

You will collaborate with SMEs and agile teams, document designs, and support SIT/QA and

Qualifications

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.
Must be eligible for Reliability Status Clearance (Minimum 5 years residency requirement)

Responsibilities

Translate detailed specifications into ETL process design and development.
Design, develop, and implement ETL solutions using Informatica IICS/IDMC.
Analyze, design, develop, test, and document ETL processes following industry best practices.
Develop and optimize SQL queries for data processing and reporting.
Build data sources, reports, dashboards, and KPIs to support business needs.
Collaborate with SMEs and stakeholders to understand requirements and design data solutions.
Perform unit testing and support SIT/QA and production troubleshooting.
Prepare design documentation, review artifacts, and provide training and support to users.
Work with Agile teams (Jira/Bitbucket) to deliver solutions.
Communicate effectively with clients and stakeholders to ensure requirements are met.