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

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.

You will receive the following benefits:

• Medical Insurance - Four medical plans to choose from for you and your family
• Dental & Orthodontia Benefits
• Vision Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts
• Voluntary Life Insurance, Long-Term & Short-Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) including match with pre and post-tax options
• Paid Sick Time Leave
• Legal and Identity Protection Plans
• Pre-tax Commuter Benefit
• 529 College Saver Plan

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full-time basis in the country for which they are applying, and no sponsorship is currently available. Employment is subject to the successful completion of a pre-employment screening. Accommodation will be provided in all parts of the hiring process as required under MRP’s Employment Accommodation policy. Applicants need to make their needs known in advance.