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 implementationRequired5Years
Proficiency with a major ETL/integration platform such as Oracle Data Integrator (highly preferred)Required5Years
Advanced knowledge of SQL scripting and working with relational database systemsRequired8Years
Experience with defining data objects, ERDs, models, data definitions and data mapping activities between various formats and systemsRequired5Years
Experience with legacy COTS/ERP systems such as Oracle, peoplesoft, SAP, Lawson, etc.Highly desired3Years
Familiarity with master data management concepts and practicesHighly desired2Years
Experience working with web services (REST or SOAP) for data integration and interfacesHighly desired2Years
Familiarity with data warehouse concepts and models (star schema, dimensions, multi-dimensional)Highly desired2Years
Experience gathering requirements and producing technical specifications and documentsHighly desired5Years
Experience with reporting and BI tools such as Oracle BI Publisher, Crystal, OTBI, Oracle BI, or SmartViewHighly desired2Years
Clear and effective communication, verbally and in writingRequired2Years
Exp with Accela product and implementationDesired2Years
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