Senior Informatica Developer
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
- 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
Recommended Jobs
Sr Field Safety Training Coordinator NC (Bird Electric)
Job Summary Bird Electric, a Black & Veatch company, is a U.S. self-perform electrical construction services provider with a national reach in emergency power restoration. Bird Electric delivers g…
AWS Solution Architect
Zone IT Solutions is seeking a skilled AWS Solution Architect. In this position, you will be responsible for designing and implementing robust and scalable AWS solutions that meet our clients' busine…
Flooring Installer
Flooring Installer Make more with Refloor. Earn $3,000-$6,000 per week ($156,000 - $312,000 per year). Take your income to the next level! At Refloor, growing your earnings has never been easie…
Unlimited or Limited - Licensed Residential Electrician
Job Description Company Name: ARS-Rescue Rooter Overview: American Residential Services is the largest provider of residential services in the US, employing more than 7000 professionals across th…
Administrative Office Assistant Job- Work from Home
Work from Home Data Entry & Office Administration – Remote Online Role About the Job We are seeking motivated individuals in Wilmington, Delaware, United States , for an entry-level remo…
Project Engineer
At ABB, we help industries outrun - leaner and cleaner. Here, progress is an expectation - for you, your team, and the world. As a global market leader, we'll give you what you need to make it happen.…
Pediatric Intensive Care Unit Registered Nurse (PICU RN)
Pediatric Intensive Care Unit Registered Nurse (PICU RN) - Travel Position Location: Asheville, NC Job Type: Travel Contract Duration: 13 weeks Shift: 3x12s Nights Pay: $1815/…
Occupational Therapist / OTR / OT / OTR/L - Full Time
Occupational Therapist / OTR / OT Broad River Rehab is seeking an Occupational Therapist / OTR to join our Fayetteville, NC Skilled Nursing Facility. Fulltime - Flexible Schedule New Graduates…
Senior Engineer, Mechanical
Come Build Your Career at Aecon! As a North American leader in infrastructure development, Aecon is safely and sustainably building what matters for future generations to thrive! We lead some…
Assistant Program Director of MS & HS Programming
Power Cross Ministries is seeking a strong Christian leader to serve as a full-time Assistant Program Director for Middle School & High School athletes . This role works directly under our current …