Job Description :
ROLE Lead ETL and data migration Developer

LOCATION Richmond VA

DURATION LONG TERM

RATE DOE

DIRECT CLIENT YES

INTERVIEW TYPE In-Person only

Local candidates strongly preferred

ALL candidates MUST be able to attend a personal interview, NO phone interviews, NO Skype, NO exceptions

State Experience Highly Preferred

U.S. Citizens and those authorized to work in the U.S. are encouraged to apply

Note: For H1 While submitting I need consultant I 797 OR ID Proof.

The successful candidate will lead ETL and data migration activities for a new ERP implementation. Responsibilities include designing ETL flows, data mapping and data migration processes to ensure the successful migration from legacy systems.



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 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 (6+ Years’ experience for required skills)

Required – Experience completing a previous data migration project for a new 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 knowledge of Oracle and PL/SQL scripting, databases, data structures, and data types/formats

Required - Experience defining data objects, models and data definitions for financial business systems by mapping its various components as required for Data Migration/Conversion/Integration



PREFERRED SKILLS/EXPERIENCE

Preferred - Oracle ERP & Fusion certification and experience with data migration

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

Preferred - Experience with a legacy Financial ERP data extraction (Oracle, Peoplesoft, SAP, Lawson)

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

Preferred - Experience with Data Warehousing & common practices

Preferred - Experience with Oracle Fusion data loading using File Based Loader

Preferred - Experience with Oracle ICS/iPaaS and Cloud Data Integration platform

Preferred - Experience with reporting and BI tools such as Oracle BI Publisher, OTBI, Oracle BI, and SmartView

LEADERSHIP SKILLS

Demonstrated ability to manage project priorities and deliverables

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 project in the areas of Data Architecture, Conversion, Migration, and Integration

Clear and effective communication (both verbally and in writing)

Consistently produce clear, concise status reports

Builds confidence and trust with clients

Displays effective analytical skills

Skills Required Years Used Last Used

Experience with a prior data migration, conversion, or integration project for a new ERP system implementation

5

Proficiency with a major ETL/integration platform such as Oracle Data Integrator (highly preferred)

5

Advanced knowledge of SQL scripting and working with relational database systems

10

Experience defining data objects, models, data definitions and mapping data between various formats and systems

5

Experience with Oracle Fusion ERP

2

Experience with legacy financial systems or other major Financial ERP system (Oracle, peoplesoft, SAP, Lawson, etc

3

Familiarity with master data management concepts and practices

2

Experience working with web services (REST or SOAP) for data integration and interfaces

2

Familiarity with data warehouse concepts and models (star schema, dimensions, multi-dimensional)

2

Experience gathering requirements and producing technical specifications and documents

5

Experience with reporting and BI tools such as Oracle BI Publisher, Crystal, OTBI, Oracle BI, or SmartView

Nice to have

Clear and effective communication, verbally and in writing

Required