Description

You will design, develop, and maintain ETL processes to extract, transform, and load data from multiple sources.

This role is hybrid.

Responsibilities

• Perform full life cycle development in Oracle, including data modeling, database architecture, SQL and PL/SQL development, and unit testing.
• Optimize ETL and database performance through tuning and best practices.
• Develop and maintain PL/SQL programs including stored procedures, functions, packages, triggers, dynamic SQL, and materialized views.
• Use ETL tools, preferably Informatica (IICS), to automate and manage data integration processes.
• Collaborate with data architects and analysts to support data-driven solutions.

Required Skills

• 12+ years of experience as an ETL Developer.
• 2+ years of experience with Oracle database full life cycle development (data modeling, database architecture, SQL, PL/SQL, unit testing, and support).
• 2+ years of experience with SQL, ETL processes, and performance tuning for ETL and databases.
• Strong PL/SQL skills including data types, cursors, exception handling, and collections.
• Experience with merge statements, analytic functions, joins, and aggregate functions.
• Proficiency in views, materialized views, table functions, stored procedures, functions, and packages.
• Hands-on experience with database triggers, dynamic SQL, external tables, object programming, and performance tuning.
• Hands-on experience with ETL tools, preferably Informatica IICS.

Preferred Skills

• Bachelor's degree.
• Strong problem-solving skills and attention to detail.

Key Skills

Education

Bachelor's degree