Data Migration and Management Lead, Teracore, Washington, DC
Teracore -
Washington, DC,
US
Data Migration and Management Lead
Date Posted: 2024-05-19
Job description
Teracore is a Service Disabled Veteran Owned Small Business (SDVOSB) classified management consulting and information technology services firm. We are committed to creating and maintaining a corporate environment and culture that promotes long-term employment. Diverse talents help us to achieve the missions and objectives of our customers. We hope we can partner together to achieve those goals.
US CITIZENSHIP REQUIRED; ABILITY TO OBTAIN PUBLIC TRUST CLEARANCE
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:
Required Skills:
At Teracore, we support, depend and thrive on differences for the benefit of our associates and customers. Teracore is an equal opportunity employer. Employment decisions are based solely on a person's merit and professional qualifications directly related to job competence.
US CITIZENSHIP REQUIRED; ABILITY TO OBTAIN PUBLIC TRUST CLEARANCE
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
Required Skills:
- MA/MS/BA/BS degree and 10 years of experience in supporting large data migration/conversion for ERP applications
- Must be a pro-active, value-add contributor to all data management meetings especially with the client, but also with the Teracore data team
- 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:
- Creating and using data conversion templates
- Data source gap analysis
- Development and execution of SQL-based scripts to support data analysis
- Gathering requirements
- Reviewing technical specifications
- Ensuring data security
- Performing data extract and cleansing; data transform and load
- Prepare data for and assist in the execution of mock data conversions
- Prepare for and assist with User Acceptance Testing of the migrated data
- end-to-end conversion test plans, executing test cases, documenting test results, tracing and resolving test defects, etc.
- Experienced in supporting Federal IT business application development and migration using a requirements driven lifecycle process (Specifically focused on the data architecture)
At Teracore, we support, depend and thrive on differences for the benefit of our associates and customers. Teracore is an equal opportunity employer. Employment decisions are based solely on a person's merit and professional qualifications directly related to job competence.