Data EngineerLocation: Research Triangle Park, Durham NC (Hybrid)Client 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 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 cross-functional teams to understand data requirements and translate them into technical solutions.
The data engineers will need excellent problem-solving 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 DB2Collaborate with SMEs to understand and execute data conversion objectives that transforms, masks, and loads data into Salesforce objectsCreate and maintain table schemasCreate new data validation methods to ensure data accuracy, completeness, and cleanlinessEnsure compliance with data governance and security policiesExperience with Oracle Required 5 YearsExperience with PL/SQL Required 5 YearsExperience with SQL Required 7 YearsExperience with data migrations from legacy systems Required 5 YearsExperience with data cleansing Required 1 YearExperience with DB2 Highly desired 1 YearExperience with ETL processes involving Salesforce Highly desired 1 YearExperience with Talend Highly desired 1 YearExperience with GIT Highly desired 1 YearExperience with Jira Highly desired 1 YearExperience with Java Highly desired 5 YearsExperience with Python Highly desired 3 YearsExperience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage Highly desired 1 YearExperience with Azure Synapse Highly desired 2 YearsExperience with Azure Databricks Nice to have 1 YearExperience with Cloud Computing Nice to have 1 Year