Data Conversion Consultant(Itron MDM | Utility AMI)

Ventois Software Solutions; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Ventois Software Solutions seeks an experienced Data Conversion Consultant to lead data discovery, profiling, mapping, transformation, validation, reconciliation, and cutover activities for the SCE AMI 2.0 modernization program. You will migrate historical and transactional meter data from Itron MDM and related sources into the target MDMS while ensuring data quality and business continuity.

The role requires leading ETL/data conversion efforts, supporting mock conversions, SIT/UAT cycles, and

Qualifications

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

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.

Skills

Utility AMI/MDM domain experience

Data conversion projects

Stakeholder communication

Analytical troubleshooting

Tools

SQL

Oracle

ETL tools

Data migration frameworks

Data quality techniques

Job description

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