Description

You will design, build, and maintain enterprise data warehouses using Snowflake and Informatica IICS. You own the ETL/ELT pipelines, data modeling, and reporting infrastructure for analytics.

This role is on-site.

Responsibilities

• Design and develop Snowflake data lake-house architectures and optimize warehouses for reporting.
• Build and maintain ETL/ELT pipelines using Informatica IICS, including PowerExchange for CDC.
• Create and test Power BI and Tableau dashboards, ensuring models support Business Intelligence needs.
• Analyze IBM Mainframe data (COBOL, JCL, DB2) to integrate legacy systems into modern warehouses.
• Mentor peers on data warehousing concepts and maintain documentation for methods and practices.

Required Skills

• Snowflake Data Cloud administration and performance tuning.
• Informatica IICS Cloud Administration, PowerCenter, and Data Quality.
• Strong experience with ETL/ELT processes and Change Data Capture (CDC).
• Data modeling for Power BI and Tableau.
• IBM Mainframe analysis: COBOL, JCL, and DB2.
• Data governance tools: EDC, Axon, or CDGC.
• Metadata collection and maintenance.

Preferred Skills

• 10+ years of experience in data warehousing and integration.

Key Skills

Education

Any Graduate