> Markdown version of [/jobs/ext/2546669-etl-with-informatica-power-center](https://www.wearedevelopers.com/jobs/ext/2546669-etl-with-informatica-power-center). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# ETL with Informatica Power Center

- **Company:** VDart, Inc.
- **Location:** Charlotte, NC, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Cloud Computing, Extract Transform Load (ETL), Data Security, Relational Databases, Database Development, File Transfer, Job Scheduling, SQL Stored Procedures, PL-SQL, SQL Databases, Scripting, Freeform SQL, Informatica Powercenter, IBM Sterling Suite
- **Published:** August 5, 2026
- **Apply:** https://www.dice.com/job-detail/6c702f59-d4e1-4996-9aaa-96b3b2dc0fa4

## About the Role

* Experience: 5+ years in enterprise ETL development and production support. [1]
 * 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. [1, 2, 3]

## Description

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). [1, 2, 3, 4]
 * 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. [1]
 * 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. [1]
 * Support & Maintenance:
 * Perform root-cause analysis for production scheduling abends, pipeline failures, and lag. [1]


## Related Videos

- [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java)
- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [Intermediate Bitcoin Script](https://www.wearedevelopers.com/videos/25-intermediate-bitcoin-script)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Oops! Stories of supply chain shenanigans](https://www.wearedevelopers.com/videos/245-oops-stories-of-supply-chain-shenanigans)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Best Paying Jobs in Technology](https://www.wearedevelopers.com/magazine/256-best-paying-jobs-in-technology)