Description

Develop and maintain ETL processes for a multi-terabyte, 24/7 Oracle data warehouse.

Responsibilities

• Develop and enhance Informatica PowerCenter ETLs from diverse data sources to Oracle.
• Design, implement, and test ETL components for multiple applications.
• Perform Oracle Database and SQL tuning to optimize performance.
• Conduct unit and development testing for Informatica ETL workflows.
• Provide data analysis, troubleshooting, and post-production application support.

Required Skills

• 5+ years of experience in ETL development.
• Expertise in Informatica PowerCenter.
• Advanced PL/SQL development skills.
• Strong Oracle Database tuning and SQL tuning capabilities.
• Experience working within Solaris environments.
• Ability to manage and maintain high-volume, multi-terabyte data warehouse applications.
• Experience with Informatica Server administration.

Key Skills

Education

Any Graduate