DHHSITD requires the services of Specialists in the roles of Data Engineers that will analyze map build test and maintain database pipeline architectures using Oracle and DB2 for Child Welfare Data Conversion efforts.
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 and Duties:
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 Skills
Skill
Required /Desired
Amount
of Experience
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
1
Years
Experience with ETL processes involving Salesforce
Highly desired
1
Years
Experience with Talend
Highly desired
1
Years
Experience with GIT
Highly desired
1
Years
Experience with Jira
Highly desired
1
Years
Experience with Java
Highly desired
5
Years
Experience with Python
Highly desired
3
Years
Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage
Highly desired
1
Years
Experience with Azure Synapse
Highly desired
2
Years
Experience with Azure Databricks
Nice to have
1
Years
Experience with Cloud Computing
Nice to have
1
Years
Experience with Power BI
Nice to have
1
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
Please list candidates email address HERE that will be used when submitting ERTR.
Question3
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.
Question4
Will the candidate be subcontracted at the time of submission (Yes or No)
Question5
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
Question6
Please confirm you have thoroughly validated and attest to the accuracy of the credentials listed throughout this candidate s VectorVMS profile and resume.
Question7
Please provide candidates current location (City and state) NOT a Yes or No response.
Question8
Please list all Professional Certifications and the year they were received. The certifications will be validated.
Question9
Please provide a brief description of recent professional development work in a data conversion effort.
Question10
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
Question11
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 ITS009440. Do you confirm
Question12
Candidates submitted above the rate of 2 may not be considered. Do you accept this requirement
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.