ETL Informatica Developer

Freddie Mac • McLean, VA

301d • $85,000 - $127,000

About The Position

At Freddie Mac, you will do important work to build a better housing finance system and you'll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation. Are you looking for an inclusive company culture to help you apply your software development skills to the workforce? If you have Data Integration and ETL development experience and enjoy working with a team of varying skills to collectively discover new opportunities to delight customers, a role on the Single-Family Data & Decisions - Modern Delivery team could be a fit for you! The ETL Developer Assoc II will be part of the Business Intelligence and Data, Modern Delivery team in the Single-Family line of business helping to transform the way in which Freddie Mac does business! We are looking for an ETL Developer who is energetic, brings fresh and creative perspective with constant collaboration and out of box thinking. The ideal candidate is a quick learner, flexible, comfortable working in an agile and iterative product delivery environment and has a customer centric mind set.

Requirements

• 1 to 3 years of ETL tool experience using Informatica Cloud tool - IICS/IDMC
• 1 to 3 years of ETL tool experience using Informatica PowerCenter 9x/10x
• Knowledge with scripting languages including SQL, Unix Scripting
• Knowledge with Data Modeling and Dimensional Modeling techniques, design and implementation of Star and Snowflake schemas
• College Degree or equivalent experience preferred

Nice To Haves

• Knowledge of BI tools such as MicroStrategy / Tableau is a plus

Responsibilities

• Work with Tech Leads, Product owners, Developers, and Analysts to define, develop, and deliver product enhancements and new products.
• Assist in the development, maintenance, and support of Data mart applications.
• Troubleshoot and tune existing data mart applications.
• Assist in creating new or enhanced components of the data mart.
• Implement best practices and methodologies and function in the design, development, modification and debugging of ETL code.
• Partner with Development Tech Lead and Architects to find innovative solutions.
• Work with teammates to clarify the requirements and scope and test developed solutions to ensure accurate business outcomes.
• Provide maintenance, and Production support.

Benefits

• Competitive compensation
• Market-leading benefit programs
• Annual incentive program

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Industry: Credit Intermediation and Related Activities
• Education Level: Bachelor's degree