At a Glance
- Tasks: Design and implement ETL solutions using Informatica PowerCenter and IICS.
- Company: Join a leading IT organization with a focus on innovation.
- Benefits: Competitive salary, health benefits, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on continuous learning and development.
- Why this job: Make an impact by developing data solutions that drive business success.
- Qualifications: 8-10 years of ETL experience, strong SQL skills, and Agile methodology knowledge.
The predicted salary is between 97470 - 119130 $ per year.
Senior Informatica Power Center 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 Power Center 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).
#J-18808-Ljbffr
Senior Informatica PowerCenter Developer in Toronto employer: Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Astra-North Infoteck Inc. is an exceptional employer located in the vibrant city of Toronto, offering a dynamic work culture that fosters innovation and collaboration. Employees benefit from comprehensive growth opportunities, including mentorship programs and access to cutting-edge technology, all while working in a supportive environment that values diversity and creativity. Join us to be part of a forward-thinking team that is shaping the future of cloud-based solutions and AI.
Contact Details:
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision! Recruitment Team
