ETL Developer / SQL tester with AWS

MACHINE LEARNING TECHNOLOGIES LLC; Pittsburgh (Allegheny County); On-site; USD 62,000 - 96,000; Full time

Job summary

MACHINE LEARNING TECHNOLOGIES LLC in Pittsburgh is seeking an ETL Developer / SQL tester with AWS to design and validate data pipelines for large-scale cloud projects. You will build robust ETL workflows and perform rigorous backend testing while collaborating with developers, analysts, and stakeholders.

You will script SQL, model relational databases, and implement DevOps practices to improve automation and data quality.

Qualifications

• Experience with SQL scripting and relational database modeling.
• Experience creating AWS ETL jobs and 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.
• Strong communication and collaboration with cross-functional teams.
• State Government experience.
• 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.
• 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.

Skills

SQL scripting

AWS ETL

DevOps automation

Test design

Test execution

Cross-functional comms

State Government

Cloud testing

Job description

Job Overview

Job ID: J53031

Job Title: ETL Developer / SQL tester with AWS

Location: Pittsburgh, PA

Duration: 12 Months + Extension

Hourly Rate: Depending on Experience (DOE)

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, L2-EAD, GC-EAD

Client: To Be Discussed Later

Employment Type: W-2, 1099, C2C

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.


• State Government experience


• 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

MACHINE LEARNING 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. MACHINE LEARNING 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 MACHINE LEARNING 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

© 2008-2018, Machine Learning Technologies LLC. All Rights Reserved.