Data Conversion Consultant(Itron MDM | Utility AMI)

Role Summary:

Seeking an experienced Data Conversion Consultant with strong expertise in Itron MDM and utility data migration programs. The candidate will be responsible for leading data discovery, profiling, mapping, transformation, validation, reconciliation, and cutover activities as part of the SCE AMI 2.0 modernization program. The role involves migrating historical and transactional meter data from Itron MDM and related source systems into the target MDMS platform while ensuring data quality, completeness, and business continuity.

Key Responsibilities:

• Perform data analysis, profiling, cleansing, and mapping for Itron MDM and related utility source systems.
• Design and execute ETL/data conversion processes for meter, interval, usage, device, customer, and configuration data.
• Develop conversion specifications, transformation rules, and reconciliation procedures.
• Support mock conversions, SIT/UAT cycles, cutover planning, and production deployment activities.
• Validate data quality, perform reconciliation, and resolve data conversion issues.
• Collaborate with business, functional, integration, and testing teams to ensure successful migration outcomes.

Required Skills: 

• Strong experience in Utility AMI/MDM implementations and data conversion projects.
• Hands-on experience with Itron MDM data structures, meter reads, interval data, VEE, and device lifecycle management.
• Proficiency in SQL, Oracle, ETL tools, data migration frameworks, and data quality techniques.
• Experience with large-scale utility transformations involving millions of meters and historical data migration.
• Strong analytical, troubleshooting, and stakeholder communication skills.

Preferred Skills:

• Experience with SAP IS-U, Oracle Utilities, AMI 2.0, or Cloud MDMS implementations.
• Knowledge of utility meter-to-cash processes and AMI ecosystems.
• Prior experience supporting mock conversions, cutovers, and post-go-live stabilization