ETL Developer

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, * 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.

• 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