ETL Informatica Developer

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 SingleFamily 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 SingleFamily 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 costeffective and speedtomarket 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 youll 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.

A safe and secure environment is critical to Freddie Macs business. This includes employee commitment to our acceptable use policy applying a vigilancefirst approach to work supporting regulatory mandates and using best practices to protect Freddie Mac from potential threats and risk. Employees exercise this responsibility by executing against policies and procedures and adhering to privacy & security obligations as required via training programs.

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. If interested in learning more please visit and register with our referral code: MAC.

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