Senior Data Migration Consultant

JCD Staffing LLC
Washington, DC, United States
5 days ago
Apply on www.careerbuilder.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Compensation
$125,000 - $130,000
Working hours
Regular working hours

Tech stack

Data Analysis Big Data Business Software Data Architecture Data Validation Data Cleansing Data Conversion Extract Transform Load (ETL) Data Transformation Data Migration Data Mining Data Security
+8 more
Load Testing Standard Sql Software Deployment PL-SQL SQL Databases Systems Integration SAP S/4HANA Data Management

Job description

Project Background: The Financial Services Modernization (FSM) program will address the need to select a new financial system service provider to implement improved and integrated financial system capabilities in support of its financial, procurement, and asset management operations to replace the current financial system (Momentum). Role Responsibilities: The data lead position will assist the government in fulfilling its data migration responsibilities; this includes but is not limited to:

  • Solid experience in developing data cleansing strategies, action plans, reconciliation plans and scripts
  • Developing data management plan
  • Good experience in writing SQL * Loader, SQL, PLSQL
  • Functional experience in SAP S/4Hana Federal Financials core modules including AP/PO/GL/AR/PR
  • Determining the validity of the values of the data elements
  • Reviewing and validating data relationships
  • Coordinating with data owners to validate cleansed data (e.g., reconciling transaction details to summary records such as commitments and obligations to General Ledger (GL) balances)
  • Determining data migration requirements
  • Defining roles and responsibilities for the data migration activities
  • Reviewing and providing comments and suggestions on the data management plan, data migration plan, checklist, timeline, and conversion report delivered
  • Documenting migration activity timelines for mock conversions and production deployment
  • Developing a data migration checklist and sign-off process to ensure completion of planned activities
  • Mapping the data in the format provided in conversion templates. This includes mapping the current account codes to the future account codes and Project/Organization/Expenditure Type/Task (POET)
  • Assisting with determining data migration security controls
  • Developing unit and end-to-end integration migration test plans (including testing for data extraction, transformation, data loading, and data validation)
  • Solid experience with data transformation and data load testing
  • Validating data of multiple mock conversions and the full migration coordinating with unit and end-to-end integration testing to ensure the flow of data from the source applications to the target applications is accurate
  • Documenting the end-to-end data migration test results and lessons learned report, * Must function as a trusted-advisor to the client ensuring that best practices are observed and issues are detected and mitigated by the Teracore team
  • Must have excellent communications skills, both oral and written, and be expert at developing presentations, reports, and data management plans.
  • Must function as a leader of the data migration team.
  • Data Migration Planning to include: 1. Creating and using data conversion templates 2. Data source gap analysis 1. Development and execution of SQL-based scripts to support data analysis 3. Gathering requirements 4. Reviewing technical specifications 5. Ensuring data security 6. Performing data extract and cleansing; data transform and load 7. Prepare data for and assist in the execution of mock data conversions 8. Prepare for and assist with User Acceptance Testing of the migrated data 1. end-to-end conversion test plans, executing test cases, documenting test results, tracing and resolving test defects, etc. 9. Experienced in supporting Federal IT business application development and migration using a requirements driven lifecycle process (Specifically focused on the data architecture)

Flexible work from home options available.

Requirements

Data Migration, Consulting, United States Citizen, Asset Management, Financial Services, Financial Systems, System Integration (SI), Procurement Management, Data Migration, Government, * MA/MS/BA/BS degree and 10 years of experience in supporting large data migration/conversion for ERP applications

About the company

JCD Staffing is a specialized staffing and consulting firm, focused on working with highly talented technical individuals to provide our clients with a unique, successful hiring experience. Our ability to form long-lasting relationships with both candidates and employers is the foundation of our success and what drives everything we do. Our team knows that cultivating these relationships leads to the most effective results, which drive your company’s growth and progress.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerbuilder.com
Prepare application

Good distractions

Loading talks and stories from around this role…