What are the responsibilities and job description for the ETL Data Analysis & Conversion position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Intellibee Inc, is seeking the following. Apply via Dice today!
Key Responsibilities
Data Analysis & Conversion
Key Responsibilities
Data Analysis & Conversion
- Lead endtoend FAS data conversion strategy, including mapping, transformation logic, and reconciliation.
- Direct data validation cycles and resolve complex data anomalies to ensure accuracy and completeness of converted Member, Claims, and Finance data.
- Manage mock conversion cycles and coordinate with technical and business teams to ensure readiness for migration.
- Oversee data quality assessments and ensure converted data meets business, audit, and regulatory standards.
- Develop and document conversion crosswalks and migration procedures for transitioning legacy data into FAS.
- Partner with technical architects to optimize conversion performance, minimize downtime, and support a smooth cutover.
- Provide governance oversight on system design decisions to ensure alignment with architectural standards and operational readiness requirements.
- Perform data analysis related to data conversion from legacy systems to new platforms, including validation of mapping rules, data integrity checks, and reconciliation.
- Assist in defining and executing data validation strategies to ensure accuracy and completeness during migration efforts.
- Analyze large datasets to identify discrepancies, trends, and anomalies during conversion and testing phases.
- Develop SQL/Teradata queries for data validation, reconciliation, and reporting.
- Document data conversion rules, transformation logic, and validation results to support audit and compliance requirements.
- Work closely with ETL developers and business teams to ensure data quality and consistency across systems.
- Develop and execute the overall Test Strategy, including System Integration Testing (SIT), User Acceptance Testing (UAT), and EndtoEnd (E2E) testing for MMIS and MES modules.
- Test Commercial OfftheShelf (COTS) applications and support data conversion and integration across MES modules and COTS products.
- Create and support the development of Business Test Scenarios, Test Cases, and Test Data; assist with test execution activities.
- Support ongoing releases, system enhancements, and production defect resolution.
- Manage defect triage calls with multiple vendors and ensure accurate tracking and timely closure of defects.
- Communicate UAT status, progress metrics, and results to stakeholders; maintain comprehensive historical testing documentation.
- Collaborate effectively with technical teams, business users, and crossfunctional groups with minimal supervision.
- Proven Agile Testing experience, with the ability to plan and execute functional, integration, and regression testing within iterative sprint cycles.
- Data Analysis: Strong experience in data conversion, mapping rules, validation, ETL design, and programming logic.
- Exp with Large-Scale Claims Processing Software (MMIS or similar): Mgr will give preference to people who have worked on MMIS or Conduent in past Highly desired 5 Years
- Experience in Data Analysis (large datasets, trend identification) Required 10 Years
- Knowledge of Programming Logic Required 10 Years
- Experience in Data Conversion, Mapping Rules, and Validation Required 10 Years
- Experience in ETL Design and Data Transformation Required 10 Years
- Experience with Evaluating and Presenting Conversion Results Required 10 Years
- Experience with Teradata Queries and SQL Required 10 Years
- Ability to Document Data Conversion Rules and Validation Results Required 10 Years
- Experience in Data Quality Assurance and Reconciliation Required 10 Years
- Experience in Collaborating with ETL Developers and Business Teams Required 10 Years
- Experience with Azure DevOps or Similar Test Management Tools Required 5 Years
- Excellent organizational and communication skills; ability to meet deadlines with professionalism and customer focus. Required 10 Years