Technology Lead - Informatica Developer

Job Description

We are seeking an experienced Informatica Developer to design, develop, and support enterprise data integration solutions across on-premise and cloud platforms. The ideal candidate will have hands-on experience with the complete project management life cycle - from requirements gathering and design through development, testing, deployment, and post-production support - along with strong technical expertise across Informatica PowerCenter, Cloud Data Integration (CDI-PC), and the Intelligent Data Management Cloud (IDMC) platform. This role requires strong UNIX shell scripting and SQL skills to build, optimize, and troubleshoot complex ETL/ELT workflows supporting business-critical data initiatives.

Required Qualifications:

• Candidates authorized to work for any employer in Canada without employer-based visa sponsorship are welcome to apply. Infosys is unable to provide immigration sponsorship for this role at this time.
• Candidate must be located within commuting distance of Mississauga, ON / Calgary, AB / Burnaby, BC or be willing to relocate to the areas.
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of Information Technology experience

Preferred Qualifications:

• Informatica PowerCenter (On-Premise) - mappings, workflows, transformations, scheduling
• Informatica Cloud Data Integration (CDI-PC)
• Informatica Intelligent Data Management Cloud (IDMC) - CDI, task flows, mapping tasks, connections
• Strong proficiency in SQL (complex queries, joins, stored procedures, performance tuning) on any major RDBMS (Oracle, SQL Server, Teradata, Snowflake, etc.)
• UNIX/Linux shell scripting for automation, job scheduling, and file/data handling
• Experience with ETL performance tuning and troubleshooting
• Knowledge of job scheduling tools (e.g., Autosys, Control-M) is a plus
• Familiarity with data warehousing concepts, dimensional modeling, and data governance practices
• End-to-end exposure to project phases: initiation, requirement analysis, design, build, testing, UAT, deployment, and warranty/support.
• Experience working in Agile/Scrum or Waterfall project environments.
• Ability to prepare and review technical design documents, test plans, and deployment plans.
• Experience coordinating with cross-functional teams (business, QA, infrastructure, DBA) to ensure on-time, quality delivery.
• Familiarity with change management, version control (e.g., Git), and release management practices.

Key Responsibilities:

• Participate in the complete project life cycle (PLC) - requirement gathering, analysis, design, development, unit testing, UAT support, deployment, and post-go-live support.
• Design, develop, and maintain ETL/ELT mappings, workflows, and sessions using Informatica PowerCenter (on-premise) and Cloud Data Integration (CDI-PC).
• Build and manage cloud-native data integration pipelines using Informatica Intelligent Data Management Cloud (IDMC), including CDI, CAI, and Mass Ingestion components as applicable.
• Analyze business and functional requirements and translate them into technical design documents (Source-to-Target mappings, ETL design specs).
• Develop and optimize complex SQL queries, stored procedures, and views for data extraction, transformation, and validation.
• Write and maintain UNIX shell scripts for job scheduling, file handling, automation, and workflow orchestration.
• Perform data profiling, data quality checks, and error handling within ETL processes.
• Conduct performance tuning of mappings, sessions, and SQL queries to improve throughput and reduce processing time.
• Collaborate with business analysts, DBAs, QA teams, and project managers throughout all SDLC/PLC phases.
• Prepare and maintain technical documentation, including design documents, unit test cases, and deployment/run-books.
• Support migration/upgrade activities from PowerCenter to IDMC/Cloud platforms.
• Troubleshoot production issues, perform root cause analysis, and implement permanent fixes.
• Adhere to coding standards, version control practices, and change management/release processes.
• Provide effort estimates, status updates, and risk assessments to project managers and stakeholders.

Nice to Have:

• Experience with cloud data warehouses (Snowflake, or Azure Synapse).
• Exposure to Informatica Cloud Application Integration (CAI) and API-based integrations.
• Knowledge of Python or other scripting languages for automation.
• Experience with CI/CD pipelines for data integration deployments.

Estimated annual compensation range for the candidate based in the below location will be:
Ontario:  $ 92740 to $ 123375
British Columbia: $ 90450 to $ 136500

The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Travel may be required as per the job requirements

EEO/About Us

About Us
Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

EEO
Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.