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 Required Skills ETL tools: SSIS Database: SQL Server (2005/2008/2012/2016), Oracle, MySQL Knowledge of SAP BO, Cognos Report Builder is added plus. Required Experience 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
MS SQL 2012 Server Administrator, with experience of data migration projects using SSRS, SSIS packages. Needs to have a very strong and credible record as a DBA, experience of handling enterprise Data Base migration projects preferably in a financial or banking arena. Provide hands on support to our internal DBA and development teams. Strong knowledge of database design, query cost and performance measurement, use of stored procedures and performance tuning. Experience in using Integration Services (SSIS) platform for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations. Will provide database functions by designing and coding utilities and scripts Maintains database performance by calculating optimum values for database parameters; implementing new releases and completing maintenance requirements. Provides information by answering questions and making recommendations. Maintains quality service by establishing and enforcing organization standards.