ETL Developer

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Motion Recruitment Partners, LLC, is seeking the following. Apply via Dice today!

• Our client, a major consulting firm, is 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.
  
  

This contract will last through the end of the year. It is Contract to hire.

Location is: Preferred Midvale/Salt Lake City, UT but remote is ok within Southern CA, UT, NV, AZ, CO

Required Skills & Experience

• 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
  
  

What You Will Be Doing

• 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
  
  

Additionally, you will:

• 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 industry latest industry trends and design patterns.