JPS Tech Solutions · 10 hours ago
ETL Developer
Provo, UT
Full-time
Onsite
Senior Level, Lead/Staff
12+ years expJPS Tech Solutions is seeking an experienced ETL Developer to join their team. The ideal candidate will work with complex data structures, focusing on optimizing data workflows and developing ETL processes.
Information TechnologyIT InfrastructureSoftware Engineering
No H1B
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
Qualification
Required
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
Company
JPS Tech Solutions
JPS Tech Solutions offers software engineering, cloud, mobile development, and IT infrastructure solutions.
201-500 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase