Description

You will develop and enhance ETL processes from various sources into an Oracle data warehouse.

Responsibilities

• Perform advanced ETL development using Informatica, PL/SQL, and Oracle Database.
• Design, implement, test, and maintain ETL components for multiple applications.
• Plan and conduct Informatica ETL unit and development tests.
• Conduct performance tuning for sources, mappings, targets, and sessions.
• Provide post-production application support and data analysis to troubleshoot existing subject areas.
• Maintain a high-volume, multi-terabyte 24/7 data warehouse application.

Required Skills

• Minimum 2 years of Informatica/ETL experience.
• Expertise in Informatica PowerCenter development.
• Strong proficiency in PL/SQL and SQL tuning.
• Experience with Oracle Database tuning and development.
• Familiarity with Solaris environments.
• Experience working in high data volume environments.
• Knowledge of relational databases and analytics/data analysis tools.
• Ability to work independently or within a team to deliver data warehouse projects.

Preferred Skills

• 10+ years of ETL development experience.
• Bachelor's Degree in Computer Science or a related field.
• 6 years of related data warehouse experience.

Key Skills

Education

Bachelor's degree