Informatica Developer

Role: Developer. Skills: Azure, MS SQL Server, Oracle. Experience: 5 - 8 Years

Inclusion without Exception

Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our people stories across our workforce and implemented through equitable workplace policies and processes.

TCS has been serving the Canadian marketplace for more than 35 years and today is the technology partner of choice for many of the country's leading organizations. As one of the largest IT services providers in Canada and globally, TCS is aiming to become the world's largest AI-led technology services company and is enabling its clients to transform themselves across the full AI stack, from infrastructure to intelligence.

Rooted in the heritage and values of the Tata Group, TCS is focused on creating long-term value for its clients, investors, employees, and the communities it serves. With a highly skilled workforce supporting customers from coast to coast, TCS has consistently been recognized as a Top Employer by the Top Employers Institute, including a recent top ranking at the country level.

TCS also sponsors 14 of the world's most prestigious marathons and endurance events, including the TCS Toronto Waterfront Marathon, reflecting its commitment to health, sustainability, and community empowerment.

JD - Senior Informatica Developer with Admin skills

We are seeking a Senior Informatica Developer with Admin skills to join a Global Enterprise Technology Team responsible for the development, modernization, security and operational reliability of mission critical information distribution systems.

Required Skills:

· Good years of experience in ETL development for a data warehouse.

· Strong expertise in Informatica ETL Development, proficiency in ETL processes and data integration methodologies

· Good knowledge in administration, including installation, configuration, and maintenance

· Hands-on experience in development, maintenance, and enhancements of Informatica PCD, Mappings, Workflows, and processes.

· Experience in migrating on prem Informatica Power Center to Cloud using CDI-PC

· Experience in working both on prem and cloud Informatica PC

· Experience in IDMC infrastructure, MS Azure Entra Apps for SSO and REST API access and configuration

· Experience with performance tuning and optimization of Informatica workflows

· Solid understanding of database technologies (e.g., Oracle, SQL Server) and data warehousing concepts

· Need to be able to upgrade Informatica (PC) as well as manage all admin issues including patching in Windows environment

· Also able to development work loading data from SQL to DWH (Facts and dimensions)

· Strong on SQL plus loading incremental data to DWH

· Experience working with complex SQL.

· Expertise with integration technologies and processes.

· Must have both Informatica development and Admin activities.

· Experience with monitoring and observability tools such as Splunk, Grafana, Promotheus or OpenTelemetry

· Interest in DevSecOps, Platform Engineering and large-scale modernization initiatives

· Experience working with Query Surge.

· Experience with Linux and Windows environments.

· Possess knowledge of testing tools and techniques.

· Excellent problem-solving skills and the ability to work under pressure

· Strong communication skills, both verbal and written, to effectively collaborate with cross functional teams

Thank you for your interest in TCS. Candidates that meet the qualifications for this position will be contacted within a 2-week period. We invite you to continue to apply for other opportunities that match your profile.