Oracle CCS consultant

Summary: The Oracle CCS Consultant role involves leading and executing Oracle CCS and WACS projects, focusing on data mapping, transformation, and validation. The consultant will collaborate with various teams to ensure data integrity and support project leadership during go-live activities. Strong SQL skills and a deep understanding of the Oracle CCS data model are essential for success in this position. The role is remote and classified as outside IR35.

Key Responsibilities:

• Lead and execute Oracle CCS and WACS, including data mapping, transformation, staging, validation, and final load.
• Collaborate with functional teams, system SMEs, and Oracle counterparts to understand data mapping and business rules.
• Develop and manage conversion design documents, mapping templates, and data validation reports.
• Coordinate and perform mock conversion cycles.
• Reconcile converted data between legacy and CCS systems to ensure data integrity and audit compliance.
• Troubleshoot conversion defects, raise/resolving issues, and escalate to Oracle as required.
• Support project leadership in planning and executing go-live cutover conversion activities.
• Understand and execute generating Oracle keys as part of the conversion process and creating conversion workflows as part of conversion execution plan.

Key Skills:

• Deep understanding of Oracle CCS data model (must-have)
• Strong SQL skills for data extraction, validation, and reconciliation (must-have)
• General understanding of WACS data model (nice-to-have)

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT