Data Warehousing Engineer

Pinnacle Solutions
  • Delhi
  • Confidential
  • 3-6 years
  • Views
  • 28 May 2018

  • IT/ Information Technology

  • Internet/ ECommerce
Job Description

Primary responsibilities : - 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. Skills : - 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.


Job Posted By

About Organisation

Pinnacle Solutions