MSSQL Developer

• Analysis and gathering requirements for Development projects covering all parts of SDLC
• Creating tables and their relationships (Schemas) in the data warehouse.
• Creating SSIS packages to migrate large amounts of data.
• Create Databases Tables Cluster/NonCluster Index Unique/Check Constraints Views Stored Procedures Triggers Functions and views Performance tuning of queries.
• Involve in using Master Data Management (MDM) tools for a Data Warehousing project (optional)

• Minimum 4 years direct experience in the Design and Development of Data Warehouse/Data Marts
• Extensive experience in using SQL server SSIS.
• Extensive experience of TSQL SSIS Package development and Report development on MS SQL
• Should have good Data Analytical skills
• Manage multiple priorities and ensure team deliveries in a dynamic environment
• Ability if required to design/develop/optimize stored procedures for reports
• Ability and desire to learn new report display technologies and evaluate additional BI tools that could advance the BI offerings
• Experience in Software Development Life Cycle(SDLC)

sql,software development life cycle(sdlc),performance tuning,ssis,stored procedures,sql server,t-sql,software development life cycle (sdlc),cluster,data warehouse,data warehousing,bi tools,master data management (mdm),data analytical,design,transact-sql (t-sql)