Senior Informatica PowerCenter Developer - IDMC / IICS
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Senior Informatica PowerCenter Developer - IDMC / IICS
Key Requirements & Responsibilities
• 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.
Eligibility
- Must be eligible for Reliability Status Clearance (Minimum 5 years residency requirement).
More about this job
Responsibilities
Design, develop, test, document, and optimize ETL solutions using Informatica PowerCenter, IICS, and IDMC, including complex SQL processing and reporting. Collaborate with stakeholders and Agile teams to deliver data solutions, support testing and production troubleshooting, and provide documentation, training, and user support.
Requirements
Requires 8–10 years of overall ETL development experience, including at least 5 years with Informatica PowerCenter and 2 years with IICS/IDMC, plus strong SQL experience with Oracle and Microsoft SQL Server. Candidates should have scripting experience, Agile collaboration and communication skills, and eligibility for Reliability Status Clearance, including a minimum five-year residency requirement.
Skills
- Informatica PowerCenter
- Informatica Intelligent Cloud Services (IICS)
- IDMC
- ETL Development
- SQL
- Oracle
- Microsoft SQL Server
- Data Modeling
- Dashboard Development
- KPI Reporting
- Unit Testing
- Production Troubleshooting
- VB Scripting
- Shell Scripting
- Perl
- Agile Methodologies
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Consulting
Keywords
- ETL
- Informatica PowerCenter
- Informatica Intelligent Cloud Services (IICS)
- IDMC
- SQL
- Oracle
- Microsoft SQL Server
- ETL Process Design
- Data Processing
- Reporting
- Data Sources
- Dashboards
- KPIs
- Unit Testing
- SIT
- Quality Assurance
- Production Troubleshooting
- VB
- Shell
- Perl
- Agile
- Jira
- Bitbucket
- Stakeholder Engagement
- Reliability Status Clearance