Description

You design, build, and optimize enterprise data warehouses using Snowflake and Informatica IICS.

This role is on-site.

Responsibilities

• Design and develop data warehouse models, data lakes, and lake-houses for reporting and analytics.
• Execute extraction, transformation, and load (ETL/ELT) tasks, including Change Data Capture solutions.
• Build, prototype, and test interactive reports and dashboards in Power BI and Tableau.
• Administer and tune performance for Snowflake Data Cloud and Informatica IICS environments.
• Mentor peers on data warehousing concepts and maintain documentation for data governance and metadata.

Required Skills

• Strong experience with Snowflake Data Cloud architecture and administration.
• Proficiency in Informatica IICS Cloud Data Integration and PowerCenter.
• Hands-on experience with Power BI and Tableau for data visualization.
• Knowledge of ELT processes and Change Data Capture (e.g., PowerExchange).
• Familiarity with IBM Mainframes, including COBOL, JCL, and DB2 analysis.
• Experience with data governance tools such as EDC, Axon, or CDGC.
• Minimum 5 years of experience in data warehousing and integration.

Preferred Skills

• Experience with Informatica Data Quality and on-premises product administration.

Key Skills

Education

Any Graduate