Fannie Mae Careers

ETL Developer

Reston, Virginia
Information Management

Job Description


Fannie Mae provides reliable, large-scale access to affordable mortgage credit in communities across our nation. We are the leading source of funding for housing in America, which means more people can buy or rent a home. We are focused on sustaining the housing recovery, improving our company, and leading change to make housing better.

Join our diverse, high-performing team and make a difference as we work together to enable access to a good home.

For more information about Fannie Mae, visit


Use modern tools, techniques, and methods to develop, modify, or update applications used by business units or infrastructure units. Collaborate with subject matter experts in those units to determine unit needs and business processes that are automated by the application. Participate in most or all of the steps in the software development life cycle to create and modify the software.


  • Work with product owners and other development team members to determine new features and user stories needed in new/revised application.
  • Participate in code reviews with peers and managers to ensure that each increment adheres to original vision as described in the user story and all standard resource libraries and architecture patterns as appropriate.
  • Serve as a technical lead for an Agile team and actively participate in all Agile ceremonies. Participate in all team ceremonies including planning, grooming, product demonstration and team retrospectives.
  • Leverage Fannie Mae DevOps tool stack to build, inspect, deploy, test and promote new or updated features.
  • Respond to trouble/support calls for applications in production in order to make quick repair to keep application in production.
  • Create or Update documentation in support of development efforts. Documents may include detailed specifications, implementation guides, architecture diagrams or design documents.
  • Mentor less experienced staff.
  • Set up and configure a continuous integration environment.
  • Intermediate proficiency in unit testing as well as coding in 1-2 languages (e.g. Java, etc).
  • Intermediate proficiency in Object Oriented Design (OOD) and analysis. Intermediate proficiency in application of analysis/design engineering functions. Intermediate proficiency in application of non-functional software qualities such as resiliency, maintainability, etc. Intermediate proficiency in applying behavior-driven testing techniques.
  • Bachelor's Degree or equivalent required    
  • 2+  years of related experience

·       Extensive experience in architecture and design and implementation of complex Operational Data Store, Data warehouse and Data mart life cycle and design patterns (star schema, snowflake schema, entity relationship and dimensional data model).



·       Experience in design and development using Informatica as a ETL tool for data integration.



·       Excellent hands-on experience in Unix scripting and complex SQL queries.



·       Hands on experience with Netezza is preferred.



·       Exposure to building and deploying applications in AWS (EC2, S3, Redshift, ELB, Lambda, PostgreSQL etc.) is preferred.



·       Experience working in Agile/Scrum environment.



·       Strong analytical skills and critical thinking with strong focus on problem solving and converting business requirements into solution specification, design, and solution.



·       Highly skilled and motivated team player with demonstrated success communicating to various levels with superb interpersonal skills. 

·       Demonstrated success working well under pressure and meeting deadlines. Ability to multi task in a fast paced environment.





As a condition of employment with Fannie Mae, any successful job applicant will be required to successfully complete a background investigation.
Fannie Mae is an Equal Opportunity Employer.

Req ID: 55899