Oracle CC&B Data Migration

Job Description

Role: Oracle CC&B Data Migration Experience Preferred: 5+ Years Location: Remote Job Description: Analyze legacy data sources and understand data structures, relationships, and constraints. Perform data profiling and data quality assessments for legacy and target systems. Develop data mapping documents between legacy systems and Oracle CC&B data model. Create and implement data migration scripts and conversion programs for extracting, transforming, and loading data into Oracle CC&B. Identify and resolve data anomalies and inconsistencies throughout the migration process. Participate in data migration design sessions, workshops, and review meetings. Support and execute mock data migration and dress rehearsals prior to final cutover. Develop data validation and reconciliation procedures to ensure completeness and accuracy post-migration. Maintain thorough documentation of data migration specifications, designs, and results. Collaborate with Oracle CC&B functional and technical teams, database administrators, and stakeholders to troubleshoot data migration issues and implement best practices. Support post-go-live stabilization and handover to the operational support team. Required Skills and Qualifications: Strong understanding of Oracle CC&B data model and application architecture. Experience with Oracle CC&B data migration projects, including extracting, transforming, and loading data. Proficiency in SQL, PL/SQL, and data migration tools (e.g., Oracle SQL Developer, ODI, Informatica). Experience with data profiling, quality assessments, and data cleansing. Strong analytical, problem-solving, and communication skills. Knowledge of utility industry data structures (customer, service point, meter data, billing, payments) is highly desirable. Ability to work in collaborative, cross-functional teams and meet project deadlines.