ETL and Report Developer - Hybrid

Title: ETL and Report Developer - Hybrid

Description:

The client requires the services of a senior ETL and report developer to provide business and systems analysis, modeling, design, and programming for Medicaid reports development and maintenance operations using ORACLE, and PL\SQL programming technologies. This role will collaborate with the client Medicaid team to develop and maintain 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.

This developer will work with our internal business team to deliver weekly and monthly reports for our internal offices and also with Centers for Medicare and Medicaid Services(CMS). And also adhoc reports to meet the legislative and other requirements needs. This role will help take care of the maintenance and enhancements of several Medicaid related reports, some of them are daily, weekly, monthly, quarterly and annual including the critical CMS Reports.

This role will also help deliver the data into CSDW and BIDP for all the federal and other reporting purposes. Collaboration with other members of the Medicaid application development team will be essential to develop code for both existing and new requirements.

This role will interact with the client business team in the Medicaid area and work with the agile team as well for testing the reporting side of code for Medicaid and interact with the release team for source control and code build and release related activities for the Medicaid area of the code. This role WILL need to have strong working experience in ORACLE, PL/SQL, Business intelligence and reporting tool (BIRT), Power BI and Azure Synapse 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, client controller office and CMS.

This role will also help develop ETLs and new dashboards for Medicaid and other programs using Power BI and Azure Synapse and help move Medicaid programs into Cloud Architecture as part of the application modernization effort.

This role will take on a leadership role, mentoring other report developers, establishing standards across the reporting area, and ensuring the accuracy and correctness of reports and data before delivery to stakeholders.

Required/Desired Skills:

Skill - Required / Desired - Amount of Experience

Experience programming and design of large scale web based distributed systems. - Required - 7 Years
Knowledge of Oracle, Oracle Utilities, ETL tools such as Oracle Warehouse Builder (OWB) or Oracle Data Integrator (ODI). - Required - 7 Years
Experience with SQL scripting and Relational Database modeling.. - Required - 7 Years
Experience with structured system development methodologies. - Required - 7 Years
Good communication skills both oral and written and ability to maintain effective working relationships with end users and staff. - Required - 7 Years
Knowledge of Business Intelligence tools such as Business Objects or BIRT - Highly desired - 7 Years
Data Warehouse experience - Highly desired - 5 Years
Previous experience working with State government. - Highly desired
Strong experience with SQL and PL/SQL coding. - Required - 7 Years

Mandatory skills:

SQL, PL/SQL coding,
business analysis, systems analysis, modeling, design, programming,
Medicaid reports development, maintenance operations, reporting code, Centers for Medicare and Medicaid Services, CMS, CMS Reports, Medicaid programs,
Business intelligence, reporting tool, BIRT, Power BI, Azure Synapse, IBM Curam framework, Cloud Architecture,
web based distributed systems,
Oracle, Oracle Utilities, ETL tools, Oracle Warehouse Builder, OWB, Oracle Data Integrator, ODI,
SQL scripting, Relational Database modeling,
structured system development methodologies

VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.

Contact Details :

Account co-ordinator: Binodh M.T, Phone : , Email:

VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
| ;/p>