Senior Cloud ETL & SQL Tester | AWS Data Pipelines

Robotic Technologies Automation; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

ROBOTIC PROCESS AUTOMATION LLC in Pittsburgh, PA, is seeking an ETL Developer/SQL tester with strong AWS cloud experience to design, build, and validate scalable data pipelines.

You will script SQL, model relational databases, implement AWS-based ETL jobs, apply DevOps practices, plan and execute tests, and collaborate with developers, analysts, and stakeholders to ensure data accuracy and performance.

Qualifications

• 5-7 years of ETL or data testing experience.
• Experience with SQL scripting and relational database modeling.
• Experience creating AWS ETL jobs and data pipelines with high data volumes.
• Experience with DevOps practices and automation tools.
• Analyze and plan testing, write test cases, execute manual and automated tests.

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: Query the database to verify data accuracy and integrity.
• Design, Create and Execute Test Cases; Backend Testing; Collaboration with developers and analysts.

Skills

ETL testing

SQL scripting

Data modeling

AWS

DevOps

Test planning

Communication

Job description

ROBOTIC PROCESS AUTOMATION LLC in Pittsburgh, PA, is seeking an ETL Developer/SQL tester with strong AWS cloud experience to design, build, and validate scalable data pipelines.

You will script SQL, model relational databases, implement AWS-based ETL jobs, apply DevOps practices, plan and execute tests, and collaborate with developers, analysts, and stakeholders to ensure data accuracy and performance.