Informatica Developer Professional (Hybrid 3 days in office)

JOB DESCRIPTION

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 provides data expertise related to data governance, data quality and metadata management. Developer Sr in this organization to support our Informatica MDM development for business needs. The Developer Sr will manage design, development, testing, manage risks and issues, impact on systems, and dependencies to other IT systems within the company. Candidate 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. We need a “can-doer” who can coordinate across teams, is an independent, fast learner

Our Impact :

We are responsible for the Master data Management for multiple domains at the enterprise level along with data quality checks of the data.

Team will use out of the box (OOTB) connectors and lineage parsers to capture metadata and lineage.

We are custom connectors will be developed and implemented to production when OOTB connectors are not available to satisfy the business divisions needs

Data will be gathered for the new databases being crafted in the organization and make it available to business for their data governance needs

Connectivity to different data sources will be enabled to perform the data quality checks

We provide support to business divisions to develop DQ check jobs and to implement these jobs into production

Maintain 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 product and deliver value with effective development techniques.

Implement end to end Master Data Management and Data Quality solution.

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, 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 & Mongo DB 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.