> Markdown version of [/jobs/ext/2012307-informatica-extract-transform-load-etl-developer](https://www.wearedevelopers.com/jobs/ext/2012307-informatica-extract-transform-load-etl-developer). 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). --- # Informatica Extract, Transform, Load (ETL) Developer - **Company:** CLOUDSCOUTS SOFTWARE SOLUTIONS LLC - **Location:** United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Agile Methodology, Bash Shell, Unix, Information Systems, Computer Programming, Databases, Data Integration, Extract Transform Load (ETL), Data Mart, Data Recovery, Data Systems, Data Warehousing, IBM DB2, Relational Databases, Job Scheduling, Korn Shell, Unix Shell, Metadata, Microsoft SQL Server, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Standard Sql, Requirements Management, SQL Databases, System Testing, Scripting, Freeform SQL, Informatica Powercenter, Integration Tests, Information Technology - **Published:** August 10, 2026 - **Apply:** https://www.careerbuilder.com/job-details/informatica-powercenter-with-healthcare-exp-w2-only-no-c2c--98666cf8-14d6-48ce-b73d-6f139708f5db ## About the Role We are seeking a highly experienced Informatica Extract, Transform, Load (ETL) Developer to join our Enterprise Data Warehouse (EDW) team. This role is responsible for designing, developing, and maintaining robust ETL processes using Informatica PowerCenter and Oracle. The ideal candidate will have a deep understanding of data integration, performance tuning, and data warehousing best practices, with a focus on supporting healthcare-related data systems. Total 10 years of exp on Informatica/Oracle/SQL/IDQ 3+ years of recent Healthcare exp is must, * 7+ years of experience with Informatica PowerCenter and ETL development. * 5+ years of experience writing complex SQL and performance tuning. * 5+ years of experience with Enterprise Relational Database Management systems ( DB2, Oracle, or SQL Server) * 5+ years of Informatica PowerCenter administration experience. * Strong communication, collaboration, and mentoring skills. * Bachelor's or advanced degree in IT, Computer Science, Mathematics, or a related field. * Strong organizational and time management skills. Preferred Qualifications: * 5+ years of data warehouse development experience. * 5+ years of data modeling experience using ERWIN or similar tools. * 2+ years of Unix Shell (Bash/Korn) scripting experience. * Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager. * Experience with Medicaid, Medicare, or healthcare data systems. * Experience working in Agile environments. * Knowledge of BI and data integration technologies across relational and multidimensional systems., Administrative Skills, Agile Programming Methodologies, Bash Scripting, Best Practices, Business Intelligence, Career Development, Communication Skills, Computer Science, Data Mart, Data Modeling, Data Quality, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Healthcare, IBM DB2, Informatica, Information Technology & Information Systems, Integration Testing, Leadership, Mathematics, Medicaid, Medicare, Mentoring, Metadata, Microsoft SQL Server, Oracle, Oracle Database, Organizational Skills, Performance Tuning/Optimization, Process Improvement, Production Systems, Project Planning, Query Optimization, Relational Databases (RDBMS), Requirements Management, SQL (Structured Query Language), Scripting (Scripting Languages), System Test, Systems Maintenance, Team Player, Technical Support, Technical Writing, Test Plan/Schedule, Testing, Time Management, Unix Operating Systems, Unix Shell Programming, erwin Data Modeler ## Description * Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various agency sources. * Automate data staging processes and optimize ETL job scheduling for performance and efficiency. * Administer and support ETL environments, including development and production systems. * Perform repository backups, recovery operations, and system maintenance. * Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica transformations. * Monitor and troubleshoot ETL jobs across development, testing, and production environments. * Write and optimize complex SQL queries and Unix Shell scripts for data marts * Collaborate with stakeholders to define requirements, document technical solutions, and support project planning. * Participate in unit, integration, and system testing. * Provide technical support, mentoring, and guidance to team members. * Communicate project status and deliverables to leadership and clients. * Continuously learn and apply new technologies to enhance system performance and capabilities. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata) - [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security) - [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) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)