You will be responsible for working as a Business Intelligence developer with a team of other BI developers providing technical Solutions and implement the BI and Analytics strategy and direction to a large-scale e-commerce business. You will be required to be hands-on, bring innovative approaches that continuously improve our ability to deliver faster, better and cheaper solutions while reducing the time and cost to build BI and analytics solutions and on-board with highest quality. You’ll be responsible for designing, developing high quality code solutions with an emphasis on quality, simplicity and maintainability in SQL Server suite of business intelligence and adopt the same in the e-commerce BI solutions.
Required Experience, Skills and Qualifications
BE/B.Tech/MCA in Computer Science or related field
6+ years of experience and proven track record in end-to-end DW Design, Development and implementation of at least one or more DW project/projects.
Excellent ability to translate business requirements into logical, conceptual and physical data models
Experience in data warehouse life cycle management
Professional, practical programming using SSIS
Should be able to quickly adapt to business processes and understand the domain.
Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Interpersonal Skills.
Possesses a professional demeanor
Willing to work hands on as per project / initiative requirements
Drive to take up new incentives and deliver them Strong SQL skills
ETL tools: SSIS
Database: SQL Server (2005/2008/2012/2016), Oracle, MySQL
Knowledge of SAP BO, Cognos Report Builder is added plus.
Exposure to dimensional data modelling
Hands-on experience experience on DB and ETL Performance Tuning and troubleshooting
Strong exposure to database performance tuning
Experience in Data Quality Profiling Tools is a plus