Data Warehouse Developer

People First Consultants
  • Chennai
  • 10-15 lakh
  • 8-13 years
  • Views
  • 15 Mar 2017

  • IT/ Information Technology

  • Banking - Retail
Job Description

Enhancement and maintenance of data warehouses and ETL processes, including :

- Development of new functionality,

- Small scale redesign and

- Bug-fixes as necessary

- Investigative work to interpret clients- data structures, which may be undocumented and in diverse technologies

- Use of dimensional modelling techniques to design new or extended data stores

- Ensuring data is transported and landed in a secure and controlled fashion, building quality assurance checks into the ETL pipeline

- Creation of SSIS packages, SQL Agent jobs or command-line utilities to automate repetitive tasks

- Creation and maintenance of Analysis Services (SSAS) cubes, including complex MDX calculations

- Development of ETL systems to bring data from our clients- operational databases and data warehouses into Company's data infrastructure

- Writing specifications, designs and wiki-style documentation to enable development and support of data warehouses and supporting applications

- Use of C# to create SSIS script tasks and/or SQLCLR routines


Competencies/Skill sets for this job

Ssas Ssis C# Etl Mdx Wiki Sql

Job Posted By

Jayaraj .
Manager

About Organisation

People First Consultants