- 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
- Strong 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 good 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 environments.