OpenTable

Sr. Data Engineer (BB-4C7F7)

Found in: Talent IN

Description:
Leads discussions with the Data Analytics developers and Data Engineers to ensure Data warehouse and reporting requirements are captured clearly. Leads estimation and project planning discussions with various team members. Develops project plans, tracks progress and provides updates to all project partners. Translates requirements into technical specifications and builds dimensional data warehouse solutions to meet the requirements. Performs unit and system testing to ensure the changes are defect free.Essential Qualifications:You have 5+ years of Data Warehouse/BI Modeling ExperienceYou have 5+ years of extensive SQL/database query skillYou have 2+ years of experience with Kimball data modelingYou have 3+ years of experience with ETL tools Informatica, Airflow or MatillionYou're experienced with Agile methodologiesGood interpersonal skillsPreferred Qualifications:Expert level experience with project management and agile methodologiesETL/ELT experienceSnowflake Data warehouse experienceELT experience with Matillion or AirflowDeep understanding of performing file level verification tasks via UNIX Shell scripts and command-line utilities etc., Python development experience.Solid understanding of structured, semi-structured and unstructured file formats and NoSQL and ability to parse them with their native utilities or by any parsing techniques.Ability to organize, prioritize work, meet deadlines, work with a team and individuallyLead data migration and integration effortsCraft processes to ensure clean dataDesign, evaluate and optimize database structures (tables, views and functions) while developing methods or scripts for monitoring database capacity, usage & performance.Prepare data for job runs. Support existing jobs. Solve, analyze and repair product issues.Experience in writing complex SQLs to analyze and fix the issues problems Develop and improve stored proceduresAble to dedicatedly monitor the overall system from the data load perspective and take appropriate actions to improve the overall implementationDeep understanding of data mapping, data validation, data manipulation, data analysis use cases and Provide observations of the system and suggest automated steps to full-fill the business operations and the requirementsTeam/Leadership:Fosters positive team engagement; steps-in to other projects as neededSolid sense of ownership; engages domain experts and other team members to work through challengesAs an employee of OpenTable, you will be part of a global network that includes OpenTable and KAYAK's portfolio of metasearch brands including momondo, Cheapflights, Swoodoo, checkfelix and Mundi. Many employees are dedicated to one brand, but we all have the benefit of using each other’s strengths and insights. Together, we’re able to help people experience the world through dining and travel.

calendar_today5 days ago

report

location_on Mumbai, India

work OpenTable

Apply:
I expressly authorise the Terms and Conditions

Similar jobs