Arun Kumar

• Experience as the primary data quality and validation partner for cloud-based healthcare data platforms, supporting Claims, Enrollment, Provider, Member, and Encounter data.
• Validate CMS 834 enrollment and EDI 837 claims data, ensuring accurate eligibility, PCP assignment, member effective dates, and coverage logic, prior to downstream reporting and analytics.
• Work closely with data engineers to validate end-to-end ETL/ELT pipelines built on Azure Data Factory, Databricks, ADLS Gen2, Azure SQL, Snowflake, and Synapse.
• Develop and execute Python- and PySpark-based validation logic in Databricks notebooks to perform record-level reconciliation, schema validation, and data completeness checks.
• Perform data ingestion and transformation testing for flat files, JSON, HL7, and EDI formats across batch and API-driven pipelines.
• Validate REST APIs using Postman and Swagger, covering authentication, response schemas, pagination, and error handling.
• Support production issue triage by reproducing defects, analyzing root causes, and collaborating with engineering teams to reduce recurrence, and improve data reliability.
• Design and execute data quality checks focused on completeness, duplicates, referential integrity, and business rule enforcement.
• Support UAT and regression testing in staging environments, ensuring new releases meet business and regulatory expectations.

Environment: Azure Data Factory, Azure Databricks, ADLS Gen2, Azure SQL, Snowflake, Synapse, Informatica, dbt, Airflow, Python, PySpark, SQL, Postman, REST APIs, Azure DevOps, Git, Jenkins, Control-M, Power BI, Tableau, HL7, EDI 834/837.

• Performed system, integration, and regression testing across multiple state healthcare and human services applications.
• Executed backend data validation using complex SQL queries involving multi-table joins, views, and stored procedures.
• Supported ETL testing and data migration validation during system modernization initiatives.
• Conducted Section 508/WCAG accessibility testing using JAWS and web accessibility tools.
• Collaborated with cross-functional teams to improve test coverage, defect tracking, and delivery quality.

Environment: SQL Server, Informatica, HTML, CSS, JavaScript, JAWS, RTC, Visual Studio, Windows, WCAG 2.0.

• Validated ETL workflows and data transformations using Informatica PowerCenter for enterprise financial systems.
• Performed backend data validation using advanced SQL and PL/SQL to verify transformation logic and reconciliation rules.
• Supported data migration and reporting validation across SQL Server, Teradata, and Oracle environments.
• Partnered with stakeholders across SDLC phases to ensure data accuracy and reporting consistency.

Environment: Informatica PowerCenter, SQL Server, Teradata, Oracle, MicroStrategy, UNIX, HP ALM

• Experience in functional, integration, and UAT testing for healthcare enrollment and claims processing systems.
• Executed manual and automated testing for software applications.
• Validated HIPAA-compliant EDI 834 enrollment data and backend SQL databases.
• Executed SQL-based data validation to ensure data accuracy and integrity across systems.

Environment: SQL, Oracle, EDI 834, HIPAA, Quality Center, JIRA