Senior Informatica Developer

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

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
* 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

REQUIREMENTS:
* 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

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

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.

By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.