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. **Data Conversion Specialist Role:** 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. **Essential Job Functions:** + 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 **Responsibilities** The candidate will be a skilled technical consultant with experience on multiple Oracle Utilities projects, along with demonstrable leadership experience. Below are the key responsibilities for this position: + Analyzes business needs to help ensure Oracle solution meets the customer's objectives by combining industry best practices, product knowledge, and business acumen. + Exercises judgment and business acumen in selecting methods and techniques to deliver functional and technical solutions on non-routine and very complex aspects of applications and technology installations. + Provides direction and mentoring to project teams, and effectively influences customer leadership on key decisions. + Supports the business development efforts by pursuing new opportunities and extensions. + Collaborates with the consulting sales team by providing domain expertise. + Resolves complex customer issues by recommending and implementing solutions. + Demonstrates expertise in multiple business processes across two or more product families or ability to architect and design technology solutions encompassing multiple products and make decisions based on impact across the stack. Disclaimer: **Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.** **Range and benefit information provided in this posting are specific to the stated locations only** US: Hiring Range in USD from: $97,500 to $199,500 per annum. May be eligible for bonus and equity. Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle's differing products, industries and lines of business. Candidates are typically placed into the range based on the preceding factors as well as internal peer equity. Oracle US offers a comprehensive benefits package which includes the following: 1. Medical, dental, and vision insurance, including expert medical opinion 2. Short term disability and long term disability 3. Life insurance and AD&D 4. Supplemental life insurance (Employee/Spouse/Child) 5. Health care and dependent care Flexible Spending Accounts 6. Pre-tax commuter and parking benefits 7. 401(k) Savings and Investment Plan with company match 8. Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation. 9. 11 paid holidays 10. Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours. 11. Paid parental leave 12. Adoption assistance 13. Employee Stock Purchase Plan 14. Financial planning and group legal 15. Voluntary benefits including auto, homeowner and pet insurance The role will generally accept applications for at least three calendar days from the posting date or as long as the job remains posted. Career Level - IC4 **About Us** As a world leader in cloud solutions, Oracle uses tomorrow's technology to tackle today's challenges. We've partnered with industry-leaders in almost every sector-and continue to thrive after 40+ years of change by operating with integrity. We know that true innovation starts when everyone is empowered to contribute. That's why we're committed to growing an inclusive workforce that promotes opportunities for all. Oracle careers open the door to global opportunities where work-life balance flourishes. We offer competitive benefits based on parity and consistency and support our people with flexible medical, life insurance, and retirement options. We also encourage employees to give back to their communities through our volunteer programs. We're committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by emailing [email protected] or by calling +1 888 404 2494 in the United States. Oracle is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans' status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.