Responsibilities:
- 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)
Job Requirements:
- 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)