Description

You will design, build, and maintain the enterprise data warehouse using Snowflake and Informatica.

This role is on-site.

Responsibilities

• Design and implement data mining, extraction, loading, cleansing, and transformation (ETL/ELT) pipelines for Snowflake.
• Develop enterprise data models, data lakes, and prototype solutions for data replication and management.
• Gather business requirements and translate them into system specifications and reporting needs.
• Validate data accuracy, create test scripts, and ensure data warehouse integrity.
• Provide technical consulting to user communities and maintain data governance using EDC, Axon, and CDGC.

Required Skills

• 12+ years of professional experience in information systems engineering or related field.
• Extensive hands-on experience with Snowflake Data Cloud and enterprise data warehouse/lakehouse design.
• Proficiency with Informatica IICS Cloud Data Integration and Informatica PowerCenter.
• Experience with Intelligent Data Quality and data governance tools (EDC, Axon, CDGC).
• Ability to build reports and dashboards using Power BI and Tableau.
• Experience analyzing IBM Mainframes using COBOL, JCL, and DB2.
• Strong competency in data mining, mart development, and enterprise data modeling.

Preferred Skills

• Prior experience working within the public sector.

Key Skills

Education

Any Graduate