Data Warehouse Developer

American Airlines focuses on providing an exceptional travel experience across the globe, serving more than 260 airports in more than 50 countries and territories. American’s fleet of nearly 900 aircraft fly more than 3,500 daily flights worldwide from hubs in Chicago, Dallas/Fort Worth, Los Angeles, Miami and New York.

The successful candidate is a self-starter that will be responsible for integrating data into the Teradata enterprise data warehouse by leveraging the IBM Information Server/DataStage Extract-Transform-Load (ETL) software. The candidate will participate in all phases of the development lifecycle, from inception through post-implementation support, for all types of applications consistent with established specifications and business requirements to deliver business value.

* Collaborate with technical teams to develop solutions that are reusable * Understand modeling and/or diagramming techniques, with the ability to create process flow diagrams and understand the entity relationship models * Document technical designs to ensure clients’ needs are captured * Research, evaluate, identify alternative design and test approaches, and lead code reviews * Develop ETL code that meets technical specifications and business requirements according to the established designs and framework * Proactive and diligent in identifying and communicating development issues and recommending potential solutions * Troubleshoot development and operational problems and provide timely solutions * Participate in system and integration test; identifies and remedies solution defects * Create other technical deliverable artifacts such as source-to-target mappings, implementation runbooks etc. needed for project implementation

* 2+ years’ experience in developing applications in a high volume ETL DataStage environment * 2+ years’ experience with SQL, Teradata, Oracle in Unix environment * 2+ years’ experience in a technical leadership role * Strong written and verbal communications skills required; ability to lead project meetings, communicate with business stakeholders, and report to management * Understanding of data warehousing architecture is a plus * Attention to detail and maintaining high data quality standards * Tivoli Work Load Scheduler and Shell Scripting (UNIX/Linux) is a plus * Bachelor’s Degree required, preferably in Engineering or Computer Science * Airline/Travel industry experience is a plus * Experience in Agile software development is a big plus