Cognizant
Informatica Developer - IDMC, IICS, IDQ
Cognizant, Charlotte, North Carolina, United States, 28245
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.
Work Arrangement 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 support a healthy work‑life balance through our various wellbeing programs.
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
Salary And Other Compensation Applications will be accepted until October 20th, 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
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.
Seniority level Entry level
Employment type Full‑time
Job function Other
Industries IT Services and IT Consulting and Business Consulting and Services
Referrals Referrals increase your chances of interviewing at Cognizant by 2x.
#J-18808-Ljbffr
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.
Work Arrangement 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 support a healthy work‑life balance through our various wellbeing programs.
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
Salary And Other Compensation Applications will be accepted until October 20th, 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
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.
Seniority level Entry level
Employment type Full‑time
Job function Other
Industries IT Services and IT Consulting and Business Consulting and Services
Referrals Referrals increase your chances of interviewing at Cognizant by 2x.
#J-18808-Ljbffr