ETL Developer / SQL tester with AWS

Cloud Analytics Technologies, LLC; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

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.

Responsibilities

• 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.

Skills

SQL scripting

Relational DB modeling

AWS ETL

Data pipelines

DevOps practices

Automation tools

Job description

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

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

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

Job responsibilities include (but not limited to)

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.

Equal Opportunity Employer
CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: