Oracle Data Integrator - C2C Contract Position

As an Oracle Data Integrator specialist working in a Child Welfare domain, you will play a pivotal role in designing, developing, and deploying robust data integration solutions that enable informed decision-making, enhance operational efficiency, and drive strategic initiatives forward. This position offers the chance to work collaboratively with cross-functional teams, leveraging your expertise to tackle complex data integration challenges and deliver tangible value to an organization.

If you are a driven, innovative problem-solver with a strong background in Oracle Data Integrator, a passion for driving data-driven insights and are able to work as a C2C, we encourage you to apply today

.

WHAT YOU'LL NEED:Your C2C documentationCommitment to work the contract duration of 24 months.Ability to be on site the first workday in Albany,

Ny

What You'll Bri

Ng

Seven years'

experience in all of the follow

ing:

Reverse engineering Oracle Warehouse Builder (OWB) ETL processes and developing new replacement Oracle Data Integrator (ODI) processes while maintaining consistent functionality.Data Modeling (Dimensional & Relational), process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation in a child welfare environmentWorking in an Oracle Data Warehouse performing development work using PL/SQLUsing advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.Developing and testing maps, performing source-to-target mappings, storage capacity planning and developing ETL in Oracle Data Integrator (ODI)

Experience in SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support, load issue resolutions, load inquiries, 2nd level testing of issues and code fixes, infrastructure upgrades and enhancements (Oracle upgrades).Working in UNIX or LINUX environment developing Unix Shell Scripting and sftp protocols.Building database schemas, tables, views, indexes, and stored proced

ures.