Data Quality Analyst

ValueMomentum; Cincinnati (OH); On-site; USD 120,000 - 150,000; Full time

Job summary

ValueMomentum is seeking an experienced ETL Test Engineer for data validation across large-scale pipelines in the P&C insurance space. You will design and execute test plans, validate migrations, and ensure data quality from source to target with SQL, Spark, Hive, and Snowflake.

The role involves collaborating with data engineers, architects, and analysts, documenting results, and automating tests where possible to improve efficiency and accuracy.

Qualifications

• 6 years of total technical experience on ETL testing.
• Experience with Guidewire Claims Center.
• Must have experience working in P&C insurance domain.
• Experience in developing ETL test plans, test cases and validating large scale data migrations.
• Strong understanding of ETL processes, SQL, Spark, Hive and data migration.
• Advanced proficiency in writing SQL queries, hands-on experience with Hive, Spark, Spark SQL and data frame API.
• Experience with Snowflake data warehousing.
• Experience in testing using Informatica, IDMC, CDV, CDQ.
• Experience with data quality automation tools and frameworks.
• Ability to document and present findings clearly and concisely.
• Excellent verbal and written communication skills.
• Strong analytical and problem-solving skills.

Responsibilities

• Work on large datasets and be involved in ETL testing and validation between source and target.
• Develop and execute test plans, test cases, and scripts to validate data accuracy and integrity.
• Perform functional, integration, regression, and performance testing of data pipelines and databases.
• Identify and troubleshoot data quality issues and anomalies.
• Collaborate with data engineers, architects, and analysts to meet data requirements.
• Document test plans, results, and issues; communicate findings clearly to stakeholders.

Skills

ETL testing

SQL

Spark

Hive

Tools

Guidewire Claims Center

Snowflake

Informatica

IDMC

CDV

CDQ

Job description

ValueMomentum is a leading solutions provider for the global property and casualty insurance industry, supported by deep domain and technology capabilities. We help insurers stay ahead with sustained growth and high performance for enhancing stakeholder value and fostering resilient societies. Trusted by over 100 insurers, ValueMomentum is one of the largest services providers exclusively focused on property and casualty. ValueMomentum is headquartered in Piscataway, NJ, with state-of-the-art delivery centers in Piscataway, NJ; Hyderabad, Pune, and Coimbatore in India; Toronto in Canada; and London in the United Kingdom.

ValueMomentum is an Equal Opportunity Employer committed to fostering a diverse and inclusive workplace. We make all employment decisions based on qualifications, merit, and business needs, without regard to race, color, religion, sex, gender identity or expression, sexual orientation, national origin, age, disability, protected veteran status, genetic information, or any other characteristic protected by applicable federal, state, or local law.

We are also committed to providing reasonable accommodation for qualified individuals with disabilities and applicants throughout the recruitment process, in accordance with applicable laws.

• The Candidate is expected to work on large datasets and will be involved in ETL testing, and thorough validation between the source and target
• Develop and execute test plans, test cases, and scripts to validate data accuracy, completeness, and integrity.
• Perform functional, integration, regression, and performance testing of data pipelines, ETL processes, and databases.
• Identify and investigate data anomalies, inconsistencies, and discrepancies; troubleshoot and resolve data quality issues.
• Collaborate with data engineers, data architects, business analysts, and other stakeholders to understand data requirements and ensure data quality standards are met.
• Document test plans, test results, and data quality issues; communicate findings and recommendations effectively to technical and non-technical stakeholders
• Recommend and implement improvements to data quality processes, tools, and methodologies.
• Automate data validation and testing processes where possible to improve efficiency and accuracy.

Requirements - Must Have Skills:

• 6 years of total technical experience on ETL testing
• Experience with Guidewire Claims Center
• Must have experience working in P&C insurance domain
• Experience in developing ETL test plans, test cases and validating large scale data migrations.
• Strong understanding of ETL processes, SQL, Spark, Hive and data migration
• Advanced proficiency in writing SQL queries, hands-on experience with Hive, Spark, Spark SQL and data frame API.
• Experience with Snowflake data warehousing.
• Experience in testing using Informatica, IDMC, CDV, CDQ
• Experience with data quality automation tools and frameworks.
• Ability to document and present findings clearly and concisely.
• Excellent verbal and written communication skills.
• Strong analytical and problem-solving skills.