Quality Assurance Analyst

Education:

B.E. Computer Science/IT degree (or any other engineering discipline)

Experience:

4+ years
Position Requirement:
Proficient in SQL ( analytical functions, trending, windowing)- Traditional (for e.g. MSSQL, Oracle, Postgre

SQL) or Columnar (like Vertica, Amazon, Redshift)

Experience with data QA and ETL / ELT (data pipelines) QA
1–2 years of experience in automation for ETL, BI, data modeling, and data-level validation using Python or PySpark framework.
Preferred: hands-on experience implementing AI integration in automation solutions.
Experience working closely with teams outside of IT (i.e. Business Intelligence, Marketing Adops, Sales)
Strong understanding of the Web Analytics, metrics, KPIs, and reporting

Experience with automating regression tests, reporting platforms (for e.g. Tableau or Pentaho BI) and ETL tools (for e.g. Pentaho or Talend) will be an added advantage
Understanding of Ad stack, Email data and data (Ad servers, DSM, DMP etc) is good to have
Role & Responsibilities:
Performing statistical tests on large datasets to determine data quality and integrity
Evaluating system performance and design, as well as its effect on data quality
Collaborating with database developers to improve data collection and storage processes
Running data queries to identify coding issues and data expectations, as well as cleaning data
Creating and Maintaining automation framework for data comparison between different datasets/ data quality checks
Understanding AI integration with the Automation framework
Gathering data from primary or secondary data sources to identify and interpret trends
Reporting data analysis findings to management to inform business decisions and prioritize information system needs
Documenting processes and maintaining data records
Adhering to best practices in data analysis and collection
Keeping abreast of developments and trends in data quality analysis