Senior Data Warehouse ETL Developer
Posted
Summary
Senior ETL developer who builds and maintains Informatica PowerCenter workflows loading flat files into an Oracle-based data warehouse, handles production support, bug fixes, data quality and performance tuning, and helps migrate toward a data lakehouse. Core stack: Informatica PowerCenter, Oracle 19c, SQL/PL-SQL, Unix shell and Perl scripting.
Key Responsibilities
- Develop and maintain ETL workflows using Informatica PowerCenter.
- Handle flat file to database transformation and loading.
- Perform production support, bug fixes, and DW enhancements.
- Identify and resolve data quality issues.
- Optimize Informatica workflows and SQL queries.
- Develop and maintain Unix Shell and Perl scripts.
- Write and optimize SQL and PL/SQL procedures.
- Analyze existing Data Warehouse systems and support migration to Data Lakehouse architecture.
Must-Have Skills
- 5+ years of Data Engineering / Data Warehousing experience.
- Strong hands-on experience in Informatica PowerCenter.
- Experience in ETL development (Flat File to DB).
- Strong knowledge of Oracle 19c.
- Proficiency in SQL and PL/SQL.
- Experience in Unix, Shell and Perl scripting.
- Strong understanding of Data Warehousing and data quality.
- Experience in production support and performance tuning.
Skills
Sign in to read and join the discussion.