Job Description :
Responsibilities

· Must have experience in end to end implementation of Datawarehouse and ETL on premise/cloud.

· Strong skills on Database Design, Modelling

· SQL/TSQL (performance tuning and troubleshooting) - Expert

· Experience in TFS CI/CD for SQL Automation and Automation via scripting tools such as PowerShell (in addition to T-SQL)

· Collaborates with software team in designing, planning and implementing relational and non-relational data driven features and functionality based on project requirements.

· Provide technical leadership for large-scale database migration projects.

· Performance tuning of DB Objects, ETL and SSRS Reports.

· Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

· Design and develop complex interactive dashboards with BI tools.

· Coordinate releases with Quality Assurance Team and implement TFS workflows and better source code integration.

· Develop and maintain a thorough understanding of business needs from both technical and business perspectives

· Effectively prioritize and execute tasks in a high-pressure environment

· Must have experience of Agile development methodologies

· Excellent oral and written communication skills.

Qualifications / Experience

· Bachelor’s/Master’s degree in Computer Science / Computer Engineering or equivalent experience

· 7+ years’ experience with SQL Server database systems, complex stored procedures designing and debugging.

· 6+ years Microsoft BI Stack (SSRS, SSIS, SSAS), including development of reports (RDLs, complex stored procedures, subscriptions, ETL packages using SSIS & T-SQL queries)

· Expertise in performance tuning DB objects

· Development experience with .NET C# is desirable.

· Data Modeling/Data Warehouse Design experience

· Strong understanding of SDLC and version control

· Excellent oral and written communication skills.

· Knowledge of Power BI, and Data analytics a plus.