Register  |  Log In  |  Contact Us

C1-Database Design/Analysis/Administration Enginee

Reference
1606660
Contract Type
Permanent
Sector
Education, Media & Communications
Location
Chennai, IND
Expiry Date
28/04/2018
C1-Database Design/Analysis/Administration Engineer Description Should be able to work in Product development environment Should be able to understand the EDW and Report data mart framework Experience in SSIS is must. (Knowl...

Job Description

C1-Database Design/Analysis/Administration Engineer

Description

  • Should be able to work in Product development environment
  • Should be able to understand the EDW and Report data mart framework
  • Experience in SSIS is must. (Knowledge in SSRS or SSAS is an added advantage)
  • Understanding Dimensional modeling like Star schema and Snowflake schema
  • Experience in design/develop/manage ETL framework with optimized performance
  • Having experience in SSIS transformations, Configurations, package Deployment and validation
  • Hands on experience in query performance tuning, error handling, and ETL performance optimization
  • Experience in writing Transact SQL, Stored procedures, Functions, Views and Joins
  • Knowledge in developing cubes, writing MDX queries, KPI and calculated measures
  • Experience in any of the project management tools is an added advantage
  • Basic knowledge in agile process methodologies is preferred

At Pearson, we’re committed to a world that’s always learning and to our talented team who makes it all possible. From bringing lectures vividly to life to turning textbooks into laptop lessons, we are always re-examining the way people learn best, whether it’s one child in our own backyard or an education community across the globe. We are bold thinkers and standout innovators who motivate each other to explore new frontiers in an environment that supports and inspires us to always be better. By pushing the boundaries of technology — and each other to surpass these boundaries — we create seeds of learning that become the catalyst for the world’s innovations, personal and global, large and small.

Qualifications

  • Should be able to work in Product development environment
  • Should be able to understand the EDW and Report data mart framework
  • Experience in SSIS is must. (Knowledge in SSRS or SSAS is an added advantage)
  • Understanding Dimensional modeling like Star schema and Snowflake schema
  • Experience in design/develop/manage ETL framework with optimized performance
  • Having experience in SSIS transformations, Configurations, package Deployment and validation
  • Hands on experience in query performance tuning, error handling, and ETL performance optimization
  • Experience in writing Transact SQL, Stored procedures, Functions, Views and Joins
  • Knowledge in developing cubes, writing MDX queries, KPI and calculated measures
  • Experience in any of the project management tools is an added advantage
  • Basic knowledge in agile process methodologies is preferred

Primary Location: IN-IN-Chennai

Work Locations: IN-Chennai-DLF IT Park Manapakkam 6th Floor- 10th Block- DLF IT Park 1/124 Shivaji Gardens- Moonlight Stop- Nandambakkam Post- ManappakkamMount Poonamallee Road Chennai 600089

Job: Technology

Organization: Professional English

Employee Status: Regular Employee

Job Type: Standard

Shift: Day Job

Job Posting: Feb 20, 2017

Job Unposting: Ongoing

Schedule: Full-time Regular

Req ID: 1606660

Pearson is an Equal Opportunity and Affirmative Action Employer and a member of E-Verify. All qualified applicants, including minorities, women, protected veterans, and individuals with disabilities are encouraged to apply.