Job ID: NC-743008 (912590806)
Hybrid/Local Data Engineer (15+) with Oracle/DB2, PL/SQL, data conversion/migration/cleansing, ETL, Data Warehouse/lake, Salesforce, Git, BitBucket, SVN, Talend, Java, AWS/Azure and Child Welfare experience
Location: Durham, NC (NCDHHS-NCFAST)
Duration: 12 Months
Position: 1(2)
Skills:
Experience with Oracle database Required 7 Years
Strong hands-on Experience with PL/SQL Required 7 Years
Strong hands-on Experience with SQL Required 7 Years
Experience with data conversion and migrations Required 5 Years
Experience with data analysis and cleansing Required 1 Years
Experience with DB2 database Required 2 Years
Hands on experience in coding, testing and maintaining ETL processes Required 7 Years
Experience with source code repository like Git, BitBucket, SVN Required 1 Years
Experience with Talend Highly desired 1 Years
Experience with Java Highly desired 5 Years
Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage Highly desired 1 Years
Understanding and experience with Child welfare application system Desired
Description:
The Department of Health and Human Services (DHHS) requires the assistance of contract resources to serve as Senior Data Engineer. The purpose of this position is to analyze, map, build, test, and maintain data extraction, conversion and migration from databases like Oracle and DB2 to target databases including Data Warehouse, Data lake on various cloud or on-prem database platforms.
One of the primary focuses of this position is to lead data analysis, mapping, needed transformation and extraction of data from Oracle and DB2 databases to migrate to the Salesforce platform for Child welfare program. The work involves collaborating with various internal and vendor 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.
This position will also support data archival for management of data growth, data sub-setting to extract criteria-based data and data de-identification to help provide needed data for application validation.
The Senior data engineer will need excellent problem-solving skills and the ability to work independently as well as part of a team. The work involves understanding data, relationships among data objects, designing and developing ETL to support these data workstreams.The work also involves monitoring and troubleshooting data pipelines/processes to ensure data quality, completeness, integrity, and availability.