Current Job Openings

Data Migration SME: Montana & Albany, NY

Due Date:
Saturday, December 31, 2022 1:00 PM

Job Title:
Data Migration SME

Location:
Montana & Albany, NY

Scheduled Work Hours:
Full Time - 9 to 5 - 40hrs/wk

Mandatory Skills:
Total experience in Information Technology field. Required 6-8 Years
• Experience with Oracle database version 12.1.0 or higher & My SQL Version 8.0. Required 5 Years
• Experience in writing complex queries, stored procedures in PL/SQL, query optimization, and scripts. Required 3 Years
• Experience extracting data from Oracle databases. Required 3 Years
• Experience in data validation, verification, and cleansing using PL/SQL Scripts. Required 5 Years
• Experience understanding existing entity relationship diagrams (ERD) & creating new ones. Required 3 Years
• Experience in high data volume data conversion environments. Required 3 Years
• Background with RDBMS and coding. Required 5 Years
• Experience creating shell script in a UNIX/LINUX environment. Required 3 Years
• Experience with Data migration using scripts. Required 3 Years
• Experience developing logical and physical data models. Desired 5 Years
• Experience extracting data from Oracle databases.
• Experience working within a development environment and with common tools such as code repositories and group collaboration applications. Desired 5 Years

Desired Skills:
The consultant should have at least the following skills:
• The consultant will play a key role in data cleansing and migration from legacy system using ETL design, data modeling, and ETL development.
• Research and analyze current systems, subsystems and interfaces to understand the current process flows
• Able to understand existing data objects and their relationships, recognize data duplication and redundancies in disparate applications and design new data model that consolidates all data from disparate applications into single source of truth
• Gain team and stakeholder approval for all designs, and effort estimates
• Document to-be-design using ERD tools.
• Develop unit tests and validation tests.
• Codes, tests, debugs, implements, and document programs.
• Creates technical documentation for scripts and programs.

Apply for this job

« Back to Current Job Openings