Client: State of North Carolina Job Title: Data Engineer Duration: 10 Months Start Date: ASAP Location: Research Triangle Park Durham NC 27709 (Hybrid) Position Type: Contract Interview Type: Either Webcam Interview or In Person Ceipal ID: SNCDATA832VH Requirement ID: NC FAST Data Engineer (749832)
Description The Department of Health and Human Services (DHHS) requires the assistance of contract resources to serve as Data Engineers. The primary purpose of these positions is to analyze map build test and maintain database pipeline architectures using Oracle and DB2 for Child Welfare Data Conversion efforts as the legacy system migrates to Salesforce. The work involves collaborating with various stakeholders to understand business requirements and translating them into efficient and scalable technical solutions for the Child Welfare program.
The persons in this position will play a crucial role in designing implementing and optimizing data pipelines and ETL processes to support the extraction transformation and loading of data from various Child Welfare sources into Salesforce. They will collaborate with crossfunctional teams to understand data requirements and translate them into technical solutions. The data engineers will need excellent problemsolving skills and the ability to work independently as well as part of a team. The work involves developing and maintaining data models schemas and databases to support data conversion needs. The work also involves monitoring and troubleshooting data pipelines to ensure data quality completeness integrity and availability. This position will be implementing best practices for data governance security and compliance to ensure regulatory requirements are met.
Responsibilities:
Analyze Map Build Test and Maintain database pipeline architectures using Oracle and DB2
Collaborate with SMEs to understand and execute data conversion objectives that transforms masks and loads data into Salesforce objects
Create and maintain table schemas
Create new data validation methods to ensure data accuracy completeness and cleanliness
Ensure compliance with data governance and security policies.
Required/Desired/Highly desired Skills:
Experience with Oracle (Required 5 Years)
Experience with PL/SQL (Required 5 Years)
Experience with SQL (Required 7 Years)
Experience with data migrations from legacy systems (Required 5 Years)
Experience with data cleansing (Required 1 Years)
Experience with DB2 (Highly Desired)
Experience with ETL processes involving Salesforce (Highly Desired)
Experience with Talend (Highly Desired)
Experience with GIT (Highly Desired)
Experience with Jira (Highly Desired)
Experience with Java (Highly Desired)
Experience with Python (Highly Desired)
Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage (Highly Desired)
Experience with Azure Synapse (Highly Desired)
Experience with Azure Databricks (Nice to have)
Experience with Cloud Computing (Nice to have)
Experience with Power BI (Nice to have)
V Group Inc. is an IT Services company which supplies IT staffing project management and delivery services in software network help desk and all IT areas. Our primary focus is the public sector including state and federal contracts. We have multiple awards/ contracts with the following states: AR CA DE FL GA IL KY MD ME MI NC NJ NY OH OR PA SC TX VA and WA. If you are considering applying for a position with V Group or in partnering with us on a position please feel free to contact me for any questions you may have regarding our services and the advantages we can offer you as a consultant.
Please share my contact information with others working in Information Technology.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.