Oracle Consultant

Role Description

This is a full-time hybrid role for an Oracle Consultant specializing in CCS data migration. Based in Bengaluru, this role offers the flexibility to work both on-site and remotely. Responsibilities include implementing and optimizing Oracle Applications, managing data migration related to CCS projects, consulting on customizations and configurations, analyzing business processes, and ensuring alignment with enterprise project management strategies. The candidate will collaborate with cross-functional teams to ensure successful project execution.

CCS Data Migration

A consultant to migrate legacy utility billing data into the Oracle Utilities Customer

Cloud Service (CCS) or Customer-to-Meter (C2M) platform. The role involves

analyzing legacy data, mapping it to Oracle formats, and managing the entire data

migration lifecycle.

Key Responsibilities

A job description for an Oracle CCS Conversion Consultant generally includes the

following responsibilities:

Legacy Data Analysis: Analyze and profile data from source systems to

determine the scope and requirements for conversion into Oracle Utilities

applications (CCS/C2M).

Mapping and Design: Develop detailed data mapping specifications between

legacy fields and target Oracle Application Framework (OUAF) tables.

Extraction, Transformation, and Loading (ETL):Design, develop, and test

processes for extracting legacy data, transforming it into the required input file

formats (using tools like SQL Loader for staging), and loading it into the target

Oracle environment.

Conversion Orchestration: Configure and utilize Oracle Utilities Cloud Services'

data conversion support tools and batch processes to orchestrate the migration

efficiently.

Validation and Reconciliation: Create and execute validation scripts and

reconciliation reports (often using Analytics Publisher) on both staging and

production data to ensure data integrity and accuracy post-conversion.

Testing and Cut-over Support: Participate in system integration testing (SIT),

user acceptance testing (UAT), and provide support during the final production cut-

over activities.

Documentation: Maintain comprehensive documentation for all conversion

processes, issues, and resolutions.

Collaboration: Work closely with utility clients, functional consultants, and other

technical teams to ensure successful project delivery.

Required Skills and Qualifications

Typical qualifications for this role include:

Experience: Proven experience in data migration, conversion, and integration

projects, specifically within the utilities industry.

Technical Proficiency: Strong expertise in Oracle Utilities applications, including

CCS, C2M, CC&B (Customer Care and Billing), and OUAF.

Database Skills: Proficiency in SQL, PL/SQL, and Oracle database concepts.

Tools: Experience with data migration tools, batch processing, and possibly cloud

platforms (OCI - Oracle Cloud Infrastructure).

Problem-Solving: Strong analytical and problem-solving skills to manage data

discrepancies and technical challenges.

Communication: Excellent communication and collaboration skills to interact with

• stakeholders and project teams.