ETL Developer/SQL tester Job at Novalink Solutions LLC, Raleigh, NC

cDhRMUVJTE5seVBQRlB5ZmJYdFAxTng0Wmc9PQ==
  • Novalink Solutions LLC
  • Raleigh, NC

Job Description

DHHS-ITD is 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
  • Understanding data modeling
  • 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.

Requirements

Skill

Required / Desired

Experience with SQL scripting and relational database modeling

Required

Experience working with creating AWS ETL jobs, data pipelines with high volumes of data

Required

Experience with DevOps practices and automation tools

Required

Analyze and plan testing, write test cases, execute manual and automated tests, use technical skills for deeper testing

Required

Strong communication and collaboration skills to work with cross-functional teams, including developers, business analysts, and stakeholders.

Required

State Government experience

Nice to have

Experience programming and testing large scale cloud solutions

Required


Job Tags

Full time, Immediate start,

Similar Jobs

BAYADA Home Health Care

1:1 School Nurse (LPN) Job at BAYADA Home Health Care

 ...Home Care,** Stay for the Culture (**_Our_** **_Pocono Skilled Nursing_** **_Office_** **_is interested in a Licensed Practical Nurse...  ...What your day looks like as a BAYADA Private Duty Nurse** **:**+ Travel to **one** client home near you on a schedule you choose+... 

Hachette Book Group

Editor - Basic Books Group Job at Hachette Book Group

 ...SUMMARY:The Basic Books Group is a division of Hachette Book Group dedicated to making the world smarter by publishing works of serious non-fiction by expert authors. We are seeking an Editor to acquire in economics, business, current events, public policy, foreign... 

Computer Aid, Inc.

Data Analyst Intern Job at Computer Aid, Inc.

 ...Any information collected there is subject to their terms and privacy notice. Data Analyst Intern Req Number R6105 Employment Type Full time Worksite Flexibility Remote Who We Are CAI is a global technology services firm with over 8,500 associates... 

HR Associates

General Labor / Production Operator Job at HR Associates

Build Your Dreams Here! A Piqua, multi-state manufacturer has several Day or Night shift, General Labor / Production Operator jobs starting @ $17-$18 per hour with great benefits. This is your chance to learn & operate multiple types of machines.NOTE: You will make $... 

Translated

Canadian French Contracted Translator Job at Translated

 ...Translated is where technology and humanity meet to create global understanding. Founded in 1999 by a linguist and a computer scientist,...  ...humans. Translated is looking for an experienced Canadian French Contracted Translator to work on translation and review projects...