Talent.com
NC DHHS ETL Developer/SQL tester
NC DHHS ETL Developer/SQL testerOST Workforce • DHHS HQ Building - 1910 Human Services Lane Raleigh, NC, United States
No longer accepting applications
NC DHHS ETL Developer / SQL tester

NC DHHS ETL Developer / SQL tester

OST Workforce • DHHS HQ Building - 1910 Human Services Lane Raleigh, NC, United States
9 days ago
Job type
  • Full-time
  • Quick Apply
Job description

DHHS-ITD is seeking ETL Developer / SQL tester with experience using cloud solutions on AWS.

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.
  • Required / Desired Skills

    Skill

    Required / Desired

    Amount

    of Experience

    Experience with SQL scripting and relational database modeling

    Required

    Years

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

    Required

    Years

    Experience with DevOps practices and automation tools

    Required

    Years

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

    Required

    Years

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

    Required

    Years

    State Government experience

    Nice to have

    Experience programming and testing large scale cloud solutions

    Required

    Years

    Questions

    No.

    Question

    Question1

    Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?

    Question2

    All work must be completed on site at the client's discretion. Do you accept this requirement?

    Question3

    Please list candidate's email address HERE that will be used when submitting E-RTR.

    Question4

    Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment.

    Question5

    Vendor must disclose to the agency if the candidate will be subcontracted at the time of submission. Do you accept this requirement?

    Question6

    Vendor must notify the agency if any portion of the requirements listed in this task order are to be outsourced to other countries. Do you accept this requirement?

    Question7

    Candidates submitted above a rate of $85.00 per hour may not be considered. Do you accept this requirement?

    Question8

    Payment for all approved hours will be paid at the straight hourly rate regardless of the total hours worked by the engaged resource. It is the responsibility of the supplier to adhere to any applicable compensation laws including payment for overtime hours. Do you accept this requirement?

    Question9

    Please confirm you have thoroughly validated, and attest to the accuracy of, the credentials listed throughout this candidate s VectorVMS profile and resume pursuant to Section 5.2.5 of ITS-009440. Do you confirm?

    Create a job alert for this search

    NC DHHS ETL DeveloperSQL tester • DHHS HQ Building - 1910 Human Services Lane Raleigh, NC, United States

    Similar jobs
    HL7 Tester 1.19

    HL7 Tester 1.19

    Focused HR Solutions • Raleigh, North Carolina, United States
    Full-time
    Quick Apply
    Candidates will be allowed to work remotely during COVID.Once restrictions are lifted and the client’s office opens, candidates will be required to work 100% onsite daily M-F during normal business...Show more
    Last updated: 30+ days ago
    SQL Administrator

    SQL Administrator

    Sunrise Systems • Raleigh, North Carolina, United States
    Full-time
    Quick Apply
    Experience in troubleshooting and resolving database problems; Experience with following : .Backups restores and High Availability (Always on),. Installation and configuration of SQL 2014, 2016 and 20...Show more
    Last updated: 30+ days ago
    Part-time CAD Designer (Remote role - 25 hours week)

    Part-time CAD Designer (Remote role - 25 hours week)

    Allbridge, LLC • Raleigh, NC, United States
    Remote
    Full-time +1
    Allbridge is the leading supplier of world class connected technology solutions, services, and support for high-density properties. With more than 35 years of continuous growth and industry experien...Show more
    Last updated: 3 days ago • Promoted
    Usage Tester - Work From Home - $45 per hour

    Usage Tester - Work From Home - $45 per hour

    GL1 • Cary, North Carolina
    Remote
    Part-time +1
    Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies. We guarantee 15-25 hours per week with an hourly pay of bet...Show more
    Last updated: 30+ days ago • Promoted
    Locum Physician (MD / DO) - Anesthesiology - General / Other in Dunn, NC

    Locum Physician (MD / DO) - Anesthesiology - General / Other in Dunn, NC

    LocumJobsOnline • Dunn, NC, US
    Full-time
    Doctor of Medicine | Anesthesiology - General / Other.Competitive weekly pay (inquire for details) .LocumJobsOnline is working with LocumTenens. Anesthesiology MD in Dunn, North Carolina, 28334!.Job R...Show more
    Last updated: 19 days ago • Promoted
    Assessment Developer - Raleigh, North Carolina

    Assessment Developer - Raleigh, North Carolina

    Western Governors University • Raleigh, NC, United States
    Full-time +1
    If you're passionate about building a better future for individuals, communities, and our country-and you're committed to working hard to play your part in building that future-consider WGU as the ...Show more
    Last updated: 1 day ago • Promoted
    M - 4 / 30 - 758277 - Sr ETL (Oracle) Developer - Raleigh, NC

    M - 4 / 30 - 758277 - Sr ETL (Oracle) Developer - Raleigh, NC

    FHR • Raleigh, NC, US
    Full-time
    Quick Apply
    Only candidates that currently live in Raleigh, NC area will be considered (NC Driver’s License Required as Proof Of Residency). In-Person Interview in Raleigh, NC required on 1st Round.Candidate mu...Show more
    Last updated: 30+ days ago
    Sr. SSIS developer

    Sr. SSIS developer

    Coforge • Raleigh, NC, United States
    Full-time
    SSIS developer with the following skillset : .Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM.Builds data transform...Show more
    Last updated: 1 day ago • Promoted
    Data Analyst

    Data Analyst

    Health & Human Services • Wake County, North Carolina, USA
    Full-time
    Dept of Health and Human Services.The North Carolina Department of Health and Human Services (DHHS) is one of the largest most complex agencies in the state and has approximately 17000 employees.It...Show more
    Last updated: 6 days ago • Promoted
    NC DEQ - Power Platform Developer

    NC DEQ - Power Platform Developer

    Mahantech • Raleigh, NC, North Carolina, USA
    Full-time
    Engagement Type Contract Short Description As a part of the NC DEQ Permitting Transformation Program (PTP), Power Platform Developers wor...Show more
    Last updated: 30+ days ago
    Senior Workday HRIS Reporting analyst

    Senior Workday HRIS Reporting analyst

    JS Consulting • Raleigh, NC, United States
    Full-time
    Quick Apply
    ITLE : Senior Workday HRIS Reporting analyst Project Location : - Hybrid Raleigh NC Project Duration : - Full time &l...Show more
    Last updated: 5 days ago
    CDL-A OTR HazMat / Reefer Driver - No Local Routes

    CDL-A OTR HazMat / Reefer Driver - No Local Routes

    SPECIALIZED TRANSPORT SOLUTIONS CO • Wake Forest, NC, United States
    Full-time
    Join a dedicated Over-the-Road HazMat / Reefer team running east of I-35 (no NYC).K benefits after 90 days, and run with a company that treats you like family—not a number. CDL-A, 3 yrs current experi...Show more
    Last updated: 4 hours ago • Promoted • New!
    Licensing & Reporting Analyst II (Compliance)

    Licensing & Reporting Analyst II (Compliance)

    James River Management Company • Raleigh, NC, United States
    Full-time
    Come grow with James River Insurance!.James River Insurance is an excess and surplus lines segment of James River Group Holdings, Ltd. Since 2003, James River has provided thousands of commercial pr...Show more
    Last updated: 30+ days ago • Promoted
    Drive with DoorDash

    Drive with DoorDash

    DoorDash • Butner, NC, United States
    Full-time +1
    DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day. As a Dasher, you’ll stay busy with a variety o...Show more
    Last updated: 30+ days ago • Promoted
    CDL-A Flatbed Truck Driver - $0.40 to $0.63 per mile in Wake Forest, NC

    CDL-A Flatbed Truck Driver - $0.40 to $0.63 per mile in Wake Forest, NC

    AllTruckJobs • Wake Forest, NC, US
    Full-time
    CALL TO SPEAK WITH A SEATING SPECIALIST TODAY! .Western Express has immediate openings in our Flatbed and Dry Van divisions for company drivers and driver trainers! With our newly increased pay pac...Show more
    Last updated: 30+ days ago • Promoted
    Applications Systems Analyst Sr - Epic Ambulatory

    Applications Systems Analyst Sr - Epic Ambulatory

    UNC Health Care • Morrisville, NC, United States
    Full-time
    Become part of an inclusive organization with over 40,000 teammates, whose mission is to improve the health and well-being of the unique communities we serve. Provides a high level of technical supp...Show more
    Last updated: 1 day ago • Promoted
    Travel CT Tech - $2,653 to $2,948 per week in Glenwood Springs, CT

    Travel CT Tech - $2,653 to $2,948 per week in Glenwood Springs, CT

    AlliedTravelCareers • Glenwood Springs, CT, US
    Full-time
    AlliedTravelCareers is working with Prime Time Healthcare to find a qualified CT Tech in Glenwood Springs, Connecticut!.Now Hiring : Allied Healthcare CT - Glenwood Springs, CO.Contact us for Pay In...Show more
    Last updated: 30+ days ago • Promoted
    TurboTax (WFH) Customer Service - Entry-Level

    TurboTax (WFH) Customer Service - Entry-Level

    TurboTax • Wake Forest, North Carolina
    Remote
    Full-time
    Work from home with TurboTax Product Expert.Get a $405 Certification bonus³.Work from home & set your own flexible schedule between 8am EST and 12am midnight EST Monday to Sunday⁴.Earn an ...Show more
    Last updated: 4 days ago • Promoted