Description

You ensure data integrity and optimize complex database operations through advanced querying and automated testing.

This role is on-site.

Responsibilities

• Execute advanced SQL queries using window functions, CTEs, and hierarchical queries to validate data accuracy.
• Perform functional testing and implement Behavior Driven Development (BDD) patterns.
• Optimize query performance through indexing, query tuning, and materialized views.
• Manage data validation processes within CI/CD pipelines.
• Utilize full-text search and ranking functions to validate search capabilities.

Required Skills

• 6+ years of experience in Python or Java coding.
• Expert-level SQL skills, including window functions (RANK, LEAD, LAG), recursive CTEs, and correlated subqueries.
• Hands-on experience with functional testing.
• Proficiency with Selenium and Cucumber for BDD.
• Working knowledge of CI/CD workflows.
• Experience with analytical functions such as CUME_DIST, PERCENT_RANK, and NTILE.
• Ability to perform hierarchical queries using CONNECT BY PRIOR and START WITH.
• Knowledge of query optimization techniques and execution plan analysis.

Key Skills

Education

Any Gradute