Senior Data Warehouse ETL Developer (Informatica PowerCenter)
Summary
Hands-on development, maintenance, and performance tuning of an enterprise Data Warehouse built on Informatica PowerCenter and Oracle 19c. The role fixes data quality issues, develops ETL workflows (flat file to DB loads) with Perl/Shell and PL/SQL, and supports a migration toward a modern Data Lakehouse architecture.
ROLE OVERVIEW
We are seeking an experienced Data Engineer.
This role focuses on hands-on development, maintenance, and performance optimization within an enterprise Data Warehouse environment built on Informatica PowerCenter and Oracle 19c.
The candidate will address production DW enhancements, resolve data quality issues, and assist in addressing functional queries to facilitate migration toward a modern Data Lakehouse architecture.
2. TECHNICAL COMPETENCIES NEEDED
Informatica Powercenter, Unix-Perl and Shell Scripting, SQL and PL-SQL, Oracle 19c, Data Warehousing
. KEY RESPONSIBILITIES
Hands-on development experience in Informatica Powercenter especially on flat file to DB transform and load. Responsible for working on data quality fixes, performance improvement of Informatica workflows.
Responsible for carrying out development, enhancement, and bug fixes in production DW using Informatica, Perl, Shell, and PL-SQL.
Responsible for studying existing DW platform (based on Oracle and Informatica) and propose solutions to mitigate data quality and logic gaps wherever applicable. Responsible for addressing functional queries related to DW functionality to help migration or transformation to Data Lakehouse.
Skills
Sign in to read and join the discussion.