What are the responsibilities and job description for the Data Migration/Conversion Lead position at Galactic Network Integrators, INC?
• 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
• 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
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
