ETL Developer / SQL tester with AWS

Quantum Technologies. LLC; Pittsburgh (Allegheny County); On-site; USD 80,000 - 110,000; Full time

Job summary

A technology solutions provider in Pittsburgh is seeking an experienced ETL Developer/SQL Tester to design and maintain ETL pipelines. Responsibilities include troubleshooting data issues, analyzing requirements, and collaborating with cross-functional teams to ensure data integrity. Candidates should have 5-7 years of experience, strong SQL skills, and familiarity with AWS ETL jobs. This role offers a chance to work on large-scale cloud solutions in a supportive environment.

Qualifications

• 5-7 years of experience in ETL development and SQL testing.
• Experience with creating AWS ETL jobs and managing high-volume data.
• Strong analytical skills for testing and troubleshooting.

Responsibilities

• Designing and maintaining ETL pipelines.
• Analyzing data models and business requirements.
• Troubleshooting data issues and optimizing performance.
• Creating documentation for processes and systems.
• Querying databases for data validation.
• Coordinating with developers and business analysts for comprehensive test coverage.

Skills

SQL scripting

Relational database modeling

AWS ETL jobs

Data pipelines

DevOps practices

Automation tools

Data analysis

Test case writing

Communication skills

Collaboration skills

Cloud solutions

Job description

Overview

ETL Developer/SQL tester with experience using cloud solutions on AWS.

ETL Developer/SQL tester with 5-7 years of experience.

Qualifications

• Required
• Experience with SQL scripting and relational database modeling
• Experience working with creating AWS ETL jobs, data pipelines with 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 skills to work with cross-functional teams, including developers, business analysts, and stakeholders.
• Experience programming and testing large scale cloud solutions

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 that data is correctly inserted, updated, and deleted by the application, ensuring data accuracy and integrity.
• Design, Create and Execute Test Cases:
• Backend Testing: Validating backend logic and data processing that might not be immediately visible through the user interface.
• Collaboration: Working closely with developers and business analysts to understand data requirements and ensure comprehensive test coverage.

QUANTUM TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. QUANTUM TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will QUANTUM TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract