ETL Developer/SQL Tester

Quantum Technologies. LLC; Raleigh (NC); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology firm located in North Carolina is seeking an experienced ETL Developer/SQL tester. The role involves designing and maintaining ETL pipelines, analyzing data models, troubleshooting issues, and ensuring data accuracy through rigorous validation. Candidates should have 5-7 years of experience, strong SQL skills, and familiarity with cloud solutions. The company promotes equal opportunity and values diversity among applicants.

Qualifications

• 5-7 years of ETL developer/SQL tester experience.
• Experience with MySQL, Oracle, MS SQL Server or similar databases.
• Hands-on experience with cloud-based ETL tools.

Responsibilities

• Design and maintain ETL pipelines.
• Analyze data models and business requirements.
• Troubleshoot data issues and optimize performance.
• Create documentation for processes and systems.
• Validate data accuracy and integrity through queries.
• Design, create, and execute test cases.

Skills

SQL - Writing Complex Queries

Understanding Database Relationships

Debugging and Performance Tuning

Experience with different DB systems

ETL tools - Hands-on experience

Experience with DevOps

Job description

Overview

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.

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.

Qualifications

• SQL - Writing Complex Queries, understanding Database Relationships, debugging and performance tuning.
• Experience 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.

Additional Information

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