Job Title

Role DescriptionThis 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 MigrationA consultant to migrate legacy utility billing data into the Oracle Utilities CustomerCloud Service (CCS) or Customer-to-Meter (C2M) platform. The role involvesanalyzing legacy data, mapping it to Oracle formats, and managing the entire datamigration lifecycle. Key ResponsibilitiesA job description for an Oracle CCS Conversion Consultant generally includes thefollowing responsibilities:Legacy Data Analysis: Analyze and profile data from source systems todetermine the scope and requirements for conversion into Oracle Utilitiesapplications (CCS/C2M).Mapping and Design: Develop detailed data mapping specifications betweenlegacy fields and target Oracle Application Framework (OUAF) tables.Extraction, Transformation, and Loading (ETL):Design, develop, and testprocesses for extracting legacy data, transforming it into the required input fileformats (using tools like SQL Loader for staging), and loading it into the targetOracle environment.Conversion Orchestration: Configure and utilize Oracle Utilities Cloud Services'data conversion support tools and batch processes to orchestrate the migrationefficiently.Validation and Reconciliation: Create and execute validation scripts andreconciliation reports (often using Analytics Publisher) on both staging andproduction 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 conversionprocesses, issues, and resolutions.Collaboration: Work closely with utility clients, functional consultants, and othertechnical teams to ensure successful project delivery. Required Skills and QualificationsTypical qualifications for this role include:Experience: Proven experience in data migration, conversion, and integrationprojects, specifically within the utilities industry.Technical Proficiency: Strong expertise in Oracle Utilities applications, includingCCS, 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 cloudplatforms (OCI - Oracle Cloud Infrastructure).Problem-Solving: Strong analytical and problem-solving skills to manage datadiscrepancies and technical challenges.Communication: Excellent communication and collaboration skills to interact withstakeholders and project teams.