Data QA SQL Developer - Data Test Analyst

PORNIMA MAHAKAL

Data Test Analyst Data QA SQL Developer

***************@*****.*** 706-***-**** Bengaluru, Karnataka, India linkedin.com/in/pornima-mahakal-04b478156 CAREER OBJECTIVE

EDUCATIONAL QUALIFICATION

• B.E., Electronics and Telecommunication - Rajendra Mane College of Engineering and Technology, Mumbai University, 2019. SUMMARY

• Expertise in SQL development, query optimization, and database schema design across Snowflake, Databricks, SQL Server, and Rockset.

• Hands-on experience validating telemetry and gameplay data across multiple titles in a global gaming portfolio, ensuring accuracy for downstream business use.

• Skilled in test case management, defect tracking, and documentation using JIRA and TestRail.

• Strong understanding of ETL pipelines and Azure Data Factory (ADF), with experience in Python and PySpark for scripting and automation.

• Experienced in cross-functional collaboration across data, QA, and business teams to align on data quality priorities and reporting needs.

• Comfortable working with large-scale, high-volume data and identifying inconsistencies or gaps through structured root cause analysis.

• High degree of proactivity and curiosity in understanding how product/business decisions connect to underlying data.

• Proven ability to independently manage priorities and deliver consistently within Agile sprint cycles.

• Effective communicator, able to make technical data findings understandable and actionable for non-technical stakeholders. TECHNICAL SKILLS

Databases & Data Warehouses: SQL, SQL Server, Snowflake, Databricks, Rockset Programming Languages: Python, SQL, PySpark, HTML, CSS, Unix/Linux Shell Commands Data Engineering & ETL: ETL Pipeline, Azure Data Factory (ADF), Data Validation, Data Quality Assurance, Database Schema Design Tools & Platforms: SSMS, pgAdmin, Toad, Postman, JIRA, TestRail, Confluence, GitHub, Bitbucket, Microsoft Office, Jupiter Notebooks, VS Code

Analytics & Visualization: Power BI, Mixpanel, Amplitude CERTIFICATIONS

• SQL for Data Science

• Complete Python Bootcamp: Zero to Hero

• The Web Developer Bootcamp

• Certified Java Professional Course

• Certified Capgemini Software Developer Course

PROJECT DETAILS

PROJECT (March 2023 – Present)

Organization Name: Sun Technologies Integrators Pvt Ltd Client: 2K

Designation: Data QA

Tools Used: SQL, Snowflake, Databricks, Rockset, JIRA, TestRail

• Developed and maintained automated data quality checks using SQL and Python to validate high-volume telemetry, gameplay, and player-event data. Data QA with 4.8+ years of experience in SQL development, data validation, and quality assurance across large scale data platforms including Snowflake, Databricks, and SQL Server. Skilled in writing and optimizing complex SQL queries, validating telemetry and gameplay data, and ensuring data accuracy, consistency, and integrity across pipelines. Strong believer in cross-functional collaboration, with experience bridging data, QA, and business teams to flag data quality issues early and support reliable, actionable reporting. Bringing a proactive, detail-oriented approach to Agile/Scrum environments, with a growing interest in expanding into data analysis and insights delivery.

Databases & Data Warehouses: SQL, SQL Server, Snowflake, Databricks, Rockset, Database Schema Design Programming Languages: Python, SQL, PySpark, Pandas, HTML, CSS, Web Scraping, Unix/Linux Shell Commands Data Engineering & ETL: ETL Pipeline, Azure Data Factory (ADF), Data Validation, Data Quality Assurance, API Testing, AWS Cloud Tools & Platforms: SSMS, pgAdmin, Toad, Postman, JIRA, TestRail, Confluence, GitHub, Bitbucket, Microsoft Office, Jupyter Notebooks, VS Code, Excel

Analytics & Visualization: Power BI, Mixpanel, Amplitude

• Monitored data pipelines for anomalies, schema changes, missing or inconsistent records, and integrity issues across Snowflake, Databricks, and Rockset.

• Defined and documented validation rules and data quality expectations to ensure accuracy, consistency, and reliability of downstream datasets.

• Collaborated with engineering and QA teams to validate in-game event instrumentation and ensure telemetry data was captured accurately and consistently.

• Investigated complex data discrepancies using SQL, Python, and Spark SQL, performing root-cause analysis and coordinating fixes to prevent recurrence.

• Supported data quality monitoring through dashboards, reporting, and alerts to surface anomalies and quality issues for relevant stakeholders.

• Partnered with analytics and product stakeholders to validate datasets and ensure data was complete, reliable, and fit for business and gameplay analysis.

• Documented data definitions, quality expectations, and data flow/lineage details to improve traceability and support consistent data usage. Organization Name: SRS Business Solutions India Pvt Ltd Designation: Software Engineer (SQL Developer)

Tools Used: SQL, SSMS

Description:

• Optimized existing SQL queries for improved performance using query tuning techniques.

• Wrote triggers, functions, and complex SQL queries to support application and reporting needs.

• Created and maintained database tables, views, and constraints.

• Interpreted complex data and presented findings in a clear, actionable manner for stakeholders.

• Managed multiple tasks and deadlines while coordinating with cross-functional teams. English (Fluent), Hindi (Fluent), Marathi (Native) PROJECT (September 2021 – December 2022)

LANGUAGES

Contact this candidate