Oracle Technical Consultant(CCS data migration exp)

Starlightify; India; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

A leading IT consulting firm in India is seeking an Oracle Technical Consultant to manage data migration projects related to Oracle Utilities applications. This full-time role involves analyzing legacy data, developing mapping specifications, and ensuring accurate data conversion. Ideal candidates will have strong experience in the utilities industry, a solid understanding of Oracle applications, and excellent problem-solving skills. Join the team to collaborate on impactful projects in an innovative environment.

Qualifications

• Proven experience in data migration projects within the utilities industry.
• Strong expertise in Oracle Utilities applications including CCS, C2M, and CC&B.
• Strong analytical skills to manage data discrepancies.

Responsibilities

• Analyze and profile legacy data for conversion.
• Develop data mapping specifications for Oracle applications.
• Design and test ETL processes for data extraction and loading.
• Perform validation and reconciliation on converted data.
• Support system integration and user acceptance testing.

Skills

Data migration experience

Oracle Utilities applications expertise

SQL proficiency

Problem-solving skills

Communication skills

Tools

Data migration tools

SQL Loader

Job description

Oracle Technical Consultant (CCS Data Migration)

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

• 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.
• 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

• 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, and OUAF.
• Database Skills: Proficiency in SQL, PL/SQL, and Oracle database concepts.
• Tools: Experience with data migration tools, batch processing, and possibly cloud.
• 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.

Seniority Level

Mid‑Senior level

Employment Type

Full‑time

Job Function

Information Technology

Industries

IT Services and IT Consulting