Roles & Responsibilities:
• Troubleshoot problems ranging from coding issues, connectivity issues, and client relation issues.
• Utilizing the architecture defined by the Solution Architect, implement a data migration framework for the Client.
• Manage intake of Client extracts. Communicate any data issues to client technical resources.
• Where applicable, act as the liaison between the DM client facing Business Analyst and the DM Development Team to ensure business processes, requirements, and specifications are understood. Support the DM Development Team by answering coding/technical questions, loading data, etc.
• Develop, upgrade, test, implement, and document data migration toolkits to meet project requirements.
• Troubleshoot and resolve issues as they arise including connectivity issues and application issues.
• Build and execute unit test cases to ensure data conversion quality and integrity.
• Perform data analysis and profiling of legacy and converted data.
• Load converted data to Facets via batch processes and/or custom jobs as needed.
• Prepare post load deliverables including Scorecards, Dashboards, batch logs, and custom report output.
• Assist in defect resolution by researching issues identified in Unit Test, SIT, UAT, Mock and Production
• Support the process design for loading of data to appropriate database(s) via batch processes and/or custom jobs as needed.
• Support the DM Solution Architect by providing potential solutions to client-specific data and mapping issues discovered either by the TZG team or the client.
• Partner with the Lead Business Analyst to triage issues identified in TZG Unit Testing, Client Data Validation, SIT, UAT, Mock Go Lives, and Production. Communicate to the Data Migration Development Team defect corrections and new requirements as needed.
• Generate all required technical documentation for a project. (Functional/Technical Specifications, Approach, Design, Deployment procedures etc.)
Skills & Qualifications:
1. BA/BS in Business Administration, Information Systems Management, Computer Science or related field, or an equivalent combination of education and/or experience
2. 1-3 years of experience with the Facets product, Facets configuration, data model, and batch processing
3. 3-5 years of experience as a developer performing as a key contributor on project teams
4. Experience of software tools, platforms, and processes such as SQL, PL/SQL, C#, AWS suite of tools, Python, Informatica, or similar ETL tool
5. Experience working with Oracle DB and MS SQL DB.
6. Snowflake experience preferred
7. Proficiency in analysis, communication skills, data profiling and analysis, and unit testing and data validation
8. Solid understanding of data model concepts