RS Consultants | Jobs | BI Developer/Solution Architect – SSAS/SSRS/OLAP | BigDataKB.com | 07-02-22

โ€”

by

Job Location: Hyderabad/Secunderabad

Position : BI Developer-Solutions Architect

Location : Hyderabad

Organization : A global consulting company, Headquartered in Hyderabad and offices in Pune, Chennai, Noida with large presence in North America and South East Asia

Roles & Responsibilities :

– Implementing Datawarehousing (DW) and Business Intelligence (BI) Solutions.

– Working in various capacities, Testing, Development, Requirement gathering and User Acceptance Testing (UAT)support.

– Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.

– Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems

– Working on the entire BI Stack on SSIS, SSRS, SSAS (MDX, DAX, Tabular Cubes(BISM)), including Power View, Power Pivot and Power BI.

– Experience working on Cloud environment (Azure).

– Expertise on SQL Server 2000- 2012, writing T-SQL Code, Stored Procedures, Views and JOBs

– Strong understanding of both Inmon and Kimball Architecture.

– Experience in Data and Dimensional modeling using star or snowflake schemas.

– Performance tuning of SQL Server/SSAS/SSIS.

– Requirement Gathering, Data analysis and Gap analysis of Vendor Reporting Services

– Maintenance of existing Cubes, Reports and handling change requests.

– Administration of DEV and UAT SQL Servers, including backup and restore of databases.

– Experience in migrating/upgrade SQL Server and SSIS Packages from 2008 to 2012.

– Experience in working in an Agile environment. Involved in bug triage meeting, status reporting and Scrum calls.

– Experience in Data Warehouse design strategies including aggregation and other derived structures such as star schemas and snowflake schema.

– Supported team in resolving SQL Reporting services and T-SQL related issues.

– Strong understanding of RDBMS concepts and Data Modeling Concepts.

– Gather Day to Day files from FTP, Secure FTP servers, decrypt them and deliver to the respective teams that require the file.

– Loading Incremental Data through Change Data Capture.

– Hands-On experience scheduling and maintain in Jobs through sqlserver agent by rerouting the user through proxy credentials.

Essential Requirements :

– Minimum 8 Years of experience in the similar field

– Hands-on experience in the entire BI Stack on SSIS, SSRS, SSAS

– Expert level skills in Objects creation such as Tables and Views, Table Normalization

– Strong experience in Data Warehouse design strategies

– Strong understanding of RDBMS concepts and Data Modeling

– Strong experience in BI Dashboards and Content Packs

– Define ETL Framework for data load

– Migrate Data from existing systems using SSIS

– Strong experience in SQL Server 2000- 2012

– Framework – C#.Net and ASP.Net

– Bachelor’s Degree in engineering/ BCA / BSC / MCA /MSC

Looking for a Hyderabad based candidate who can join immediately/within 1 month. 2-3 Months of Notice Period would not be considered.

Apply Here

Submit CV To All Data Science Job Consultants Across India For Free

๐Ÿ” Explore All Related ITSM Jobs Below! ๐Ÿš€ โœ… Select your preferred “Job Category” in the Job Category Filter ๐ŸŽฏ ๐Ÿ”Ž Hit “Search” to find matching jobs ๐Ÿ”ฅ โž• Click the “+” icon that appears just before the company name to see the Job Detail & Apply Link ๐Ÿ“๐Ÿ’ผ

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *