DB2 Developer, Datawarehouse

Are you a Datawarehouse Developer who wants to work for a strong and innovative online travel technology company? Do you have a passion for turning data into meaningful information? Does working on a world class Datawarehouse implementation and diving into Big Data technology and tools excite you? Is a Big Data implementation that will look to scale to 1.2PB by the end of the year sparking any interest? If any of those are true Expedia is the right place for you.

The Enterprise Datawarehouse (EDW) team is currently looking for a talented and highly motivated Datawarehouse Developer that can partner with delivery management, QA/test and release management teams to support the business by delivering high quality solutions for the Enterprise Datawarehouse. As the Datawarehouse Developer, you would be playing a technical leadership role and will be responsible for the full development life cycle of the solution, including detailed design, code development, code reviews, unit testing, build/test support and finally deployment activities and post deployment support. This role will have opportunities to manage on and offshore development resources to deliver solutions to the business community.

RESPONSIBILITIES:

Responsibilities include assessing business rules; performing source to target data mapping; designing, reviewing, implementing and optimizing ETL processes; reviewing project plans, development and test specifications; performing data analysis; providing development support for existing systems; troubleshooting data and/or system issues; building/extending toolsets; creating/maintaining batch jobs; creating systems documentation; managing and mentoring other ETL developers etc. Provide data analysis and identify data related issues within the Datawarehouse environment as well as upstream systems, as needed.

QUALIFICATIONS:

Highly experienced developer in ETL Development; DB2 and Informatica experience is strongly preferred
Strong background in Data Warehousing and Business Intelligence environment working with extremely large data sets
Strong Scripting skills to perform data/file manipulation (eg, PERL)
Database development in an MPP DW environment is a must have with an eye for tuning and performance
Exposure to no-SQL technologies and big data platforms such as Hadoop, HBASE or Cassandra is highly desired
Development background should include experience in Informatica Power center version 8.5.1, but not required
Ability to read and interpret data schemas, with emphasis on DB2 implementations
Proven ability to create and maintain online and printed documentation
Proven ability to work cross functionally to deliver appropriate resolution of technical, procedural, and operational issues
Must have strong customer service skills and excellent verbal and written communication skills
Must be able to drive investigations to completion and ensure customer satisfaction
Must be flexible and motivated to work in a fast-paced environment

WORK EXPERIENCE AND EDUCATION GUIDELINES:

MS/BS degree in Computer Science, related technical field preferred, or equivalent work experience
Experience with Datawarehouse technologies and/or a Back End reporting system is required

CORE COMPETENCIES:

Strong skills in DB2 stored procedures, views, etc. preferred. Strong experience with Teradata or Netezza or other MPP implementations also viable
Informatica Powercenter experience preferred. Strong experience with Data Stage also viable
Ability to create, read, understand, and interpret Data Models
Must have strong verbal and written communication skills
Must be able to work through ambiguity and turn around options by partnering with project stakeholders
Experience working in a large Datawarehouse environment
Excellent problem solving skills

About Expedia:

Our mission is to revolutionize travel through the power of technology.
Collectively, the Expedia brands cover virtually every aspect of researching, planning, and booking travel, from choosing the best airplane seat, to reading personal travel reviews of hotels, to planning what to do in a destination once you arrive. The Expedia portfolio serves both leisure and business travelers with tastes and budgets ranging from modest to luxury. Expedia delivers consumer travel demand from nearly every continent to nearly 149,000 hotels and hundreds of airlines, tour operators, car rental companies and destination services supply partners. Please visit our website to learn more about our travel brands.