Job Description
Design, develop, and optimize ETL workflows using DataStage (or similar tools), SQL, and Greenplum for large-scale data processing
Build and tune complex SQL queries and perform performance optimization for ETL processes and databases
Develop and maintain Unix/Linux shell scripts; schedule, monitor, and troubleshoot batch jobs using ControlM
Ensure data quality, integrity, and consistency while resolving production issues efficiently
Collaborate with crossfunctional teams in an Agile/Scrum environment to gather requirements and deliver iterative solutions
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to ... learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:
Skills and Requirements
Bachelors degree in Computer Science, Engineering, Information Systems, or related field with 5+ years of data engineering or ETL/ELT experience
Strong experience building and maintaining scalable data pipelines using IBM DataStage or similar ETL tools
Proficiency in SQL, relational databases, and hands-on experience with Greenplum or other MPP databases
Solid Unix/Linux knowledge, including shell scripting and job scheduling with ControlM (or similar tools)
Strong understanding of data warehousing concepts (star schema, fact/dimension) and experience working in Agile/Scrum environments