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

    0

    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 📝💼

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here