Senior 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

Work Experience and Education Guidelines:

• 5+ years total DW/BI experience using Informatica, Oracle.
• 2+ of experience co-coordinating with offshore teams
• BS in Computer Science or related degree

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, negotiates deep discounts from its travel suppliers to help sell their excess inventory.

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

The successful candidate must enjoy working in a fast-paced, multi-tasking environment and use disciplined best practices to ensure a high-quality and well-designed reporting environment. The candidate must have excellent working knowledge of the Hadoop eco system