Data Warehousing Engineer

Pinnacle Solutions
  • Delhi
  • 10-15 lakh
  • 3-6 years
  • Views
  • 03 May 2017

  • IT/ Information Technology

  • IT/ Technology - Software/ Services
Job Description

- Plan, create, coordinate, and deploy data warehouses.

- Design end user interface.

- Create best practices for data loading and extraction.

- Develop data architecture, data modelling, and ETFL mapping solutions within structured data warehouse environment.

- Develop reporting applications and data warehouse consistency.

- Facilitate requirements gathering using expert listening skills and develop unique simple solutions to meet the immediate and long-term needs of business customers.

- Supervise design throughout implementation process.

- Design and build cubes while performing custom scripts.

- Develop and implement ETL routines according to the DWH design and architecture.

- Support the development and validation required through the lifecycle of the DWH and Business Intelligence systems, maintain user connectivity, and provide adequate security for data warehouse.

- Monitor the DWH and BI systems performance and integrity provide corrective and preventative maintenance as required.

- Manage multiple projects at once.

- Possess Bachelor's degree in an analytical related field, including information technology, science, and engineering discipline

- Three years or more experience performing data warehouse architecture development and management

- Remarkable experience with technologies such as MySQL, MongoDB, SQL Server 2008, as well as with newer ones like SSIS and stored procedures

- Exceptional experience developing codes, testing for quality assurance, administering RDBMS, and monitoring of database

- High proficiency in dimensional modeling techniques and their applications

- Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel

- Several years working experience with Tableau, SportFire, TIBCO, QlikView, MicroStrategy, Information Builders, and other reporting and analytical tools

- Working knowledge of SAS and R code used in data processing and modelling tasks

- Remarkable experience with Amazon AWS and Microsoft Azure computing platforms

- Strong experience with Hadoop, Impala, Pig, Hive, YARN, and other - big data- technologies.

Competencies/Skill sets for this job

Ssis Azure Hadoop Qlikview Sas Pig Aws Rdbms Modeling

Job Posted By

About Organisation

Pinnacle Solutions