Job Description :
Participate in all phases of the software development life cycle (SDLC), including requirements, technical design, development, testing and implementation
Design and develop or modify ETL solutions using MS BI tools
Develop, enhance and troubleshoot database objects such as stored procedures, functions, tables and views
Design and develop SSAS cubes and data marts
Apply generally accepted programming standards and techniques to assure efficient program logic and data manipulation
Create and maintain data dictionaries, data model and change management documentation
Conduct data profiling to understand data relationship and the quality of data
Investigate and resolve data issues as needed
Participate in unit testing and troubleshooting"
6 years or more experience in data warehouse design and development using Microsoft SQL Server (2012+) BI stack: SQL server, T-SQL, SSIS, SSAS, DAX
Must have 3-5 years of experience developing ETL solution using SSIS
Minimum 2 years of experience