Senior ETL / Informatica Administrator Location: Charlotte, NC Duration: Long term
Seeking a Senior ETL / Informatica Administrator.
Required skills: python, node, sql, aws. Preferred skills: azure, rest.
We are looking for a skilled Informatica Developer to design, develop, and maintain scalable ETL (Extract, Transform, Load) solutions using Informatica PowerCenter, Informatica Cloud (IICS), and Informatica Intelligent Data Management Cloud (IDMC).
The ideal candidate will also have hands-on experience with Informatica MDM, Informatica Data Quality (IDQ), and Change Data Capture (CDC), along with strong Oracle database expertise.
This role is key to enabling seamless data integration, data governance, and modernization through cloud migration.
Primary Responsibilities: 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.
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
Never miss an opportunity! Create an alert based on the job you applied for.