Collibra Developer, Senior

At Freddie Mac, our mission of Making Home Possible is what motivates us, and it’s at the core of everything we do. Since our charter in 1970, we have made home possible for more than 90 million families across the country. Continue your career journey where your work contributes to a greater purpose.

Are you passionate to work with the most valuable asset of an organization – “Data” and “Metadata”? Are you an engineer with good analytical and programming skills? Are you someone who is interested in doing development in Collibra, Mulesoft and AWS to capture Metadata, Lineage across the enterprise including on-premise and cloud environments? Do you have an appetite to explore and learn new data tools and technologies?

Are you a new age data tools explorer wanting to innovate, perform and deliver? If you said "yes" to these questions, you should apply to our Collibra Integration Developer Senior role with Data Management Technology team at Freddie Mac!

We are responsible for capturing the technical metadata and lineage for the diversified technology stack at the enterprise level along in Goldfield and Brownfield space. 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 Collibra DIC, Catalog, Workflows, Mulesoft, AWS, Java and Python.

We use out of the box (OOTB) metadata connectors and lineage parsers to capture metadata and lineage. Develop custom connectors and implement to production when OOTB connectors are not available to satisfy the business division’s needs. Using metadata will be captured for the new databases being created in the organization and make it available to business for their data governance needs.

We provide a searchable data catalog, including business, operational, and technical metadata and workflow and data stewardship capabilities to ensure consistency and improve quality and trustworthiness of data. We Design and build solutions based on business requirements for data governance and metadata capture and provide production level support and maintains the infrastructure needs of the data governance application.

• Understand the strategic direction of product and deliver value with effective development techniques.
• Implement end to end metadata, lineage, and data governance 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 Governance, Metadata, Data Quality and translate them into technical solutions.
• Design and develop integration capabilities between Collibra and various data sources/systems including on-premises and AWS cloud environments using Mule Soft AnyPoint studio and Collibra APls ensuring Collibra is a central governing mechanism.
• Develop and maintain data extraction, transformation and loading mappings using Mulesoft Anypoint Studio and Collibra APIs to extract the (meta) data from multiple source systems that comprise databases like Oracle, SQL Server, DB2, Mongo
  
  DB, Denodo, Hadoop, etc. into Collibra data governance platform.
• Work with business areas, data custodians and application data owners to maintain the (meta) data refresh activities for all production (meta) data.
• Perform analysis of the schema changes done in production databases and data resources to the existing mappings in Collibra and refresh the (meta) data in Collibra.
• Contribute to and lead both recurring and ad-hoc development tasks within the Data Governance and Data Quality capabilities.
• Develop application interface via APls.
• Create and configure Collibra DIC meta-model, assets, relationships, domains, and communities.
• Implementation of Collibra DIC, Workflows, lineage, and related components.
• Conduct training sessions to import/export data assets…