Innovations technological

Hello,

Trust you're well. This is Harsha from EZEN Computer Services Inc.

Pl find the below JD and let me know if you are  comfortable with the req. Kindly send me your Updated Resume along with the details as mentioned below.

Job Title: MS BI Lead (SSIS, SSRS, SSAS)

Location: Redmond – Washington

 Position Type: Contract

Duration:  Longterm

Client: Wipro

Job Description:

JC: 320440

Minimum work experience:8 - 10 Years

Skill and Experience Details:

-->Solution Architecture -->DW Data Architecture -->Branding and Thought Leadership -->BI Architecture -->BI Analysis and Solution design -->English Language -->SSIS -->SSRS -->SSAS -->SQL Server -->SQL Server T-SQL Programming

Essential Skill(s)

Skill1 - SSIS (L3)

·         Knowledge in Design, Capacity Planning and Architecting ETL solutions

·         Sound knowledge in Performance Tuning Packages Implementing Transactions based packages.

·         Sound knowledge in Best Practices of developing SSIS Project Using SSIS beyond ETL (DB Maintanance)

Additional Skill(s)

Skill1 - SSRS (L1)

•        Experienced in generating complex reports, writing SQLs and Configuring reports.

•        Good knowledge in genrating reports and incorporating charting capabilities.

•        Basic knowledge in Creating Custom components for Reports.

•        Good Understanding of Subscription, Caching and Snapshots.

•        Proficient knowledge in deployment and administration of reports.

Skill2 - SSAS (L1)

•        Good knowledge in MDM (Multi Dimensional Model)

•        Good knowledge in building cubes and dimensions etc.

•        Good knowledge in MDX and Data Mining eXtensions(DMX)

•        Strong knowledge in creation of various types of schemas like Star, Snowflake.

•        Strong Understanding of OLAP operations like Slice, Dice, Drilldown/up, Pivot and Rollup.

•        Able to write SQL Scripts. Good knowledge in Data Mining Concepts.

Skill3 - SQL Server (L1)

RDBMS - Exposure to Basic Relational Database Concepts - basic types of databases, data integrity, the relational model,etc

Ability to understand basics of DB Design , Logical modeling , Normalization & De-Normalization Techniques MS SQL - SQL Constructs

Ablility to understand and implement DataTypes, Basic SQL SELECT Statements, Restricting and Sorting Data, System Functions, Joins, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views SQL Query Tuning Basics: Understanding of concepts like Tuning Methodology, SQL Statement Processing, SHOWPLAN, Introduction to the Optimizer, Indexes and Basic Access Methods, Gathering Statistics, Optimizer Hints, Monitoring queries, Optimizing queries. Adv SQL: COMPUTE Clause, Advanced INSERT, Transact-SQL conditions and expressions, Dealing with collation sequences, Using scalar and aggregate functions, Multiple Table Queries Tools Level 1 usage T-SQL Programming – Database Programming Basics: Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Cursors, Error Handing, Creating Procedures and Creating Database Triggers Adv Database Programming: Ability to understand and implement programming with locks and isolation and working with temporary tables

Skill4 - SQL Server T-SQL Programming (L1)

Database Programming Basics: Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Creating Database Triggers and Transaction Management. Adv Database Programming: Ability to understand and implement Dynamic SQL Usage, Programming with locks and isolations and Working with Temporary Tables

Thanks & Regards

SriHarsha,

EZEN Computer Services, Inc| Ph: (609)-759-2657|Email: r9@e-zencomp.com|

www.e-zencomp.com|Gtalk-harshaharshu2001@gmail.com|

Partner to PTC Arbortext products |