AWS ETL & Data Quality Engineer

Cloud Analytics Technologies, LLC; Pittsburgh (Allegheny County); Sur place; USD 90 000 - 120 000; Plein temps

Résumé du poste

Cloud Analytics Technologies LLC is seeking an ETL Developer/SQL tester in the Pittsburgh area. The role requires 5–7 years of experience with SQL scripting, relational database modeling, and AWS-based ETL/data pipelines handling large data volumes.

Responsibilities include designing and maintaining ETL pipelines, validating data integrity, creating and executing test cases, and collaborating with developers and analysts to ensure comprehensive test coverage.

Qualifications

• 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.
• Ability to analyze and plan testing, write test cases, and execute manual and automated tests.
• Strong communication and collaboration skills across cross-functional teams.
• Experience programming and testing large-scale cloud solutions.

Responsabilités

• Design, build, and maintain ETL pipelines.
• Analyze data models and business requirements.
• Troubleshoot data issues and optimize performance.
• Create documentation for processes and systems.
• Data validation: verify data inserted/updated/deleted by the application.
• Design, create, and execute test cases; backend testing of logic and data processing.
• Collaborate with developers and business analysts to ensure test coverage.

Connaissances

SQL scripting

Relational DB modeling

AWS ETL

Data pipelines

DevOps practices

Automation tools

Description du poste

Cloud Analytics Technologies LLC is seeking an ETL Developer/SQL tester in the Pittsburgh area. The role requires 5–7 years of experience with SQL scripting, relational database modeling, and AWS-based ETL/data pipelines handling large data volumes.

Responsibilities include designing and maintaining ETL pipelines, validating data integrity, creating and executing test cases, and collaborating with developers and analysts to ensure comprehensive test coverage.