Senior Informatica Developer

Kforce has a client that is seeking a Senior Informatica Developer in Charlotte, NC. Duties:

• Senior Informatica Developer 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
• As a Senior Informatica Developer, you will 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
• 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