MSys Inc
Oracle ODI/OWB ETL Developer - Hybrid
MSys Inc, Raleigh, North Carolina, United States, 27601
Job summary:
Title:
Oracle ODI/OWB ETL Developer - Hybrid
Location:
Raleigh, NC, United States
Length and terms:
Long term - W2 or C2C
Position created on 10/28/2025 02:55 pm
Job description:
*** Very long term project; initial PO for 1 year, expect to go for 4+ years
Hybrid
Job Description:
Highly skilled Oracle PL/SQL developer to provide business and system analysis, modeling, design, developing and maintaining Medicaid reporting solutions and semantic models. This role will work closely with client internal business team and Medicaid team to develop new reports and maintain the reporting code for some of the enhancements based on the backlog of change requests from the business and help fix some of the defects from the backlog as well.
Requirements:
Strong understanding of relational databases (including tables, views, indexes, table spaces, users, grants)
Strong experiences in design, build, and manage data warehouses
5 or more years Oracle PL/SQL
Strong working knowledge Business intelligence and reporting tool (BIRT) and the understanding of the underlying data and tables in IBM Curam framework for the product delivery cases and the financial part to support all kinds of reports for case workers
Strong working knowledge of Build data analytics solutions using Azure Synapse serverless SQL pools
Demonstrated experience with Azure Synapse Analytics, including Synapse pipelines, SQL pools, and Spark pools.
1-2 years of experience utilizing Python, PySpark , and SparkSQL on Azure Cloud
Experience configuring, designing, developing and testing dash boards using Power BI
Lead and mentor other reporting developers in data integration efforts, utilizing ETL design patterns, error handling and configurations
Required Skills:
Experience programming and design of large scale web based distributed systems 5 Years
Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI), 5 Years
Experience with SQL scripting and Relational Database modeling 5 Years
Experience with Experience with structured system development methodologies 5 Years
Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options.
Ability to organize, prioritize, and follow complex and/or detailed technical procedures.
Highly Desired Skills
Prefer experience with Business Intelligence tools such as Business Objects or BIRT 2 Years
Prefer Data Warehouse experience 2 Years
Experience with the Cúram product. 4 Years
Strong SQL Skill 2 Years
Synapse
Medicaid
Contact the recruiter working on this position:
The recruiter working on this position is Rohit(Shaji Team) Bala
His/her contact number is His/her contact email is rohit@msysinc.com
Our recruiters will be more than happy to help you to get this contract.
Title:
Oracle ODI/OWB ETL Developer - Hybrid
Location:
Raleigh, NC, United States
Length and terms:
Long term - W2 or C2C
Position created on 10/28/2025 02:55 pm
Job description:
*** Very long term project; initial PO for 1 year, expect to go for 4+ years
Hybrid
Job Description:
Highly skilled Oracle PL/SQL developer to provide business and system analysis, modeling, design, developing and maintaining Medicaid reporting solutions and semantic models. This role will work closely with client internal business team and Medicaid team to develop new reports and maintain the reporting code for some of the enhancements based on the backlog of change requests from the business and help fix some of the defects from the backlog as well.
Requirements:
Strong understanding of relational databases (including tables, views, indexes, table spaces, users, grants)
Strong experiences in design, build, and manage data warehouses
5 or more years Oracle PL/SQL
Strong working knowledge Business intelligence and reporting tool (BIRT) and the understanding of the underlying data and tables in IBM Curam framework for the product delivery cases and the financial part to support all kinds of reports for case workers
Strong working knowledge of Build data analytics solutions using Azure Synapse serverless SQL pools
Demonstrated experience with Azure Synapse Analytics, including Synapse pipelines, SQL pools, and Spark pools.
1-2 years of experience utilizing Python, PySpark , and SparkSQL on Azure Cloud
Experience configuring, designing, developing and testing dash boards using Power BI
Lead and mentor other reporting developers in data integration efforts, utilizing ETL design patterns, error handling and configurations
Required Skills:
Experience programming and design of large scale web based distributed systems 5 Years
Experience in using Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI), 5 Years
Experience with SQL scripting and Relational Database modeling 5 Years
Experience with Experience with structured system development methodologies 5 Years
Ability to develop relationships/partnerships with customer by responding to needs and exhibiting an sense of urgency; independently identify options.
Ability to organize, prioritize, and follow complex and/or detailed technical procedures.
Highly Desired Skills
Prefer experience with Business Intelligence tools such as Business Objects or BIRT 2 Years
Prefer Data Warehouse experience 2 Years
Experience with the Cúram product. 4 Years
Strong SQL Skill 2 Years
Synapse
Medicaid
Contact the recruiter working on this position:
The recruiter working on this position is Rohit(Shaji Team) Bala
His/her contact number is His/her contact email is rohit@msysinc.com
Our recruiters will be more than happy to help you to get this contract.