Roles and Responsibilities
Advanced SQL skills - Adept at queries, report writing and presenting findings
Expertise in Data Analysis, Data Profiling, and SQL Tuning
Expertise in translating business requirements to project design, development, and execution
Solid analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy
Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences
Experience working in Data warehouse ETL & BI platforms and have a positive understanding of related development activities and challenges
Strong knowledge of and experience with reporting, databases (SQL etc.), programming (ETL frameworks)
Experience in understanding the source data from various platforms and mapping them into Entity relationship model (ER) for data integration and reporting.
Has deep understanding of data architecture & data modelling best practices and guidelines for different data and analytic platforms.
May assist in development of software technical documentation.
Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts.
Experience Criteria
8+ years of experience in IT Industry
Strong experience in managing the large multi-tier web-based Software
Must have good knowledge of database processes and able to manage different kinds of databases such as Postgre, SQL Server, Redis etc.
Able to understand and implement the data cubes, mining and help team in establishing Analytics and BI system.
Must have hands on expertise in database performance tuning, and Parallel processing.
Proficient in installation, configuration and migration of Database Servers in clustered and non-clustered settings.