Role :ETL Developer/SQL tester(AWS Experience)
Client : State of North Carolina(NCDHHS)
Work Type : Hybrid
Location: Raleigh,North Carolina
Max Payrate : 52$ Per Hour
Duration: 12 Months(Extendable)
Minimum Relevant Experience : 7 Years
eSystems Inc. is a fast-growing Systems Integrator based in Princeton, New Jersey. We provide strategic IT solutions and services with primary practice areas in Java and Microsoft centric e-Business solutions, ERP solutions, Enterprise Application Integration, Data Warehousing and Business Intelligence solutions.
Our clients include Fortune 500 corporations, government agencies, small and mid-sized local businesses, and non-profit organizations.
As an equal opportunity employer, eSystems complies with all applicable laws, rules and regulations preventing discrimination against job applicants based on: race, ethnicity, religious beliefs, gender, gender identity, age, veteran status, marital status, physical challenges, or any other relevant factor
THE JD and the required skillset are below. Please make sure that the suitable candidate has atleast 90% of the skillset mentioned
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 | Amount(Years) |
| | Experience with SQL scripting and relational database modeling | Required | 7 |
| | Experience working with creating AWS ETL jobs, data pipelines with high volumes of data | Required | 7 |
| | Experience with DevOps practices and automation tools | Required | 7 |
| | Analyze and plan testing, write test cases, execute manual and automated tests, use technical skills for deeper testing | Required | 7 |
| | Strong communication and collaboration skills to work with cross-functional teams, including developers, business analysts, and stakeholders. | Required | 7 |
| | State Government experience | Nice to have | |
| | Experience programming and testing large scale cloud solutions | Required | 7 |
Never miss an opportunity! Create an alert based on the job you applied for.
