Informatica Developer Professional (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 someone who takes pride in working with the Agile teams and enjoy working with multiple divisions across the organization? If you are passionate to work with the most valuable asset of an organization – “Data” and “Metadata” - consider applying to the Developer Sr opportunity to join our IT Data Solutions team!

We interact with all areas of Freddie Mac’s business and provide data expertise related to data governance, data quality and metadata management. The Developer Sr will support our Informatica MDM development for business needs, managing design, development, testing, risks, issues, and dependencies to other IT systems within the company. Candidates should be comfortable with donning multiple hats when working with teams inside and outside IT. We seek someone who’s excellent with written and verbal communications and can be a self-starter in leading and completing various efforts under tight deadlines.

Our Impact:

We are responsible for Master Data Management for multiple domains at the enterprise level along with data quality checks of the data. The team will use out of the box (OOTB) connectors and lineage parsers to capture metadata and lineage. Custom connectors will be developed and implemented to production when OOTB connectors are not available to satisfy business division needs. Data will be gathered for the new databases being crafted in the organization and made available to business for their data governance needs. Connectivity to different data sources will be enabled to perform data quality checks. We provide support to business divisions to develop DQ check jobs and implement these jobs into production, maintaining the infrastructure needs of the data governance and data quality applications.

Each of these activities support the Single-Family, Multi-Family, Investments & Capital Markets, Finance, Enterprise Operations & Technology, and Enterprise Risk Management business divisions to enable data governance and data quality on the data assets of the organization. We will serve as a centralized development group for the data governance and data quality business needs of divisions, using tools such as Informatica Data Management Cloud including MDM, IDQ, Power Center, IICS etc., AWS Infrastructure as a Code, and Unix.

Your Impact:

Understand the strategic direction of the product and deliver value with effective development techniques. Implement end-to-end Master Data Management and Data Quality solutions. Identify optimization scenarios and implement appropriate solutions. Work with business SMEs and identified project partners to develop requirements (functional/non-functional/operational/data quality) for Data Quality and Master Data Management and translate them into technical solutions. Design and develop integration capabilities between Informatica MDM and various data sources/systems including on-premise and AWS cloud environments using IICS, Power Center, IDQ, Web services and other integration mechanisms and patterns. Data modeling & Data Mappings (Landing, staging, and Base Objects), Data validation, Match and Merge rules, SIF Framework, and MDM User Exits. Well versed with best practices driven design and development including match rule tuning to ensure timeliness and quality of deliverables. Strong ability to understand, document, and communicate technical architectures, standards, best practices, toolsets, and solutions. Create MDM /IDQ Jobs & set up Security for applications. Support all phases of the project development lifecycle using SDLC and Agile project methodologies. Provide production support, solve and resolve systems issues.

Qualifications:

• 5+ years of software development experience

• Bachelor’s degree or equivalent experience; advanced studies/degree preferred.

• Hands-on experience with Informatica MDM

• Hands-on experience with Informatica IDQ

• Hands-on experience with Informatica IICS

• Data modeling & Data Mappings (Landing, staging, and Base Objects), Data validation, Match and Merge rules, SIF Framework, and MDM User Exits.

• IDD Customization

• Strong SQL and NoSQL experience (Oracle Database & MongoDB preferred)

• UNIX Shell Scripting

• Extract Transform and Load (ETL) experience using IDQ, Power Center is good to have

• Experience working with AWS Services including but not limited to ELB, EC2, EKS, ECR, S3, SQS, SNS, SSM, Secrets Manager, KMS, RDS, IAM, and Autoscaling

• Experience working with Scrum and JIRA

Keys to Success in this Role:

• Self-starter and self-motivated.

• Ability to work & collaborate effectively in a team environment.

• Sense of urgency and able to apply risk-based approach to prioritize work.

• Ability to communicate clearly, effectively, and persuasively. Motivated to learn new technologies, tools, and identify process improvements and efficiencies.

• Strong verbal and written communication skills

• Be comfortable communicating with all levels of Leadership.

• Ability to listen to customers and colleagues; convey ideas effectively; maintain strong business relationships.

• Proven leadership skills, problem-solving, and excellent written and verbal communication skills.

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

Time-type: Full time
FLSA Status: 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 $103,000 - $155,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.