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.