Galactic Network Integrators is Hiring a Data Migration/Conversion Lead Near Richmond, VA
• 20 years of experience architecting IT solutions • Expertise in the development of data migration strategies • Expertise in project management, data conversions and data warehousing and reports design, development, and implementation • Expertise with the following tools and languages: SQL, PL/SQL, SQL*Plus, SQL*Loader, Unix shell scripts, Parallel Query, Unix, java, Pro*C, TOAD, SQL Developer, Data Integrator, Warehouse Builder, Business Objects, Agile, jDeveloper, Discoverer, Developer, Cognos reports development, Microsoft Power BI • Expertise with the Meter to Cashflow Lifecycle, Meter Data Management, Operational Device Management (ODM), Work and Asset Management (WAM), SharePoint, SVN, Azure DevOps • Database expertise • Develop PL/SQL scripts to transform CIS data to CIS schema per the defined mapping rules • Develop controls/balancing reports to reconcile records in source and target databases • Develop validation SQLs to verify the integrity of the transformed data • Develop ad-hoc data repair SQLs to resolve data conversion errors • Use CIS toolkit to generate the CIS keys and perform CIS validations • Use CIS Config Tools for data migration • Prepare sandbox environment
REQUIREMENTS
1. Strong experience (10 years) in developing PL/SQL procedures 2. 10 years’ utility experience, preferably in the water and gas sectors 3. 10 years’ experience with data conversion / mapping for complex systems 4. Expert with CIS data model 5. Expert knowledge of CIS data conversion tool kit 6. Excellent interpersonal skills to work as a team member 7. Intermediate – expert level in Microsoft Office Suite, Projects, and Teams