Technical Lead
in IN - HR - Gurugram

Job Description

Role Purpose

The Data Engineer plays a Lead technical role in an Agile/Scrum based Data Science team working in a development environment designing and maintaining data stores that will be used for analytical processing and/or data warehouse.  Individual is a subject matter expert in Hadoop, Vertica and related technologies.  This individual is responsible for maintaining data integrity, data modeling, performance tuning, and advanced administration of Big Data, and Data-mart systems.

Key Performance Measurements

  • Selecting and integrating any Big Data tools and frameworks required to provide requested capabilities

  • Implementing ETL process 

  • Monitoring performance and advising any necessary infrastructure changes

  • Defining data retention policies

  • Data modeling, database optimization, understanding and implementation of schemas, and the ability to interpret and write complex SQL queries

  • Responsible for the administration, performance and security of existing databases and the analysis, design, and creation of new databases

  • Proactively monitor and tune systems, databases and BI tools/software for optimum performance and capacity constraints

  • Analyze user requirements and design functional specifications for BI front-end applications

  • Produce ETL design guidelines to ensure a manageable ETL infrastructure

  • Promote and educate BI usage and benefits across the organization

  • Evaluate and make recommendations for database/data warehouse components, including hardware, database management systems, ETL software, BI products, services, and standards in support of procurement and development efforts.

    Mentor junior database engineers

    Requirements

  • 6+ years of database design in a development and/or production environment

  • 4+ years ETL design and implementations

  • 2+ years in data cleansing

  • One or more of the following certifications highly desirable: MCITP: Database Administrator certification, MCSE: Data Platforms, MCSE: BI

     

    Preferences

  • Bachelors degree in Computer Science, IT or higher

     

    Aristocrat is an equal opportunity employer, we strongly encourage applications from interested female candidates/applicants.

Apply Now