> Markdown version of [/jobs/ext/3285910-data-warehouse-etl-developer-informatica-developer](https://www.wearedevelopers.com/jobs/ext/3285910-data-warehouse-etl-developer-informatica-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).

---

# Data Warehouse ETL Developer/Informatica Developer

- **Company:** The Dignify Solutions LLC
- **Location:** New York, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Unit Testing, Code Review, Data Validation, Data Governance, Data Integration, Extract Transform Load (ETL), Data Warehousing, Database Queries, Dimensional Modeling, Microsoft SQL Server, Oracle (Applications), Performance Tuning, SAP (Applications), PL-SQL, SQL Databases, Data Streaming, Informatica Powercenter, Information Technology, Software Version Control
- **Published:** September 30, 2026
- **Apply:** https://www.dice.com/job-detail/ba05a61e-784f-4896-99d0-c3a89a704784

## About the Role

* Bachelor's degree in Computer Science, Information Technology, or a related field.
 * 8-10+ years of experience in ETL development using Informatica PowerCenter .
 * Strong understanding of data warehousing concepts , dimensional modeling, and star/snowflake schemas.
 * Experience with SQL, PL/SQL , and performance tuning of database queries.
 * Knowledge of data quality, data governance, and best practices in ETL development.
 * Strong analytical, problem-solving, and communication skills.
 * Experience with version control systems and ETL deployment processes., * Exposure to real-time ETL and data streaming technologies.
 * Knowledge of scheduling tools such as Informatica Workflow Manager and IBM Workload Automation

## Description

We are seeking a skilled Data Warehouse / ETL Developer with expertise in Informatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The ideal candidate will have hands-on experience in data warehousing concepts, ETL processes, and strong problem-solving skills to ensure high-quality, timely, and accurate data integration., * Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter.

 * Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments.
 * Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions.
 * Optimize ETL processes for performance, scalability, and maintainability.
 * Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity.
 * Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents.
 * Participate in code reviews, unit testing, and UAT support.
 * Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements.
 * Provide production support and resolve data-related issues in a timely manner.


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Are you still programming unit tests or already generating?](https://www.wearedevelopers.com/videos/722-are-you-still-programming-unit-tests-or-already-generating)
- [Are Code Reviews Worth It? Insights from 16 Years of Review Data](https://www.wearedevelopers.com/videos/1135-are-code-reviews-worth-it-insights-from-16-years-of-review-data)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [How Unit Testing Saved My Career](https://www.wearedevelopers.com/videos/1642-how-unit-testing-saved-my-career)
- [Build a CI/CD pipeline to automate code reviews and ensure code quality](https://www.wearedevelopers.com/videos/349-build-a-ci-cd-pipeline-to-automate-code-reviews-and-ensure-code-quality)

## 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)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)