Please scroll down, To apply

Oracle Data Conversion/ETL Programmer - Hybrid

hiring now

msysinc

2024-11-05 18:44:15

Job location Raleigh, North Carolina, United States

Job type: all

Job industry: I.T. & Communications

Job description

Title: Oracle Data Conversion/ETL Programmer - Hybrid
Location: Raleigh, NC, United States
Length: Long term
Restriction: W2 or C2C

Description:

Very long term project initial PO for 1 year, expect to go for 4+ years Hybrid

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 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 Skills

Experience with Oracle5Years
Experience with PL/SQL5Years
Experience with SQL7Years
Experience with data migrations from legacy systems5Years
Experience with data cleansing 1 Years
One or more of the following:

Experience with DB2 1 Years
Experience with ETL processes involving Salesforce1Years
Experience with Talend1Years
Experience with GIT1Years
Experience with Jira1Years
Experience with Java5Years
Experience with Python3Years
Experience with cloud platforms (e.g. AWS and Azure) and associated services for data processing and storage1Years
Experience with Azure Synapse 2 Years

Nice to have:

Experience with Azure Databricks 1 Years
Experience with Cloud Computing1Years
Experience with Power BI 1 Years

Inform a friend!

<!– job description page –>
Top