ETL Support Engineer

Adastra Corp; United States; Remote; USD 80,000 - 110,000; Full time

Job summary

Adastra Corp is seeking an ETL Support Engineer to maintain data integration workflows, troubleshoot ETL issues, and support PostgreSQL-backed data processing. The role emphasizes hands-on Linux operations, SQL querying, and issue resolution in a fast-paced environment.

The ideal candidate has 4+ years in ETL support, strong troubleshooting skills, and the ability to collaborate with cross-functional teams. Weekend rotations may be required as part of the support schedule.

Qualifications

• Minimum 4 years of hands-on ETL support and data integration experience.
• Strong knowledge of ETL processes, SQL, PostgreSQL, and Linux.
• Familiarity with SDLC and CI/CD concepts; can be taught.
• Good problem-solving, analytical, and communication skills.
• Willingness to participate in weekend rotations.

Responsibilities

• Support, monitor, and maintain ETL processes and data workflows.
• Troubleshoot ETL job failures and data processing issues.
• Work with PostgreSQL to support data extraction, transformation, loading.
• Run SQL queries to investigate data issues and validate data.
• Assist with Linux operations, log analysis, scripts.
• Monitor scheduled jobs and coordinate issue resolution.
• Identify recurring issues and help implement improvements.
• Collaborate with development teams to resolve data integration problems.
• Follow incident management processes to resolve issues.
• Participate in weekend support rotations.

Skills

ETL support

PostgreSQL

SQL

Linux

Troubleshooting

Data integration

Analytical thinking

Communication

Weekend support

Tools

CI/CD

Job description

Job title: ETL Support Engineer

We are seeking an ETL Support Engineer with hands-on experience in Linux, PostgreSQL, and ETL processes. The role focuses on supporting and maintaining data integration workflows, troubleshooting ETL-related issues, and ensuring the stability and reliability of data processing operations.The ideal candidate should have a strong technical support background, good troubleshooting skills, and practical experience working with ETL processes and relational databases. Cloud experience is not required, as the role is primarily ETL-focused.

Responsibilities

• Support, monitor, and maintain ETL processes and data integration workflows.
• Troubleshoot and resolve ETL job failures, data processing issues, and integration errors.
• Work with PostgreSQL databases to support data extraction, transformation, and loading activities.
• Perform SQL queries to investigate data issues, validate data accuracy, and support troubleshooting.
• Support day-to-day Linux operations, including log analysis, shell commands, and basic scripting.
• Monitor scheduled jobs, investigate failures, and coordinate issue resolution.
• Identify recurring operational issues and contribute to process improvements.
• Collaborate with development and technical teams to resolve application and data integration issues.
• Follow incident management and support processes to ensure timely issue resolution.
• Participate in weekend support rotations as required.

Requirements

• Minimum 4 years of hands-on experience in ETL support, data integration, application support, or related technical support roles.
• Hands-on experience with ETL processes and troubleshooting
• Working knowledge of PostgreSQL and SQL
• Practical experience with Linux environments
• Ability to investigate ETL failures, analyze logs, and troubleshoot data processing issues.
• Understanding of data integration concepts, data flows, and scheduled batch processing.
• Familiarity with SDLC and CI/CD concepts; specific tools and processes can be taught.
• Basic understanding of database structures, schemas, and query performance.
• Strong analytical, problem-solving, and troubleshooting skills.
• Good communication skills and the ability to collaborate with technical teams.
• Willingness to participate in weekend support rotations.

Nice to Have

• Experience with ETL tools or data integration platforms.
• Knowledge of shell scripting or automation.
• Familiarity with IT Service Management (ITSM) processes.
• Experience with MSSQL or other relational databases.
• Exposure to cloud environments or cloud-based data platforms is an advantage but not required.