Jobs via Dice
Senior Informatica Developer – Charlotte, NC
Join to apply for the
Senior Informatica Developer
role at
Jobs via Dice .
Job Details Seniority level:
Mid-Senior level Employment type:
Full-time
Responsibilities
Design, develop, and manage ETL workflows using Informatica PowerCenter, IICS, and IDMC.
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.
Analyze existing workflows built with DVL and lead their migration to modern platforms as part of the DVL Migration initiative.
Analyze existing workflows built for PeopleSoft projects 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 deep 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.
Requirements
Proficiency with Informatica PowerCenter v10.x, Informatica Cloud (IICS), Informatica Intelligent Data Management Cloud (IDMC), Informatica MDM, and Informatica IDQ.
Experience with Change Data Capture (CDC) implementation and tuning.
Strong knowledge of Oracle SQL, PL/SQL, Sybase, and advanced SQL techniques.
Unix/Linux shell scripting and Python scripting skills.
Data warehousing experience: SCD types (1/2/3), dimensional modeling, and performance tuning.
DevOps and scheduling experience with GitHub, Jenkins, and Control-M.
Compensation Pay range: $75,300.00 – $143,100.00 (subject to change based on qualifications and business needs).
Benefits Medical, dental, and vision insurance; HSA and FSA; 401(k); life, disability, and accident & disease insurance; paid time off for salaried personnel.
Equal Opportunity Statement Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
#J-18808-Ljbffr
Senior Informatica Developer
role at
Jobs via Dice .
Job Details Seniority level:
Mid-Senior level Employment type:
Full-time
Responsibilities
Design, develop, and manage ETL workflows using Informatica PowerCenter, IICS, and IDMC.
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.
Analyze existing workflows built with DVL and lead their migration to modern platforms as part of the DVL Migration initiative.
Analyze existing workflows built for PeopleSoft projects 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 deep 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.
Requirements
Proficiency with Informatica PowerCenter v10.x, Informatica Cloud (IICS), Informatica Intelligent Data Management Cloud (IDMC), Informatica MDM, and Informatica IDQ.
Experience with Change Data Capture (CDC) implementation and tuning.
Strong knowledge of Oracle SQL, PL/SQL, Sybase, and advanced SQL techniques.
Unix/Linux shell scripting and Python scripting skills.
Data warehousing experience: SCD types (1/2/3), dimensional modeling, and performance tuning.
DevOps and scheduling experience with GitHub, Jenkins, and Control-M.
Compensation Pay range: $75,300.00 – $143,100.00 (subject to change based on qualifications and business needs).
Benefits Medical, dental, and vision insurance; HSA and FSA; 401(k); life, disability, and accident & disease insurance; paid time off for salaried personnel.
Equal Opportunity Statement Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
#J-18808-Ljbffr