ABC ETL & Data Migration Developer (581472)

  • Apertus Partners
  • Richmond, VA, Richmond, Virginia, United States
  • Dec 04, 2018
Contractor Information Technology

Job Description

Apertus Partners is currently seeking a Data Migration Developer to assist one of our clients.

The successful candidate will lead ETL and data migration activities for a new ERP implementation. Responsibilities include end-to-end data migration activities such as: data analysis, mapping, writing extraction logic and ETL flows, and data quality & validation processes to ensure the successful migration of data from legacy systems.

RESPONSIBILITIES

- Lead ETL and data migration activities for a new ERP implementation

- Advise business on options, risks, and any impacts related to data conversion & migration

- Design & create ETL processes as needed to meet business requirements and ensure successful data migration for project implementation

- Perform Data Profiling, Assessment, and Data Cleansing as required to meet data migration goals

- Continually seek ways to improve the process of data conversion, migration, and integration from the legacy environment to a new system

- Share knowledge and create proper documentation (such as diagrams and presentations) related to the ETL & data migration efforts

- Provide quality formal and informal documentation consistent with documentation standards

- Close attention to detail to ensure integrity and quality of data migration

- Report progress to business and project managers in a timely manner

REQUIRED SKILLS (8+ Years' experience for required skills)

- Required - Experience completing a previous data migration project for a new, large systems implementation

- Required - Proficiency with common data and/or ETL tools including SQL Developer, Oracle Data Integrator (ODI), Excel, and other equivalent ETL or data movement and extraction tools

- Required - Intermediate to Advanced knowledge of Oracle and PL/SQL scripting, databases, data structures, and data types/formats

- Required - Experience defining and mapping data objects, models and data definitions for business systems and their various functional components required for Data Migration/Conversion/Integration

PREFERRED SKILLS (2+ Years' Experience)

- Preferred experience with commercial (COTS) system solutions and ERP systems

- Preferred some experience with Master Data Management (MDM) concepts and practices

- Preferred experience with a legacy ERP systems (such as Oracle, Peoplesoft, SAP, Lawson)

- Preferred experience with Object Oriented Concepts, SOA, and Web Services (REST, SOAP)

- Preferred experience with Data Warehousing, ETL, & common methodologies for loading and extraction of data

- Preferred experience with reporting and BI tools such as SSRS, Oracle BI Publisher, Crystal, or other standardized reporting & BI tool

LEADERSHIP SKILLS

- Demonstrated ability to manage project scope, timelines, and customer expectations

- Demonstrated follow-through on assignments and issue resolution

- Provide input in the development of tools and processes to help increase team productivity

COMMUNICATION & CONSULTING SKILLS

- Provide overall guidance and leadership to team and client in areas of Data Architecture, Conversion, Migration, and Integration

- Clear and effective communication

- Consistently produce clear, concise status reports

- Builds confidence and trust with clients

- Displays effective analytical skills