Analyst - Data Quality/Engineer - IT

The QA Engineer will work closely with data scientists, data engineers and other business units to turn data into critical information and knowledge that can be used to make sound business decisions. QA Engineer is also responsible for the implementation of Data Analysis/Data Validation strategies to support development of Data Warehousing & Data Analysis solutions.

The ideal candidate for this role should be able to handle end-to-end Data Integration, DW solutions and Data validations/verifications by taking into consideration the business use cases, objectives and requirements.

- Design, develop and validate various Data Warehousing & Data Analysis solutions.

- Work with business users to establish requirements to achieve business objectives through Data.

- Decompose the business requirements into one or more reusable DW/ETL products.

- Translate business requirements into Data/ETL Solutions

- Performs tasks and duties related to ad hoc analysis, design and processing.

- Ensure effective communication of user requirements.

- Debugging, monitoring and troubleshooting existing Data Warehouse solutions and applications.

- Excellent working knowledge of large data manipulation and data mining using complex SQL.

- Implement data validation/verification strategies, plans and use cases for various Data Warehousing & Data Analysis solutions.

- Experience in writing complex SQL statements to validate data and ETL code based on the data mapping & requirements and perform extensive data analysis to identify the defects.

- Perform detailed Data Analysis, Data Profiling and Data Integrity check using SQL, Shell scripts or any other tools.

- Passion towards giving innovative technical solutions using different tools/techniques

Required:

- Hands on work experience testing Data Pipelines

- Hands on experience with Data Visualization methods

- Hands on experience in Data Warehousing constructs, large column tables, aggregate tables, fact and dimension tables etc.,

- ETL

- SQL

- Data Integrity

- Data Profiling

- Data Analysis

- Data/ETL Solutions

- Shell scripts

Good to have:

- Expertise in data analytics and solutions related to end user behavior, user journey metrics, mobile app metrics