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.