Ssis Msbi Sql - Architect
- Best infosystems
- 10 to 20 Yrs
- Bengaluru
- 3 years ago
- Email to a friend
- Report this job
Job Description
Skills Required: At least 10+ years of experience in Datawarehousing and Bigdata SQL (Mandatory) ADF (Mandatory) Power
BI (Mandatory) ADLS (Mandatory) Azure SQL Datawarahouse , Azure SQL Database (Mandatory) SSAS Tabular Model + DAX
(Mandatory) Powershell Powerapps Azure Databricks Azure data Explorer (Kusto) C# (Good to have) Strong
communications skills - Excellent spoken and written English communication skills Effective, polished interaction with customer to
gather information Demonstrate troubleshooting skills Responsibilities: Good knowledge of SQL, Big Data concepts and
datawarehousing on Azure ecosystem Should have excellent understanding of Azure stack services Strong knowledge on IAAS,
PAAS and SSAS in Azure Should be able to develop complex design and high performance ADF pipelines Should be very clear
on Extract Transform Load(ETL) concepts and hold expertise in extraction methods and routing/filtering/lookup/transformation
principles Hands-on knowledge in CI/CD using VSTS to deploy Azure datafactory Should have excellent understanding and
writing queries, stored procedures in SQL Server Participate with End-users and do requirement gathering and convert into
technical documentation Should be clear on designing constructs for different data sets and come up with reusable templates for
the same Identify the performance bottle-necks and resolve the same Responsible for designing the entire solution and
modularizing the same for the module leads Responsible for ensuring the tool stack is used efficiently for the optimum
performance Responsible for designing complex models in analysis services Proficient knowledge on DAX Responsible for the
overall technical review and the testing strategy Able to identify technical risks and structuring and prioritizing the deliverables
Responsible for devising the Code and DB Backup Strategies Troubleshoot technical issues on ETL ,OLAP and Reporting
Solutions Passion for solving complex problems at scale, sound knowledge of fundamentals in Data Structures, Performance
tuning concepts Able to prepare and maintain knowledge repository Gap Analysis on the existing production environment Able
to prepare the list of issues and track them to closure Should be able to lead a project and mentor team members Facilitating,
guiding and influencing the clients and teams towards right information technology architecture and becoming interface between
Business, Tech leadership and Delivery teams Supporting business development and ensuring high levels of client satisfaction
during delivery Specify solutions and articulate value to customers Provide best practice advice to customers and team members
Collaborate with customers and address customer needs. Experience on working with customers in soothing manner and willing
to work in shifts.
Job Requirements: SQL, Azure Data Factory, PowerBI, Azure Data Lake Storage, SSAS, Data Warehouse Design, Data Modeling,
Data Visualization, Datawarehouse Architecture, ETL Design
Location:
Bangalore
Skills Required:
SQL
Employement Category:
Employement Type: Full timeIndustry: IT - Software
Role Category: DBA / Datawarehousing
Functional Area: Not Applicable
Role/Responsibilies: Ssis Msbi Sql - Architect
Contact Details:
Company: Best InfosystemsLocation(s): Bengaluru
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in
