ETL Data Engineer

We are seeking a skilled ETL Developer with strong experience in data warehousing, Greenplum, SQL, and Unix environments for our client. 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., * 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, * 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, * Data Warehousing Concepts - (Star Schema, Fact/Dimension Modeling) - 5+ Years of Experience
• Performance Tuning & Optimization (ETL & Database) - 5+ Years of Experience
• Data Quality & Data Integrity Management - 5+ Years of Experience
• ETL Development (DataStage or similar tools) - 5+ Years of Experience
• Advanced SQL & Query Optimization - 5+ Years of Experience
• Greenplum / MPP Databases - 5+ Years of Experience
• Job Scheduling & Orchestration (Control-M) - 5+ Years of Experience

Job Posting on LinkedIn LinkedIn Feed Smith Johnson Website Referral UT Workforce Services Job Board Other Preferred Smith Johnson Tech recruiter (leave blank if none)Preferred Employment Type (Select the option that best reflects how you would be engaged today.)*

• C2C - Third-party employer

• C2C - Own company (EIN) o W-2 (Direct Employee)

If working for a C2C, please enter the company nameIf working for a C2C, please enter your contact's name, email and phone numberPreferred Work Arrangement (Select all that apply) Preferences are not a guarantee of role availability. Remote Hybrid On-site Available Start DateDesired Annual Compensation (Target)Are you willing to authorize a background check and drug screen after an offer?* Yes No Are you legally authorized to work in the United States?* Yes No Will you require employment visa sponsorship now or in the future?*

• Yes

• No

Security Clearance*

• I currently hold an active U.S. security clearance

• I do not hold a clearance but am eligible and willing to obtain one (I am a U.S. citizen and am able to pass a background investigation) o I do not hold a clearance and am not interested in obtaining one