> Markdown version of [/jobs/ext/2709338-informatica-pentaho-etl](https://www.wearedevelopers.com/jobs/ext/2709338-informatica-pentaho-etl). 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 Pentaho ETL

- **Company:** ONE STOP COLLECTIBLE CORP
- **Location:** Spartanburg, SC, United States
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Unit Testing, Big Data, Cloud Computing, Databases, Extract Transform Load (ETL), Data Mapping, Data Mining, Data Warehousing, PostgreSQL, Unix Shell, Microsoft Visio, Oracle (Applications), Microsoft PowerPoint, SQL Stored Procedures, PL-SQL, Test Data, Freeform SQL, Snowflake, Star Schema
- **Published:** September 4, 2026
- **Apply:** https://startup.jobs/pentatho-developer-pull-skil-6354034

## About the Role

* Extensively worked on data extraction, Transformation and loading data from various sources like databases (PostgreSQL, Oracle) and Flat files.
 * Experience working on large volume data
 * Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
 * Knowledge and Experience with Informatica Power exchange
 * Hands on Experience with Informatica 's Data Quality Tool is a plus
 * Strong experience in Data Warehousing and ETL using Informatica Power Center 9.x/10.x
 * Had experience in data modeling using Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
 * Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
 * Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
 * Extensive experience in ETL design, development and maintenance using Informatica Power Center v 9.x/10.x
 * Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
 * Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
 * Well versed in UNIX shell scripting along with Informatica CLI commands to start, schedule workflows.
 * Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
 * Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.
 * Experience with Requirements gathering, understanding user requirements and coming up with effective designs and development of solution
 * Client plans to migrate from on-Prem to Cloud soon. So good understanding on Cloud methodology, technology and commonly used tools

Extensive work experience on data extraction and large volume data

Experience working with Informatica Power exchange

Experience in data modeling using Star Schema Modeling, and Snowflake modeling

UNIX shell scripting along with Informatica CLI commands

Good understanding on Cloud methodology, technology and commonly used tools



## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [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)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean)

## Related Articles

- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [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)
- [Data Science & more: The Lopez dilemma](https://www.wearedevelopers.com/magazine/10-data-science-more-the-lopez-dilemma)
- [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)