Senior Consultant

Senior Consultant - (CREQ125923)

Description

Database/MSBI developer (SSIS/SSRS/SSAS) with SQL Server 2008R2/2012.
Expertise in writing the Joins, Views & Indexes Stored Procedures, Functions ,CTE and Temp Tables creation.
Having hands on experience on Data Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All, Merge Join and OLEDB Command to load data into SQL Server destination.
Experience in SSIS packages execution, Applying security and deploying packages to servers.
Experience in creating configurations files, log files, error handling, Check points etc for SSIS Packages.
Worked with SSRS to generate reports in different formats like Table, Matrix, Chart, Sub reports, Drilldown, Drill through and Image reports.
Knowledge on creation of ad-hoc reports and Linked reports etc.
Knowledge on Configuring Reporting server and maintaining Reporting services components.
Extensive experience in Creating Jobs for SQL Scripts, SSIS Packages, and Report manger level to scheduling the SSRS Reports & SSIS Package migration
Should have professional experience in IT industry, involved in MSBI projects with extensive usage of ETL(SSIS) & reporting tools SQL Server (SSRS, MDS) of Microsoft SQL Server 2008 R2, 2012 (Master Data Management )Master Data services 2012,2016.
Experience in SQL like creating (Tables, views, indexes, sub queries, joins, constraints, union operators, aggregate)
Creating Subscriptions in SSRS.
Familiar with complete Data warehousing development life cycle.
Extensive database programming Experience in writing T-SQL Stored procedures, User Defined Data Types, Constraints and Indexes using various DDL and DML commands.
Good knowledge of Relational Database Management Systems and Database applications
Experience on Sql and T-Sql Statements (SQL joins, Sub queries, Views and Indexes).
Extensive database programming Experience in writing T-SQL Stored procedures
Good knowledge of Relational Database Management Systems and Database applications
Scheduling (SSIS ) Jobs/Workflow/Workflow Management

Primary Location

: IN-KA-Bangalore

Schedule

: Full Time

Job Type

: Experienced

Travel

: No

Job Posting

: 24/03/2022, 9:56:56 AM