? Work on multiple concurrent development projects utilizing Microsoft SQL Server.
? Participate in requirements gathering, database design, ETL design, testing and production deployments.
? Analyse data, system, application requirements and design innovative solutions.
? Design and develop SQL Server database objects (i.e., tables, views, stored procedures, indexes, triggers, constraints, etc.)
? Performance tuning and query optimizations in terms of all the database objects.
? Perform unit and integration testing.
? Create technical documentation.
? Develop and assist team members.
? Provides training to the team members.
ESSENTIAL SKILLS & COMPETENCIES:-
? Comprehensive Microsoft SQL Server experience working with SQL Server 2005 through 2012.
? Experience in data warehouse, dimensional modelling and database design.
? In-depth ETL development experience working with Microsoft SQL Integration Services (SSIS), using all areas of the environment, including scripting.
? Development experience working with OLAP and Microsoft SQL Server Analysis Services (SSAS).
? Solid understanding of database concepts, architecture and design principles.
? Exposure to Oracle, MySQL, Teradata and ETL tools like Talend, Informatica, etc...
? Exposure to Big data technologies and NoSQL.
? Exposure to Business Intelligence tools like Microstrategy, Tableau, Spotfire, Qlilview, etc…
? Strong analytical, technical and problem solving skills.
? Good verbal and written communication.
6 - 10 years of relevant experience.