Company

A leading IT Giant with Offices worldwide

Role

Data Modelling / Data Analysis and Data warehousing (SQL Server, DB2, ETL, MS DTS, SSIS)

Skills Sets

SQL Server 2005,2008, DB2, ETL, MS DTS, SSIS (with 5+ Yrs experience in SQL and DB2,ETL)

Experience

5  to 10 Years

 

Job Description

The right candidate will have a strong SQL Server 2005 /2008 background with specific SSIS knowledge and strong Data Modeling/Data Analysis experience.

 

Candidate will participate in code development as well as direct interaction with business users.

 

Skills Required:

SQL 2005/2008, Data Architecture, Database Development, Data warehousing, ETL, OLAP, DTS, SSIS, Business Analysis, Data Modeling, Data Analysis and Business Intelligence.

 

5 + years knowledge of Data Warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools

 

5 + years SQL Server Integration Services (SSIS)

 

Strong data modeling experience and key understanding of relational database development.

 

Significant experience in extracting data from multiple sources including a data warehouse environment.

 

Responsibilities:

Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements

Collaborate on the global data architecture design and planning for the physical structure and implementation of data warehouses and data marts.

Design, document and build physical database environments from table, column, index and view definitions to storage requirements and drive spacing and growth accommodations.

Work with developers and data analysts to identify, design and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis.

Develop scripts for the creation of the physical data warehouse database schema(s), data security and protection, managing performance, performing backups/ restores, and archiving data.

Manage, Monitor and Administer database and system performance. Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability.

Strong ad-hoc SQL query development skills, working knowledge of relational databases and MS Word, PowerPoint, Access, Visio

Superior data mining, extraction, transformation, modeling, validation testing, and presentation skills are mandatory

 

GOOD TO HAVE

Experience with Oracle Business Intelligence Enterprise Edition (OBIEE) a plus +

 

 

Job Location

Mumbai

Others

Send your updated CV along with CTC, ECTC, NP

APPLY 4 JOB

Jobs.equinoxes@gmail.com

VISIT US

http://www.equinoxes.in

Advertisements