Description

Design, build, and maintain enterprise data warehouses using Snowflake and Informatica IICS, focusing on ETL/ELT processes and data modeling for BI reporting.

This role is on-site.

Responsibilities

• Develop and optimize data warehouse models and architectures for reporting and analytics.
• Build and test Power BI and Tableau dashboards, ensuring accurate data visualization.
• Execute complex ETL/ELT tasks using Informatica IICS, PowerCenter, and Snowflake.
• Administer and tune Snowflake Data Cloud and Informatica IICS performance.
• Mentor peers on data warehousing concepts and maintain documentation and metadata standards.

Required Skills

• 5+ years of experience in Data Warehousing and Data Integration.
• Proficiency with Snowflake Data Cloud and Informatica IICS Cloud.
• Strong background in ETL/ELT processes, including Change Data Capture (PowerExchange).
• Experience designing data models for Power BI and Tableau.
• Knowledge of Informatica on-premises products (PowerCenter, Data Quality).
• Familiarity with IBM Mainframes (COBOL, JCL, DB2) is required.
• Understanding of Data Governance tools (EDC, Axon, CDGC) is preferred.

Preferred Skills

• Experience with Informatica IICS Cloud Administration.
• Bachelor's degree in Computer Science or related field.

Key Skills

Education

Bachelor's degree