Senior Informatica PowerCenter Developer - IDMC / IICS
- Toronto, ON, Canada
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original job description
Senior Informatica PowerCenter Developer - IDMC / IICS
Key Requirements & Responsibilities
- 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.
Eligibility
- Must be eligible for Reliability Status Clearance (Minimum 5 years residency requirement).
More about this job
Responsibilities
The Senior Informatica PowerCenter Developer at Astra North Infoteck Inc. will build and test data integration processes from detailed specifications, write and tune SQL, create reports and dashboards, and work with stakeholders and Agile teams. The role also covers production troubleshooting and user training.
Requirements
Candidates need 8 to 10 years of ETL development, at least 5 years of hands-on PowerCenter and 2 years of IICS/IDMC, and strong SQL on Oracle and MS SQL. Reliability Status clearance eligibility with 5 years of residency is required.
Skills
- Informatica PowerCenter
- Informatica IICS
- IDMC
- ETL development
- SQL
- Oracle
- Microsoft SQL Server
- Query optimization
- Shell scripting
- Perl
- VB
- Unit testing
- SIT/QA support
- Production troubleshooting
- Jira
- Bitbucket
- Agile methodologies
- Technical documentation
- Stakeholder management
- Report and dashboard development
- Data warehousing
- KPI development
- Client management
- Training and user support
Categories
- Software
- Technology
- Data & Analytics
Keywords
- Informatica PowerCenter
- IICS
- IDMC
- Informatica Intelligent Cloud Services
- ETL
- SQL
- Oracle
- MS SQL
- Shell scripting
- Perl
- VB
- Jira
- Bitbucket
- Agile
- data warehousing
- reporting
- dashboards
- KPIs
- Reliability Status
- data integration
Seniority
Senior
Tools
- Informatica PowerCenter
- Informatica IICS
- IDMC
- Oracle
- MS SQL
- Jira
- Bitbucket
- Shell
- Perl
- VB
Languages
- English