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.
Submit CV To All Data Science Job Consultants Across India For Free

