Data Engineer III
Website Expedia
What you will do:
- Designing, developing, deploying and managing high volume/high transactional mission critical SQL/No SQL systems.
- Design, build, and maintain scalable data pipelines and ETL processes Data Warehouse solution.
- Develop and optimize data models for efficient storage and retrieval.
- Implement and manage data lakes and warehouses using Spark, Scala, and Hive technologies.
- Demonstrate deep knowledge of optimization techniques and fine tuning SQL queries and stored procedures.
- ETL pipeline orchestration and build using Airflow, Jenkins, Github actions etc..
- Lead database upgrade efforts in AWS environment
- Disaster Recovery planning and Implementation.
- Define actionable KPIs and configure monitoring/alerting.
Who you are:
- 7+ years’ experience with managing high transaction volume SQL/No SQL systems like SQL Server, MySQL, PostgreSQL, Teradata
- Proficient in writing complex SQL queries , joins and stored procedures.
- Proven experience as a Data Engineer or similar role.
- Experience with Spark batch and stream processing and exposure to other bigdata technologies.
- Strong experience in writing spark jobs in Scala and using Hive for data processing and analysis
- Strong understanding of data warehousing concepts and best practices.
- Proficiency in data modelling concepts and can define data elements, relationships, constraints, and rules to ensure data integrity and optimize data storage and retrieval.
- Experience with Apache Iceberg, Delta, and Parquet table formats.
- Excellent problem-solving skills and attention to detail.
- Ability to work independently and collaboratively in a fast-paced environment.
- Demonstrable experience and knowledge in DWH concepts and ETL tools like Informatica
- Strong experience , Strong aptitude for building robust, automated processes and tools
- Amazon AWS experience, particularly RDS, EC2 and Aurora
- Experience in a Linux environment, and familiarity writing shell scripts
- Able to troubleshoot and resolve complex production issues
- Experience with Python or other scripting language
- Experience with Grafana, Splunk, Datadog , CloudWatch or PagerDuty
- Amazon RedShift experience – Nice to have
About Expedia Group
Expedia Group (NASDAQ: EXPE) powers travel for everyone, everywhere through our global platform. Driven by the core belief that travel is a force for good, we help people experience the world in new ways and build lasting connections. We provide industry-leading technology solutions to fuel partner growth and success, while facilitating memorable experiences for travelers. Expedia Group’s family of brands includes: Brand Expedia®, Hotels.com®, Expedia® Partner Solutions, Vrbo®, trivago®, Orbitz®, Travelocity®, Hotwire®, Wotif®, ebookers®, CheapTickets®, Expedia Group™ Media Solutions, Expedia Local Expert®, CarRentals.com™, and Expedia Cruises™.
