ETL Developer

Overview

Job Category: ETL Developer

Job Type: Onsite

Job Location: Provo Utah

Compensation: Depends on Experience

W2: W2-Contract Only;
Kindly note that applications on a C2C basis will not be considered for this role.

Eligible Visa: GC GC-EAD H4 EAD L2S U.S. Citizen (USC)

We are seeking an experienced ETL Developer to join our team. The ideal candidate will be passionate about working with complex data structures, solving challenging problems, and optimizing data workflows. This role requires hands-on expertise in Oracle databases, SQL/PLSQL development, and ETL processes. This position is open only to candidates authorized to work in the United States under the following visa categories: H4-EAD, Green Card Holder, GC-EAD, U.S. Citizen, L2s, L2-EAD, or J2-EAD.

No other visa types are eligible for this role.

• Design, develop, and maintain ETL processes to extract, transform, and load data from multiple sources.
• 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.
• Work with ETL tools, preferably Informatica (IICS), to automate and manage data integration processes.
• Collaborate with data architects, analysts, and other team members to support data-driven solutions.
• Ensure high attention to detail and accuracy in all aspects of development.
• Quickly learn and adapt to new data tools, technologies, and concepts.

• 12+ years of experience as an ETL Developer.
• 2+ years of experience with Oracle database full life cycle development (data modeling, database architecture, SQL and PL/SQL development, 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.
• Proficient in views, materialized views, table functions, stored procedures, functions, and packages.
• Hands-on with database triggers, dynamic SQL, external tables, object programming, and performance tuning.
• Hands-on experience with ETL tools, preferably Informatica IICS.
• Strong problem-solving skills and attention to detail.
• Ability to quickly learn and work with new data tools and technologies.