Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

For Employers

Add office photos

Employer? Claim Account for FREE

Datavail Infotech

Compare

3.2

based on 132 Reviews

7 Datavail Infotech Senior Technical Specialist Jobs

Senior Technical Specialist

Datavail Infotech Pvt. Ltd.

3.2

based on 132 Reviews

9-18 years

Bangalore / Bengaluru

1 vacancy

Senior Technical Specialist

Datavail Infotech

posted 4d ago

Job Role Insights

Flexible timing

Key skills for the job

Virtual Assistant Python Cloud Computing SAP Business Intelligence Microsoft Power BI SSRS

+ 3 more

Job Description

Job Title: Senior Technical Specialist
Education: B.E\B.Tech\MCA\B.SC\Any Degree
Experience: 8+ years
Location: Mumbai/Hyderabad/Bangalore

Key Skills: SQL Server, MSBI, SSIS, SQL, TSQL

Required Skills:

8+ years of Business Intelligence experience
Experience of database design or integration experience with SQL Server databases
Expertise with MS SQL Server and the Microsoft BI Stack (SSIS). SSAS & SSRS is an adavantage
Experience delivering reporting, database, data integration solutions.
Developing projects from a detailed business requirement, working through solutions, and managing execution and rollout of these solutions, in the context of an overall consistent global platform
Understand business requirements and take the complete ownership till the product delivery.
Create T SQL queries/stored Procedures/Functions/Triggers using SQL Server 2016 or above version.
Understand basic data warehousing & relational model concepts.
Design/Develop SSIS packages to pull data from various source systems and load to target tables.
Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data.
Analyse and develop strategies and approach to import and transfer data between source, staging, and ODS/Data Warehouse destinations.
Analyse existing SQL queries for performance improvements.
Strong experience in implementing the Data Integrations using SSISis a MUST.
Strong knowledge and proven history of SQL / TSQL performance tuning.
Should be able to develop and debug complex SQL and TSQL queries.
Suggest new queries as an outcome of fine-tuned techniques.
Critical thinker and problem-solving skills.
Experience working on an Agile/Scrum team preferred.
Develop the Complex SSIS object as per the customer need.
Should have strong knowledge on Datawarehouse skill.
Works closely with the Data Architecture team and provides technical design recommendations on the data mart structures which support analytical applications.
Provides and owns the technical details for implementation and maturing of BI solutions.
Designs functional specs for BI front end applications including dash boards and reporting, considering appropriate data flow and capture.
Works with business users and other stakeholders to understand business processes and translates them into functional and non-functional specifications for BI solutions.
Identifies problem trends and corrective actions and documenting these through modification of existing best practices guidelines.
Provides expertise and guidance to other developers in the use of the toolset.
Proficient in SQL coding.
Triage the Production issues and work on the code fixes.
Must have good verbal and written communication skills.
Must be client-facing.
Must be independent and a self-starter.
Knowledge on Python / PySPark is an added advantage.
Knowledge on cloud computing (Azure) is an advantage.