ETL Developer/SQL Tester

Machine Intelligence Technologies, LLC; Raleigh (NC); On-site; USD 85,000 - 120,000; Full time

Job summary

MACHINE INTELLIGENCE TECHNOLOGIES LLC is seeking an ETL Developer/SQL tester with 5-7 years of experience to design, build, and maintain ETL pipelines using cloud-based solutions on AWS.

The role involves validating data, writing complex SQL, testing backend logic, and collaborating with developers and business analysts to ensure data quality and performance.

Qualifications

• SQL proficiency: complex queries and tuning.
• DB relationships understanding.
• Debugging and performance tuning.
• Experience with multiple DB systems.
• Cloud-based ETL tools experience.
• DevOps experience.
• AWS cloud experience.

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 data accuracy.
• Design, create and execute test cases.
• Backend testing: validating backend logic and data processing.
• Collaboration: working with developers and business analysts.

Skills

SQL

Complex queries

DB relationships

Debugging

Performance tuning

ETL pipelines

DevOps

Data validation

Backend testing

AWS

Tools

MySQL

Oracle

MS SQL Server

Cloud-based ETL tools

CI/CD

AWS

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.

MACHINE INTELLIGENCE 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 INTELLIGENCE 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 INTELLIGENCE 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