Job Description
ABC - Data Migration Developer
VENDOR MAXIMUM SUBMITTAL RATE $$$.$$/hr.
Phone IVs can be available but no offer will be extended until in person IV completed.
*local candidates strongly preferred
*ALL candidates MUST be able to attend a personal interview within a reasonable time-frame should interest be expressed.
ABOUT THE ROLE
The successful candidate will conduct data migration activities for a new ERP implementation (Accela). Responsibilities include end-to-end data migration such as: analysis, mapping, writing extraction logic and flows, quality & validation processes to ensure the successful migration of data from legacy systems to the new system.
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
Required/Desired Skills SkillRequired /DesiredAmountof ExperienceExperience with a prior data migration, conversion, or integration project for a new ERP system implementationRequired5YearsProficiency with a major ETL/integration platform such as Oracle Data Integrator (highly preferred)Required5YearsAdvanced knowledge of SQL scripting and working with relational database systemsRequired8YearsExperience with defining data objects, ERDs, models, data definitions and data mapping activities between various formats and systemsRequired5YearsExperience with legacy COTS/ERP systems such as Oracle, peoplesoft, SAP, Lawson, etc.Highly desired3YearsFamiliarity with master data management concepts and practicesHighly desired2YearsExperience working with web services (REST or SOAP) for data integration and interfacesHighly desired2YearsFamiliarity with data warehouse concepts and models (star schema, dimensions, multi-dimensional)Highly desired2YearsExperience gathering requirements and producing technical specifications and documentsHighly desired5YearsExperience with reporting and BI tools such as Oracle BI Publisher, Crystal, OTBI, Oracle BI, or SmartViewHighly desired2YearsClear and effective communication, verbally and in writingRequired2YearsExp with Accela product and implementationDesired2Years
Questions No.QuestionQuestion1Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?Question2Please list candidate's email address that will be used when submitting E-RTR.Question3In what city/state does the candidate reside? Question4Does your candidate's experience match or exceed the required skills listed above and the number of years of experience with each skill? Question5Is candidate willing and able to travel to Richmond, VA for a personal interview? Manager will ONLY conduct in person interviews, NO Skype, NO exception Question6Does your candidate agree to complete the entire engagement? Question7How soon after an offer can your candidate start? Question8Has your candidate been submitted to CAI in the past by your company or any other vendor? If so, for which agency and when? Question9Does you candidate have any exp with the Accela product and implementation? This is a desired (not required) skill. If yes, tech details must be clearly reflected on the resume.
Job Tags
Local area