About this role
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