ETL Developer/SQL Tester

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

Job summary

A leading cloud solutions company based in Raleigh, NC is seeking an ETL Developer/SQL Tester with 5-7 years of experience. The role involves designing and maintaining ETL pipelines, troubleshooting data issues, and ensuring data accuracy through validation. Candidates should possess strong SQL skills and have hands-on experience with cloud-based ETL tools. This is an equal opportunity employer committed to diversity and inclusion in the workforce.

Qualifications

• 5-7 years of experience in ETL development and SQL testing.
• Hands-on experience with cloud-based ETL tools.
• Familiarity with different database systems.

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.
• Validating data accuracy through database queries.
• Validating backend logic and data processing.

Skills

SQL - Writing Complex Queries

Understanding Database Relationships

Debugging and Performance Tuning

Experience with MySQL, Oracle, MS SQL Server

ETL Tools - Hands-on Experience with Cloud-based Tools

Experience with DevOps

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.

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

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: