Data Analyst - eCommerce/Gaming

Responsibilities:

- Ensure right stakeholders gets right information at right time

- Requirement gathering with stakeholders to understand their data requirement

- Creating and deploying reports

- Participate actively in datamarts design discussions

- Work on both RDBMS as well as Big Data for designing BI Solutions

- Write code (queries/procedures) in SQL / Hive / Drill that is both functional and elegant, following appropriate design patterns

- Design and plan BI solutions to automate regular reporting

- Debugging, monitoring and troubleshooting BI solutions

- Creating and deploying datamarts

- Writing relational and multidimensional database queries

- Integrate heterogeneous data sources into BI solutions

- Ensure Data Integrity of data flowing from heterogeneous data sources into BI solution

Requirements:

- Knowledge of SQL query writing and performance tuning

- Knowledge of Big Data technologies like Apache Hadoop, Apache Hive, Apache Drill

- Knowledge of fundamentals of Business Intelligence

- In-depth knowledge of RDBMS systems, Datawarehousing and Datamarts

- Sound knowledge of software development in Programming (preferably Java)

- Knowledge of the software development lifecycle (SDLC) and models