Sn. BI (ETL) Engineer

• Participate in the implementation effort (developing, testing, tuning and debugging) of various DW Agile projects.
• Discuss business requirements with business stakeholders and translate them into ETL code
• Help users with Data Analysis and partner with them for BI deliverables assigned
• Collaborate with business owners, architects and other BI engineers to ensure the creation of production-quality designs and implementations
• Develop, test, and deploy within established build schedules and processes (code review, source control, unit testing, test case analysis, defect management)
• Supporting current data warehouse loading process
• Utilize automation tools to schedule, execute, and monitor ETL jobs;
• Programming skills: Core Java, Python is a plus
• Perform performance related troubleshooting and solution implementation
• Work in translating the business requirements from onsite business teams to the offshore development team
• Perform ad-hoc analysis required for end-users

• Super Strong SQL experience (5+ years) is required
• 5+ years experience with Informatica Power Center
• Must be able to provide ETL design options, alternatives and recommendations based on experience and best practices
• Experience in writing UNIX shell scripts SQL-Loader, Performance & Tuning of Database and ETL applications
• Have a passion in testing Data and ensuring high data quality standards
• Knowledge of Reporting environment (Microstrategy, BO or Qlikview..so on) and scheduling tools is a plus
• Knowledge of Hadoop technologies including HDFS, MapReduce, Pig/Hive, sqoop, flume is a big plus
• Candidate should possess excellent communication, interpersonal and problem-solving skills, in order to work effectively in the team and with other Hotwire teams

Hotwire.com is a leading discount travel Web site with consistently lower prices on airline tickets, hotel rooms, rental cars, cruises and vacation packages. Launched in 2000 with funding from six major airlines, Hotwire negotiates deep discounts from its travel suppliers to help sell their excess inventory. Hotwire is a wholly owned subsidiary of Expedia, Inc. (NASDAQ: EXPE) and is based in San Francisco, CA. For more information, visit http://www.hotwire.com/

Hotwire is seeking qualified candidates for the position of Sr BI Engineer to join a team responsible for evolving and supporting our company-wide data warehouse and reporting systems.

The candidate must have excellent working knowledge of the Hadoop eco system.