Senior AWS ETL & SQL Tester — Data Pipeline Specialist

Machine Intelligence Technologies, LLC; Pittsburgh (Allegheny County); On-site; USD 90,000 - 130,000; Full time

Job summary

Machine Intelligence Technologies LLC is seeking an ETL Developer/SQL tester with 5-7 years of experience to design, build, and validate data pipelines in a cloud-native AWS environment. The role requires strong SQL skills, data modeling capabilities, and experience validating large-scale data processing with DevOps practices.

The candidate will work closely with developers, business analysts, and stakeholders to ensure data integrity and robust test coverage across backend and data layers.

Qualifications

• Experience with SQL scripting and relational database modeling.
• Experience creating AWS ETL jobs and data pipelines handling high volumes of data.
• Experience with DevOps practices and automation tools.
• Analyze and plan testing, write test cases, execute manual and automated tests, use technical skills for deeper testing.
• Strong communication and collaboration with cross-functional teams.

Responsibilities

• Designing, building, and maintaining ETL pipelines.
• Analyzing data models and business requirements.
• Troubleshooting data issues and optimizing performance.
• Creating documentation for processes and systems.
• Data Validation: verify data insertion/update/deletion for accuracy and integrity.
• Design, create and execute test cases for backend testing and data processing.
• Collaborating with developers and business analysts to ensure test coverage.

Skills

SQL scripting

Relational modeling

DevOps practices

Automation tools

Data pipelines

Cloud - AWS

Tools

AWS

ETL tooling

Job description

Machine Intelligence Technologies LLC is seeking an ETL Developer/SQL tester with 5-7 years of experience to design, build, and validate data pipelines in a cloud-native AWS environment. The role requires strong SQL skills, data modeling capabilities, and experience validating large-scale data processing with DevOps practices.

The candidate will work closely with developers, business analysts, and stakeholders to ensure data integrity and robust test coverage across backend and data layers.