|
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
|