Informatica Data Engineer
Role description
The Informatica Data Engineer will be driving the implementation of Informatica Cloud Data Governance and Catalog (CDGC) on Informatica Data Management Cloud (IDMC). This will be a part of the migration of on-prem Informatica Enterprise Data Catalog (EDC) and Informatica Axon content to cloud services. The ideal person has previous experience in migration projects from EDC/Axon to CDGC and meeting with users, business units and data modeling teams to craft and assemble technical designs for solutions to be implemented. This role requires someone who is bilingual in English & Spanish.
Job Duties:
- Configure IDMC / CDGC target environment while implementation of Informatica Cloud Data Governance and Catalog (CDGC) on Informatica Data Management Cloud (IDMC).
- Work with upper management to understand the scope of the work and escalate to the right leads in case of issues/delays within large data warehousing environments.
- Define organizations and roles including segregation by business teams, and Authentication/Authorization and permissions set up & configurations, according to best practices, including integration with Azure AD and SSO.
- Understand the business requirement or the downstream process requirements while serving as technical liaison between teams regarding new system implementations, development, integration, and changes while collaborating with management to design technical solution.
- Install Secure Agent instances on-prem in non-production and production environments.
- Set up connectivity to on-prem data sources (mainly Oracle, SQL Server, Denodo) and Snowflake enterprise data warehouse and AWS Athena data lake.
- Analyze existing business glossary, metadata catalog, and data connectors in EDC/Axon.
- Participate in Migration planning in a phased approach following prioritization defined by Santander project lead.
- Export and import existing content to Cloud, and/or re-configuration of data connectors to re-scan metadata in addition to conducting technical validations and support UAT testing.
- Serve as primary point of contact between users and engineering/development staff on nonproduction and production environments.
- Support users during weeks immediately after go live during stabilization phase.
Education & Requirements:
- Bachelor's Degree is required
- Bilingual in English & Spanish is required (verbal, written)
- 4+ years' experience with Informatica Cloud Data Governance and Catalog (CDGC) on Informatica Data Management Cloud (IDMC)
- Previous experience with migrating Enterprise Data Catalog (EDC) and Informatica Axon content to the cloud is required.
- Must have experience with Oracle, SQL Server, and/or Denodo
- Snowflake enterprise data warehouse experience is required
Plus:
- Previous experience in banking/financial sectors is a plus