Software Engineer

Job Title: Software Engineer - Testing

Job ID: POS-16255

Primary Skill: ETL Testing

Location: Hyderabad

Experience: 4.00

Key Skills: ETL Testing, Automation, Python & SQL

Job Location: Hyderabad/Pune/Coimbatore

Mode of Work: Work From Office

Experience: 4 to 7 Years

About the job:

As a Data Test Engineer, you will be responsible for validating data sources, building complex SQL queries, extracting data, ingesting, application of transformation logic, running / analysing batch job runs and uploading data in target tables. You will be responsible for designing, Data Mapping, testing, and troubleshooting the client's data storage system before it goes live. You must have strong technical capabilities and good knowledge of the coding languages commonly used in ETL development, such as Python, SQL, XML, Informatica, and data warehousing concepts. You should have knowledge on Troubleshooting, Log analysis, Perform RCA for bugs and errors and finding solutions for ETL Development.

Know your team:

At ValueMomentum Technology Solution Centers, we are a team of passionate software engineering teams who thrive on tackling complex business challenges with innovative solutions catering to the P&C insurance value chain. We achieve this through a strong software engineering foundation and by continuously refining our processes, methodologies, tools, agile delivery teams, and core engineering archetypes. Our core expertise lies in six key areas: Platforms, Infra/Cloud, Application, Data, Core, and Quality Assurance.

Join our team that invests in your growth. Our Infinity Program empowers you to build your career with role-specific skill development, leveraging immersive learning platforms. You'll have the opportunity to work with some of the best minds serving insurance customers in the US, UK and Canadian markets.

Responsibilities:

• Develop and implement data testing strategies and methodologies to ensure the accuracy, completeness, and integrity of data in P&C insurance software solutions.
• Conduct thorough data validation to identify and resolve data quality issues.
• Design comprehensive test plans, test cases, and test scenarios for data validation, ensuring coverage of data completeness, correctness, and consistency.
• Execute data testing activities, including both manual and automated tests, according to defined test plans and cases.
• Develop, maintain, and enhance automated test scripts and frameworks for data validation using SQL, Python, or similar scripting languages.
• Implement automated data validation checks to streamline the testing process and ensure timely detection of data issues.
• Test ETL processes to validate data extraction, transformation, and loading procedures.
• Ensure that data flows correctly through various stages of the ETL pipeline and meets predefined quality standards.
• Collaborate with development and data engineering teams to prioritize and resolve data-related defects promptly.
• Perform regression testing to ensure that data-related changes and enhancements do not introduce new data quality issues.
• Ensure adherence to established quality standards, processes, and best practices throughout the testing process.

Requirements:

• Bachelor's degree in computer science, Information Technology, or related field.
• Minimum 3-4 years of experience in software quality assurance, with a focus on data testing and validation.
• Good understanding of Property and Casualty (P&C) insurance concepts, data models, and workflows. Knowledge of insurance-related data structures and regulatory requirements is advantageous.
• Strong skills in writing and executing complex SQL queries for data validation and analysis.
• Solid understanding of data testing principles, methodologies, and best practices. Experience with both manual and automated data testing.
• Proficiency in developing and maintaining automated test scripts and frameworks for data validation using tools such as Python, SQL, or similar scripting languages.
• Familiarity with ETL processes and tools for testing data extraction, transformation, and loading workflows.
• Experience with data quality assurance tools and frameworks, such as Informatica Data Quality, Talend, or similar.
• Familiarity with defect tracking and test management tools such as Jira, HP ALM, or similar.
• Good understanding of regression testing techniques and practices.
• Proactive approach to taking ownership of tasks and driving them to completion.
• Proficiency in Agile methodologies and experience working in Agile environments.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
• Strong analytical and critical thinking skills, with keen diligence.
• Experience working in Agile environment following Onsite Offshore mode.

About the Company:

ValueMomentum is a leading solutions provider for the global property and casualty insurance industry. The company helps insurers stay ahead with sustained growth and high performance, enhancing stakeholder value and fostering resilient societies. Having served over 100 insurers, ValueMomentum is one of the largest services providers exclusively focused on the insurance industry.

Benefits:

We at ValueMomentum offer you a congenial environment to work and grow in the company of experienced professionals. Some benefits that are available to you are:

• Competitive compensation package.
• Career Advancement: Individual Career Development, coaching and mentoring programs for professional and leadership skill development.
• Comprehensive training and certification programs.
• Performance Management: Goal Setting, continuous feedback and year-end appraisal. Reward & recognition for the extraordinary performers.