Data Warehousing Consultant

Trulymadly; New Delhi; Sur place; INR 1 500 000 - 1 900 000; Plein temps

Résumé du poste

Trulymadly is seeking a senior Data Warehouse professional to join its analytics team. The ideal candidate has 6+ years of experience, expert SQL, ETL, and data warehousing best practices.

You will design, architect, and implement DW solutions using MS SQL Server, Greenplum, Hadoop, Python, PL/pgSQL, C#, and Tidal Scheduler, and collaborate across business units.

Strong analytical and communication skills are essential, with familiarity in Cognos, Tableau or QlikView.

Qualifications

• BE/B.Tech/M.Tech/PhD in CS from a tier 1 college.
• 5+ years of experience developing SQL stored procedures, performing optimization and query tuning.
• Solid understanding of data warehousing methodologies, ETL, and data modeling.
• Experience with MPP systems and Hadoop stack.
• Strong analytical and creative problem solving skills.
• Team player with excellent communication skills.
• Familiarity with BI tools like Cognos/Tableau/QlikView.

Responsabilités

• Involve in all phases of SDLC and work on design, architecture and implementation of our data warehouse environment.
• Participate in code and technology reviews.
• Work closely with other team members and the business.
• Be exposed to various data domains and contribute ideas.

Connaissances

SQL

ETL

Data warehousing

Analytical thinking

Problem solving

Communication skills

Formation

BE/B.Tech/M.Tech/PhD in CS from tier 1 college

Outils

MS SQL Server

Greenplum MPP

Hadoop

Python

Ksh

PL/pgSQL

C#

Tidal Scheduler

Description du poste

Looking for a senior resource for Trulymadly Data Warehouse team for a consultant professional with expert level knowledge in SQL, ETL, data warehousing methodologies and best practices. The successful candidate must have at least 6+ years of extensive experience in working with large scale data warehouses. The candidate must be technically strong with excellent analytical and problem solving skills, highly motivated, quick learner with strong interpersonal, written, and verbal communication skills. The candidate will be involved in all phases of SDLC and will be expected to work on design, architecture and implementation of our data warehouse environment, participate in code and technology reviews, and work closely with other members of the team and the business. The candidate will be exposed to the variety of data domains and have enormous opportunities to learn and contribute ideas.

Some of the goals are:

Build new state of the art data mart, fully automated NRT ETL, reporting and analytics;

Enhance the data warehouse infrastructure to support current systems;

Develop fully automated DR and failover;

Create tidal jobs to support needed tasks;

Support integration with various upstream systems and reporting.

All of the above work will be done using MS SQL Server, Greenplum MPP, Hadoop, variety of scripts/languages (python, ksh, PL/pgSQL, C#) and Tidal Scheduler.

Qualifications:

BE/B.Tech/M.Tech/PhD Degree in Computer Science, Engineering from a tier 1 college.

5+ years of experience developing SQL stored procedures, performing optimization and query tuning, and designing databases.

Solid understanding of data warehousing methodologies, various stages of ETL and data modeling.

Experience working with MPP systems, Hadoop stack

Strong analytical and creative problem solving skills

Team Player with Excellent communication skills

• Familiarity with BI tools like Cognos/Tableau/QlikView