Data Quality Analyst

About ValueMomentum:

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.

• Title: QA Data Test Lead
• Location: Cincinnati, Ohio(Hybrid)

• 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.
• Need to be excellent team player.