Technology Lead - Informatica Developer

Infosys Limited Digital • $92K — $123K *
Calgary, AB T1Y 7M8In-Person
Information Technology
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 5-7 years of hands-on experience in Informatica development and data integration solutions.
  • Proficient in UNIX/Linux shell scripting and SQL for complex ETL processes.
  • Bachelor's degree in relevant field or equivalent experience in IT.
  • Deep understanding of Informatica PowerCenter, Cloud Data Integration, and Intelligent Data Management Cloud.
  • Experience with project management life cycles from requirement gathering to post-production support.

Responsibilities

  • Engage in the full project lifecycle from requirements to deployment and support.
  • Design and develop ETL/ELT processes using Informatica tools.
  • Build and manage cloud-native data integration pipelines in IDMC.
  • Translate business requirements into technical designs and documentation.
  • Optimize SQL queries and maintain efficient workflows in ETL.
  • Write UNIX shell scripts for job automation and scheduling.
  • Collaborate with cross-functional teams for integrated project delivery.

Benefits

  • Possibility of remote work arrangements depending on project needs.
  • Opportunities for professional development and training.
  • Access to modern data integration tools and technologies.
  • Participation in a collaborative and agile project environment.
  • Access to supportive cross-functional teams for project success.
Full Job Description
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, Ontario/Calgary, Alberta 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

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

About Infosys Limited Digital

Infosys Limited Digital Careers

Joining Infosys Limited Digital offers a unique opportunity to be part of a global team of professionals who are at the forefront of digital innovation and transformation. Infosys Limited Digital is renowned for its commitment to leadership in technology services and consulting, making it an ideal place for ambitious individuals seeking growth and career advancement.

Explore Job Opportunities

Infosys Limited Digital is actively seeking talented individuals to join their team. With a variety of job opportunities available, candidates can find positions that match their skills and interests. The company values diversity and inclusivity, ensuring that all team members have the opportunity to contribute to their fullest potential.

Experience Professional Growth

At Infosys Limited Digital, professional growth is a priority. The company offers comprehensive benefits and diversity training programs that support both personal and professional development. Employees are encouraged to take leadership roles within projects, fostering a culture of innovation and continuous improvement.

Engage in Meaningful Work

Employees at Infosys Limited Digital engage in projects that transform businesses and industries worldwide. By leveraging cutting-edge technology and deep industry expertise, the team delivers solutions that meet the complex demands of today's digital landscape.

Internship Programs

For those starting their careers, Infosys Limited Digital’s internship programs provide a robust platform for learning and development. Interns gain hands-on experience, working alongside seasoned professionals on real-world projects. This not only enhances their skills but also prepares them for future employment opportunities within the company.

Join a Collaborative Team

Infosys Limited Digital prides itself on its collaborative culture. Team members from around the globe come together to share ideas and strategies, ensuring the best outcomes for clients and stakeholders. Networking within the company is highly encouraged, opening doors to myriad opportunities for career advancement.

Prepare for Your Interview

When applying for a position at Infosys Limited Digital, it is crucial to tailor your resume to highlight relevant experience and skills. Preparation for the interview process is key, as it is a chance to demonstrate how your background aligns with the company’s needs and values.

Stay Connected with Career Insights

Keep up to date with the latest in career opportunities and industry trends by subscribing to Infosys Limited Digital’s career blog. Gain insights from insiders and stay informed about new openings and company news.

Apply Now

Discover the exciting and rewarding career opportunities at Infosys Limited Digital. Search for open positions that align with your professional skills and interests. Infosys Limited Digital is looking for passionate, curious, and innovative team players ready to make a significant impact in the digital world.

SEARCH INFOSYS LIMITED DIGITAL JOBS

READ CAREERS BLOG

Job Alert Emails

Customize your subscription to receive job alerts and insider tips tailored to your preferences. Explore the diverse and dynamic career paths available at Infosys Limited Digital.
Learn more about Infosys Limited Digital
Industry
Information Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Infosys Limited Digital

More Information Technology Jobs

Find similar Technology Lead - Informatica Developer jobs:

NationwideCalgary, AB