Sr. Sql Developer ( Ssis, Ssrs, Ssas)

Qualification 5+ years of experience in SQL Server development and administration with DBA duties.
Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations.
Experience in configuration and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager
Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart.
Expertise in OLAP and OLAP Cubes in SSAS.
Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
Well-versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
Experience in using BCP and Bulk Insert commands while working with Flat files
Knowledge in Linux command shell, Git, Python, Spark, Hadoop (HBase, Hive, Impala) is desired
Extensive knowledge of Relational Database Management Systems including MS SQL Server 7.0/ 2000/ 2005/2008 R2, Oracle 8i/ 9i/ 10g, DB2and Teradata.
Extensive experience with monitoring, tuning, analyzing DB performance and allocating server resources to achieve optimum DB performance by performing various query-optimization techniques.
Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
Flexible, enthusiastic and project oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs.