Informatica Developer - IDMC, IICS, IDQ

ETL Developer

In this role, you will:

• Design, develop, and manage ETL workflows using Informatica PowerCenter, IICS, and IDMC to meet enterprise data integration needs.
• Configure and maintain Oracle database connections, including connection strings, authentication, and access control.
• Develop and troubleshoot federated SQL queries across SQL/Oracle/Sybase/DB2 systems.
• Conduct analysis of existing workflows built using DVL and lead their migration to modern platforms as part of the DVL Migration initiative.
• Conduct analysis of existing workflows built for PeopleSoft project and lead their migration to modern platforms as part of the PeopleSoft to SAP Migration initiative.
• Troubleshoot and resolve Oracle DB connectivity issues such as TNS resolution errors and host configuration challenges.
• Demonstrate expert-level proficiency in Informatica Designer, with in-depth understanding of all transformation types and mapping logic.
• Analyze and resolve session failures, identify root causes, and implement corrective actions to ensure data pipeline reliability.
• Lead or support the migration of legacy ETL processes from on-premise platforms (e.g., PowerCenter) to cloud-based environments like IICS and IDMC.
• Monitor ETL job executions, analyze logs, and collaborate with DBA and infrastructure teams for timely issue resolution.
• Document and maintain SOPs for connection setup, job scheduling, and access provisioning using tools such as Jenkins and Control-M.

IDMC-Specific Responsibilities:

• Leverage IDMC's AI-powered data integration and metadata-driven architecture to automate and optimize data pipelines.
• Implement real-time and batch ingestion using IDMC's native connectors for cloud and on-premise systems.
• Integrate data quality, cataloging, and governance features within IDMC to ensure trusted and compliant data delivery.
• Collaborate with architects to design cloud-native, scalable, and reusable data pipelines.

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role's business requirements, this is a hybrid position requiring 2-3 days a week in a client or Cognizant office in Charlotte, NC. Regardless of your working arrangement, we are here to support a healthy work-life balance through our various wellbeing programs.

The working arrangements for this role are accurate as of the date of posting. This may change based on the project you're engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.

What you need to have to be considered:

• ETL Tools: Informatica PowerCenter v10.x, Informatica Cloud (IICS), Informatica Intelligent Data Management Cloud (IDMC), Informatica MDM, Informatica IDQ
• Data Movement: Change Data Capture (CDC) implementation and tuning
• Databases: Oracle SQL, PL/SQL, Sybase, RDS, and advanced SQL techniques
• Scripting: Unix/Linux shell scripting, Python.
• Data Warehousing: SCD types (1/2/3), dimensional modeling, performance tuning
• DevOps & Scheduling: GitHub, Jenkins, Control-M

We're excited to meet people who share our mission and can make an impact in a variety of ways. Don't hesitate to apply, even if you only meet the minimum requirements listed. Think about your transferable experiences and unique skills that make you stand out as someone who can bring new and exciting things to this role.

Salary and Other Compensation:

Applications will be accepted until October 20, 2025.

The annual salary for this position is between $68,000 - $109,000 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

What we offer:

• The chance to work with impact. Here, you're empowered to bring your biggest thinking to help our company and clients improve everyday life.
• Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
• The opportunity to thrive on a high caliber team with heart. We celebrate each other's experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
• A comprehensive total rewards package, including a competitive salary and pension plan with matching contributions.
• Flexible health and financial benefits to support you and your eligible dependents from day one.
• True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.

About us Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World's Best Employers 2024) is consistently listed among the most admired companies in the world.

Other employment-related information Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other characteristic protected by federal, provincial or local laws.

If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email CareersNA2@cognizant.com with your request and contact information.

Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you'll deliver services to and collaborate with stakeholders outside the province who may not speak French.