Job Description:
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: 5+ 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.
- Preferred location of Charlotte, Raleigh or Atlanta
