Oracle Data Integrator (ODI) ETL Developer with Oracle BI Publisher, data migration/conversion/mapping, SQL, Oracle/PeopleSoft/SAP/Lawson, MDM, web services/REST/SOAP, DW, Crystal Reports, OTBI, SmartView and Accela experience

Job ID: VA-620252 (99190120)

Oracle Data Integrator (ODI) ETL Developer with Oracle BI Publisher, data migration/conversion/mapping, SQL, Oracle/PeopleSoft/SAP/Lawson, MDM, web services/REST/SOAP, DW, Crystal Reports, OTBI, SmartView and Accela experience

Location: Richmond VA (ABC)
Duration: 6 months
Interview: In-person only (local Richmond candidates strongly preferred)

Experience with a prior data migration, conversion, or integration project for a new ERP system implementation Required 5 Years
Proficiency with a major ETL/integration platform such as Oracle Data Integrator (highly preferred) Required 5 Years
Advanced knowledge of SQL scripting and working with relational database systems Required 8 Years
Experience with defining data objects, ERDs, models, data definitions and data mapping activities between various formats and systems Required 5 Years
Experience with legacy COTS/ERP systems such as Oracle, peoplesoft, SAP, Lawson, etc. Highly desired 3 Years
Familiarity with master data management concepts and practices Highly desired 2 Years
Experience working with web services (REST or SOAP) for data integration and interfaces Highly desired 2 Years
Familiarity with data warehouse concepts and models (star schema, dimensions, multi-dimensional) Highly desired 2 Years
Experience gathering requirements and producing technical specifications and documents Highly desired 5 Years
Experience with reporting and BI tools such as Oracle BI Publisher, Crystal, OTBI, Oracle BI, or SmartView Highly desired 2 Years
Clear and effective communication, verbally and in writing Required 2 Years
Exp with Accela product and implementation Desired 2 Years

RESPONSIBILITIES
• Data migration activities for a new ERP implementation (Accela)
• Advise business on options, risks, and any impacts related to data conversion & migration
• Design & create SQL scripts and 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 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, Excel, and other equivalent 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)

• HIGHLY DESIRED – Experience with Accela product and implementation
• Experience with commercial (COTS) system solutions and ERP systems
• Some experience with Master Data Management (MDM) concepts and practices
• Experience with a legacy ERP systems
• Experience with reporting using SSRS and PowerBI

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

VA_E-RTR-620252.doc

Leave a Reply