ETL Developer/SQL Tester

Machine Learning Technologies, LLC; Raleigh (NC); On-site; USD 95,000 - 130,000; Full time

Job summary

Machine Learning Technologies, LLC is seeking an ETL Developer/SQL tester with 5-7 years of experience to design, build and maintain ETL pipelines on cloud-based platforms. You will validate data integrity, test backend processes, and collaborate with cross-functional teams to ensure complete test coverage.

The role emphasizes SQL proficiency, data modeling understanding, and experience with DevOps practices to streamline deployment and testing in a cloud environment.

Qualifications

• 5-7 years of experience in ETL development and SQL testing.
• Strong SQL skills with complex queries and data modeling understanding.
• Experience with debugging and performance tuning of SQL queries.

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 correct insert/update/delete by the application.
• Design, create and execute test cases.
• Backend testing: validate logic and data processing behind UI.
• Collaborate with developers and business analysts to ensure test coverage.

Skills

SQL - Complex queries

Database relationships

Debugging & performance tuning

Tools

Cloud-based ETL tools

DevOps basics

Job description

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

looking to hire a ETL Developer/SQL tester with 5-7 years of experience.

Skill Sets and experience include

SQL - Writing Complex Queries, understanding Database Relationships, debugging and performance tuning

Experience working with different DB systems such as MySQL, Oracle, MS SQL Server or similar DBs

ETL tools - Hands-on experience with cloud-based tools

Experience with DevOps

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.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.