Job description:
• Minimum 5-7 years of hands-on work experience in BI and Data warehouse projects.
• At least 4 years of working with Microsoft database platforms MSSQL Server 2012/14/16.
• Very Good knowledge of T-SQL for writing performant and optimized SQL query.
• Hands on experience on SQL Server Integration Services(SSIS) - Datawarehouse ETL
implementation.
• Knowledge of SSIS ETL best practices , Error Handling ,Logging , Re- Tries , Notifications , Task
Scheduling.
• Strong knowledge of various data warehousing methodologies and data modeling concepts.
• Experience of ETL load design patterns, Incremental load, Full load , Merge etc.
• Development experience using C# .NET or .
• Experience in Analysis and Reporting solutions using dashboard visualization tools like: Tableau or
Power BI etc. is Advantage.
• Hands-on experience of SDLC processes for BI projects.
• Experiences of writing documentation – functional requirements , design documents, Test Cases,
operation manual etc.
• Self-motivated , excellent troubleshooting and communication skills , team player.