GDS Consulting_Oracle Kraken ETL Senior Consultant | ErnstYoung Job

Primary Responsibilities and Accountabilities:

• EY is seeking a highly skilled Utilities ETL (Oracle Utilities or Kraken preferred) and Data Migration Consultant to support large-scale utility transformation programs involving customer information systems (CIS), billing, meter-to-cash, and cloud platform implementations.
• The successful candidate will be responsible for designing, developing, and executing end-to-end data migration solutions from legacy utility platforms such as Oracle CC&B, Oracle C2M, SAP IS-U, CCS, and custom CIS applications into Kraken or other next-generation utility platforms.
• This role requires strong expertise in ETL development, data analysis, data quality management, reconciliation, and utility business processes including customer, billing, metering, payments, and collections.
• Lead Data Migration Strategy – Define and execute end-to-end migration strategy, planning, governance, and cutover activities.
• Develop ETL Solutions – Build scalable and automated ETL processes for utility data transformation and loading.
• Drive Data Mapping & Transformation – Translate business requirements into source-to-target mappings and transformation rules.
• Ensure Data Integrity – Implement data quality, validation, and reconciliation processes to achieve accurate migration outcomes.
• Support Testing & Deployment – Lead migration testing, dress rehearsals, production cutovers, and post-deployment stabilization.
• Manage Stakeholders & Delivery – Engage business and technology teams, provide migration leadership, and ensure successful project delivery.

Requirements (including experience, skills and additional qualifications)

Experience: 

• At least 4-7 years of experience in ETL and data migration projects.
• Minimum 1 utility CIS implementation or migration project completed.
• Experience on design and development
• Experience in developing Oracle Forms
• Knowledge on integration with other CX products is preferred.
• Experience of working on tools such as Informatica, Talend, Azure Data Factory, Databricks
• Experience of working in Database such as Oracle, SQL Server, PostgreSQL, Snowflake, MySQL
• Data Migration experience (data profiling, cleansing, mapping, transformation, reconciliation, governance, cutover planning, mock conversion, validation reporting)
• Nice-to-have Kraken experience

Competencies / Skills:

• Strong analytical and problem-solving skills
• Stakeholder management and communication
• Utility industry expertise
• Data quality and governance mindset
• Leadership and mentoring
• Client-facing consulting experience
• Ability to work in global delivery environments

Education:

• Bachelor’s degree in computer science, Information Systems, Engineering, Mathematics, or related discipline