"Alerted.org

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 troubleshooting 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 though 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 th , 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.

Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.