Data Engineer -ETL

Title: Data Engineer -ETL 
Location: Preferred Midvale/Salt Lake City, UT, but remote is ok within Southern CA, UT, NV, AZ, CO 
Duration: Contract to Hire 
Years Of Exp Required: 8+ Years

•Collaborate with Product Management and business partners to understand use case requirements and reporting.
•Adhere to internal development best practices/lifecycle (e.g. Testing, Code Reviews, CI/CD, Documentation).
•Document and showcase feature designs/workflows.
•Participate in team meetings and discussions around product development.
•Stay up to date on the latest industry trends and design patterns.
Competencies: ETL Development (DataStage or similar tools), Advanced SQL & Query Optimization, Greenplum / MPP Databases, Job Scheduling & Orchestration (Control-M), Data Warehousing Concepts (Star Schema, Fact/Dimension Modeling) Performance Tuning & Optimization (ETL & Database), Data Quality & Data Integrity Management

Job Description:
Looking for a skilled ETL Developer with strong experience in data warehousing, Greenplum, SQL, and Unix environments. 
The ideal candidate will be responsible for designing, developing, and maintaining ETL pipelines, ensuring high-quality data delivery, and collaborating with cross-functional teams in an Agile/Scrum environment. 

 

Duties and responsibilities 
. Design, develop, and maintain ETL workflows using tools like DataStage or similar ETL platforms 
. Build and optimize complex SQL queries for data extraction, transformation, and loading 
. Work extensively with Greenplum databases for large-scale data processing 
. Develop and maintain shell scripts in Unix/Linux environments
. Schedule, monitor, and troubleshoot batch jobs using Control-M 
. Ensure data quality, integrity, and consistency across systems 
. Perform performance tuning and optimization of ETL processes and database queries 
. Collaborate with business analysts, data architects, and stakeholders to gather requirements 
. Participate in Scrum ceremonies (daily stand-ups, sprint planning, retrospectives) 
. Follow Agile methodologies for iterative development and delivery 
. Troubleshoot production issues and provide timely resolution Required qualifications 
. Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field. 
. 5+ years of experience in data engineering, ETL/ELT development, or related roles. 
. Strong experience building and maintaining scalable data pipelines. 
. Strong experience with ETL tools such as IBM DataStage (or similar) 
. Proficiency in SQL and relational databases 
. Hands-on experience with Greenplum or other MPP databases 
. Solid knowledge of Unix/Linux commands and shell scripting 
. Experience with Control-M or other job scheduling tools 
. Understanding of data warehousing concepts (fact/dimension, star schema) 
. Familiarity with Agile/Scrum methodologies