Govt ETL Developer

InnoSoul • Raleigh, NC

23h • Hybrid

About The Position

DHHS-ITD is seeking an ETL Developer/SQL tester with experience using cloud solutions on AWS. This role involves designing, building, and maintaining ETL pipelines, analyzing data models and business requirements, troubleshooting data issues, optimizing performance, and creating documentation for processes and systems. The developer will also be responsible for data validation, including querying databases to ensure data accuracy and integrity, and performing backend testing to validate logic and data processing. Collaboration with developers and business analysts is key to understanding data requirements and ensuring comprehensive test coverage.

Requirements

• Experience with SQL scripting and relational database modeling
• 7 Years Experience working with creating AWS ETL jobs, data pipelines with high volumes of data
• 7 Years Experience with DevOps practices and automation tools
• 7 Years Analyze and plan testing, write test cases, execute manual and automated tests, use technical skills for deeper testing
• 7 Years Strong communication and collaboration skills to work with cross-functional teams, including developers, business analysts, and stakeholders.
• 7 Years State Government experience
• 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

Nice To Haves

• Experience programming and testing large scale cloud solutions

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.
• 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.
• Validating backend logic and data processing that might not be immediately visible through the user interface.
• Working closely with developers and business analysts to understand data requirements and ensure comprehensive test coverage.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed