Data Conversion Specialist

Job Description

Oracle Customer Solutions for Industries delivers Oracle solutions to customers in multiple industries. This includes the Utilities, Construction and Engineering and Communications Business Unit that delivers proven industry software applications that help companies of all types and sizes achieve competitive advantage, business performance excellence and a lower total cost of technology ownership.

Oracle Utilities integrates industry-specific customer care and billing, network management, work and asset management, mobile workforce management and meter data management applications with the capabilities of Oracle’s industry-leading enterprise applications, business intelligence tools, middleware, database technologies, as well as servers and storage. The software enables customers to adapt more nimbly to market deregulation, meet ever-evolving customer demands and deliver on environmental conservation commitments.

Oracle Utilities delivery team enhances the Oracle brand by delivering best of breed business solutions and professional services to the utility industry around the world. Our customers value us above all other competitors because of our thought leadership, understanding of their needs, talents and superior ability to provide world‑class solutions for the challenges they face.

The data conversion specialist engages with clients to move their data from a legacy application to one of Oracle’s Utilities applications. As a recognized authority and leading contributor within their practice, this senior‑level consulting position provides consistent high quality and innovative solution leadership to a project team. Leads the solution design and implementation aspects of engagement(s) ensuring high quality, integrated software solutions within constraints of time and budget.

The Oracle Data Conversion Specialist conducts discovery workshops to identify data elements in the legacy system, to map those elements into their Oracle equivalents, and to develop a conversion strategy. With the data elements and strategy defined, the Data Conversion Specialist uses/develops tools to create the scripts to extract data to a staging database, then transforms and loads the data to the target application.

Also, coordinates mock conversion and dress rehearsal activities and resolves data issues. Once the data is loaded, the Data Conversion Specialist validates data against the legacy system to ensure the conversion was successful, and complete. This is done for large volumes of data.

• Lead workshops and design sessions to capture and document conversion requirements
• Develop data conversion plans, strategy, and approach
• Be an onsite technical lead, as necessary, and coordinate with offshore team to accomplish activities
• Be a technical liaison with Client, Project Management and Oracle product group
• Work on Oracle Utilities data conversion and integration projects
• Design and implement data conversion of CIS solutions to Oracle Energy and Water applications
• Design programs and scripts for the creation and migration of data from source to target systems
• Lead the development and unit testing of data extract scripts
• Lead the development and unit testing of data conversion scripts
• Design and develop Extract, Transform, and Load (ETL) jobs
• Liaise with business and participate with design walkthroughs; discuss/explain functional requirements
• Identify and coordinate legacy data cleanup activities with the business
• Identify potential risk and problem areas and develop procedures that provide effective workarounds to the problem at hand
• Create balancing and audit control procedures and reports
• Advise business on options, risks and any impacts related to data conversion & migration
• Manage all data conversion activities from project initiation to production cutover and support
• Share knowledge and create proper documentation related to the ETL, data mapping and migration efforts

The candidate will be a skilled technical consultant with experience on multiple Oracle Utilities projects, along with demonstrable leadership experience.

Below are the key…