ETL Developer Job at JPS Tech Solutions, Provo, UT

a1ByakkvY0tuMzVVSlJnMU9CSy9DMUdMWlE9PQ==
  • JPS Tech Solutions
  • Provo, UT

Job Description

Job Category: ETL Developer

Job Type: Hybrid

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.

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.

Key Responsibilities

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.

Required Qualifications

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.

Apply Online

Your Name *

Your Phone Number *

Your Email Address *

Job id

What is your current U.S. visa or immigration status? *

SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa

Where are you currently located at? *

W2 or C2C *

SelectW2C2C

How many years of total experience do you have? *

How many years of relevant experience do you have? *

Do you require H1B sponsorship? *

YesNo

Do you require sponsorship? *

NoYes – H-1B transferYes – Green Card sponsorshipYes – Both H-1B transfer and Green Card sponsorship

Upload Resume *

Δ

Facebook X LinkedIn WhatsApp

Job Tags

Permanent employment, Contract work, H1b

Similar Jobs

Easy Rently

Personal Assistant / Administrative Assistant Job at Easy Rently

We are looking for a personal assistant to work remotely from home.It's advertisement work and it's not stopping you from doing your old job if you have one it can serve as a second job. Health insurance benefit 10-15% of total salary depebeing on work hour duratio.

Cookie Cutters Haircuts for Kids

Hair Stylist-Barber Job at Cookie Cutters Haircuts for Kids

 ...Overview: Cookie Cutters Haircuts for Kids is hiring Hair Stylists, Cosmetologists, and Barbers! We invite you to apply by submitting...  ...for Kids is one of the fastest growing franchises in the salon industry and we are passionate about cutting kids hair. At our salon... 

Jobot

Telephone Triage Outpatient Clinic - Registered Nurse - Office Role Job at Jobot

 ...LinkedIn page! Amazing Primary Care Health Center Looking for Telephone Triage / Ambulatory Care RN - Office Role This Jobot Job is...  ...Job Details Telephone Triage Outpatient Clinic - Registered Nurse - Office Role Telephone Triage - Performing rapid patient... 

Ohio State Home Services

Entry-Level Sales Representative (Base + Bonuses) - Make $60k+ Year 1 Job at Ohio State Home Services

 ...Home Inspection Sales Representative - No Experience Necessary (Base + Bonuses) Full-Time | Hourly + Bonuses Job Summary Are you hardworking, outgoing, and ready to earn based on your performance? We are looking for full-time Door-to-Door Home Inspection Representatives... 

10X Health System

Project Manager Job at 10X Health System

 ...professional' or a 'master of many trades' who can effectively tackle diverse tasks and excel in various areas. Project managers should...  ..., sexual orientation, or disability, and actively foster inclusion in all forms both within our company and across interactions with...