Expedia – Bellevue, WA (Greater Seattle Area)
Job Description
The Enterprise Data Warehouse (EDW) team is currently looking for a talented and highly motivated Sr. Data Warehouse 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 Data Warehouse. As the Sr. Data Warehouse Developer, you would be playing a technical leadership role and will be responsible for the full development lifecycle 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 Data Warehouse 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 environment
• Strong scripting skills to perform data/file manipulation (e.g., PERL)
• Database development in an MPP DW environment is a must have with an eye for tuning and performance.
• Development background should include experience in Informatica Power center version 8.5.1, but not required.
• Experience as development lead is a must. Additionally, offshore leadership experience is ideal.
• Qualified individuals will have a solid background in DB2/SQL Server query and data investigation fundamentals.
• 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 data warehouse 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 also viable.
• Informatica Powercenter experience preferred. Strong experience with Data Stage also viable.
• Ability to create, read, understand, and interpret Data Models.
• Strong verbal and written communication skills.
• Experience working in a large data warehouse environment.
• Excellent problem solving skills.
