Explore Careers at DFW Airport

Sr Data Integration Developer

DFW Airport, TX, United States
Jun 7, 2022


Job Description


Job Overview:


Under supervision of the Senior System Integration Manager, is responsible for ensuring that the Airport’s strategic goals are optimized through the use of Enterprise Business Intelligence.  Assists internal team members and BI users in the use of and the presentation of data including predictive data. Uses tools, protocols, and programming languages to develop and maintain ETL (extract, transfer, and load) applications and environments. 

What you will be doing:


•     Develops and maintains the database scripts and ETL processes required to move data from source systems to the EDW.

•     Maintains the ETL processes on a timely basis making certain all are running and providing data in the best format for the EDW.

•     Develops and migrates mapping and workflows between repositories

•     Works with BI Team to assess business needs as they pertain to current EDW and ETL processes, so the best solution is presented to customers.

•     Works with System Administrators, Database Administrators, and the Quality Assurance Center of Excellence to test and tune development efforts.

•     Responsible for maintaining settings for ETL including, users, file system and services.

•     Uses statistical analysis to generate predictive analytic sets and mitigation plans for requested datasets.

•     Works with MicroStrategy Developers, Architects, and ETL Developers to ensure data is prepared as needed for predictive models to work properly.


What you need:


•     Bachelor's degree in business, computer science or a related field

•     Five (5) years of experience using Informatica as an architect, designer, and developer

•     Any equivalent combination of education and/or experience may be substituted for the above.

•     Experience using PowerCenter in multiple-developer environments.

•     Strong knowledge of Informatica development best practices.

•     Experience tuning performance of ETL processes.

•     Experience configuring Informatica jobs and dependencies when using 3rd party enterprise scheduling tools.

•     Any equivalent combination of education and/or experience may be substituted for the above.

•     Possession of a valid class C driver's license

What we desire:


•     Experience designing, developing, and deploying ETL processes; experience with data loading and the creation of data warehouses and/or data marts; hands-on ETL development; and experience reviewing ETL load jobs coded by others for consistency and quality.

•     Experience coaching and training customers and peers in the use of ETL tools to assist with ETL processes.

•     Degree or certificate within Statistical Analysis, Business Analytics, Predictive Analytics, etc.

•     Experience with data visualization tools, such as D3.js




•     Must obtain a Security Identification Display Area (SIDA) Airport Identification/Access Badge (badge) in accordance with Department of Homeland Security Transportation Security Administration (TSA) requirements in Chapter 49 of the Code of Federal Regulations Part 1500 et. Al. and DFW Airport’s Airport Security Program within thirty (30) days from date of employment and maintain qualification for a SIDA badge upon each badge renewal.

•     Ability to obtain Department of Homeland Security Customs and Border Protection (CBP) security access clearance within thirty (30) days from date of employment and maintain qualification for CBP security access clearance upon each CBP security access renewal.

•     This is a designated essential employee position as defined in the Categories and Classifications of Employees Policy of the Airport Administrative Policy and Procedure.  This is defined as an employee whose attendance is required to maintain airport operations during an emergency or inclement weather situation.


About Us

We are Dallas Fort Worth International (DFW) Airport—one of the most successful airports in the world by any definition. We’re recognized for our innovation, leadership, drive for excellence and talented employees.

Our success is made possible because of the diverse talents of over 2,000 employees who champion our mission of providing an exceptional airport experience to our customers and connect our community to the world. We’re looking for the best talent to join us and help reimagine what an airport can be.

Bring your talents to DFW. Live and work with purpose.


Job Info

Job ID# 1006299

Jun 7, 2022

United States