Description

You will design, build, and maintain the enterprise data warehouse using Snowflake and Informatica IICS, owning the full lifecycle from data integration to reporting.

This role is on-site.

Responsibilities

• Design and develop data warehouse models and data lake-house architectures for strategic planning.
• Execute ETL/ELT tasks using Informatica IICS, including Change Data Capture via PowerExchange.
• Build and test Power BI and Tableau dashboards, ensuring data models support Business Intelligence needs.
• Administer and tune Snowflake Data Cloud and Informatica IICS for performance optimization.
• Maintain data warehouse metadata and ensure governance using tools like EDC and Axon.

Required Skills

• Snowflake Data Cloud (Administration, Performance Tuning).
• Informatica IICS Cloud (Administration, Performance Tuning, Data Integration).
• ETL/ELT development and ELT with Change Data Capture.
• Data modeling for Power BI and Tableau.
• IBM Mainframe analysis: COBOL, JCL, and DB2.
• Data Governance products (EDC, Axon, CDGC).
• Informatica PowerCenter and Data Quality experience.
• 5+ years of experience in data warehousing and integration.

Key Skills

Education

Any Graduate