ETL/Informatica Lead


FutureTech Consultants LLC
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- SQL
- IBM Connect
- ETL
- Informatica
- PowerCenter
- Workload
Summary
Role : ETL/Informatica Lead
Location : Preferred location of Charlotte, Raleigh, NC, or Atlanta GA(Hybrid 3 days onsite)
Duration: 12+ months
W2 only
Key Responsibilities
ETL & Data Development:
- Design, develop, and maintain complex mappings, workflows, and sessions using Informatica PowerCenter or IICS.
- Write, optimize, and tune advanced SQL queries and stored procedures (SPO)
File Transfer & Integration:
- Configure and manage secure data file movements using IBM Sterling Connect: Direct across internal and external systems.
- Troubleshoot transmission failures, network node errors, and data encryption settings.
Scheduling & Automation:
- Build, monitor, and maintain automated batch schedules using CA ESP Workload Automation.
- Integrate Informatica jobs and Connect: Direct transfers cleanly into ESP application definitions and dependencies.
Support & Maintenance:
- Perform root-cause analysis for production scheduling abends, pipeline failures, and lag.
Required Qualifications:
- Experience: 8+ years in enterprise ETL development and production support.
Core Skills:
- Expert proficiency in Informatica PowerCenter/Cloud.
- Strong relational database and SQL/PL-SQL skills.
- Subject matter expert level related to IBM Connect: Direct for managed file transfers.
- Proven experience with CA ESP Workload Automation for job scheduling.
- Familiarity with Unix/Linux scripting for automation tasks.
- Dice Id: 10107680
- Position Id: 9045597
- Posted 6 hours ago
Company Info
About FutureTech Consultants LLC
Company Overview
Founded in 1997, FutureTech is a leader in information technology (IT) and business process services with the expertise and capabilities to serve the needs of businesses of all sizes serving clients world-wide. FutureTech provides end-to-end services through our flexible and cost efficient delivery model that combines onsite and offsite operations. Rooted in quality processes and frameworks, our goal is to fully satisfy client objectives, serving as an accountable, flexible and objective partner.
FutureTech is headquartered in Norcross, Georgia and we have sales offices located in Chicago and Dallas. We also have development facilities in Hyderabad, India.
Services and Capabilities
From providing consulting and systems integration services to managing IT and business functions on behalf of our clients, FTC provides an all-encompassing offering that includes the planning, design, development, implementation and management of highly effective business and IT environments. Our global delivery capabilities include onsite and offshore options, giving our clients the flexibility to choose the model that best meets their needs.
Through our vertical expertise in financial, government, healthcare, telecommunications, utilities, manufacturing, distribution and retail services, we provide clients with a partner that is not only expert in IT, but expert in their industries. This combination of business knowledge and technology expertise allows us to help our clients adapt as their industries change.


Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs