Position Overview
We are seeking Informatica ETL Developers to support a healthcare client based in Washington DC. The primary responsibilities include designing, implementing, and testing Informatica Powercenter workflows and mappings.
Key Responsibilities
Design and Development:
- Create data mappings and workflows using Informatica Powercenter to extract, transform, and load data into target environments (e.g., batch files, databases).
- Develop technical design documents and test plans for ETL unit and integration testing.
- Collaborate with functional and integration teams on architecture and design.
- Develop ETL workflows and mappings from ODS to Datawarehouse using Informatica Powercenter.
Optimization And Standards
- Tune and optimize ETL batch jobs for performance and throughput.
- Adhere to Informatica workflow and mapping standards to ensure consistent development practices (e.g., avoiding hard coding, leveraging mapplet/reuse concepts).
Support And Troubleshooting
- Provide development support and mentor junior developers.
- Assist with troubleshooting ETL batch job issues in production, PreProd, QA, and UAT environments.
- Support infrastructure and development teams.
Additional Skills
- Experience in Informatica Powercenter installation, administration, and configuration is a plus.
- Familiarity with Informatica Powercenter HTTP Adapter, JMS Adapter, and Webservices Hub is desirable.