ETL Agile Developer, Associate II (Hybrid - 3 Days in Office)

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.

Position Overview:

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.

Our Impact:

We are a BI and Analytics team that optimizes and visualizes data in a cost-effective and speed-to-market manner to serve various data analytics and reporting needs. We drive strategies and influence roadmaps to modernize and adopt Cloud technologies.

Your Impact:

• 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. This role requires working on a rotating monthly schedule outside of regular working hours, including weekend days.

Qualifications:

• 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
• Knowledge of BI tools such as MicroStrategy / Tableau is a plus
• This role requires production support on a rotating monthly schedule outside of regular working hours, including weekend days.

Keys to Success in this Role:

• Excellent problem solving, analytical and technical skills
• Effective communication skills, both written and verbal
• Ability to interact and work in individual and/or team basis
• Desire continuous learning of new and emerging technologies

Current Freddie Mac employees please apply through the internal career site.

Today, Freddie Mac makes home possible for one in four home borrowers and is one of the largest sources of financing for multifamily housing. Join our smart, creative and dedicated team and you’ll do important work for the housing finance system and make a difference in the lives of others.

We are an equal opportunity employer and value diversity and inclusion at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by applicable law. We will ensure that individuals with differing abilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

CA Applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Notice to External Search Firms: Freddie Mac partners with BountyJobs for contingency search business through outside firms. Resumes received outside the BountyJobs system will be considered unsolicited and Freddie Mac will not be obligated to pay a placement fee.

Time-type: Full time

FLSA Status: Non-Exempt

Freddie Mac offers a comprehensive total rewards package to include competitive compensation and market-leading benefit programs. Information on these benefit programs is available on our Careers site.

This position has an annualized market-based salary range of $85,000 - $127,000 and is eligible to participate in the annual incentive program. The final salary offered will generally fall within this range and is dependent on various factors including but not limited to the responsibilities of the position, experience, skill set, internal pay equity and other relevant qualifications of the applicant.