Data Warehouse Analyst

Description

We are recruiting for our client. Pointwest is seeking a highly skilled Data Warehouse Analyst to support the administration and optimization of the Informatica Intelligent Data Management Cloud (IDMC) platform and related services. The role includes responsibility for platform configuration, performance tuning, CI/CD pipeline integration, agent administration, and support for enterprise data integration initiatives using Snowflake and other technologies.

Key Responsibilities:

• Administer and maintain Informatica IDMC services (e.g., CDI, CAI, DQ)
• Deploy and configure Secure Agents on Red Hat Linux
• Implement load balancing, agent failover, secure communications (TLS/SSL)
• Maintain CI/CD pipelines for deployments (Git, Jenkins)
• Configure platform connections, secure credentials, and parameter tuning
• Manage SSO, SAML, security policies, and access roles
• Perform platform health checks, patching, log rotation, and troubleshooting
• Collaborate with security, infrastructure, and data teams
• Stay current with new Informatica features and industry best practices

Primary Tasks:

• Data integration and ETL/ELT tasks using Informatica IDMC tools
• Manage Snowflake Data Cloud and Secure Agent Infrastructure
• Red Hat Linux administration (scripts, patching, disk/filesystem management)
• Data warehouse modeling and transactional data analysis
• Support Change Data Capture using PowerExchange
• Collaborate with business teams for report and dashboard development (Power BI, Cognos)
• IBM Mainframe experience (COBOL, JCL, DB2) is a plus

Mandatory Qualifications:

Education: Bachelor's degree in Computer Science, Information Systems, or equivalent work experience

Experience: Minimum 7 years in IT using data warehousing, business intelligence, and data integration tools

Technical Skills:

• Strong expertise in Informatica IDMC (CDI, MI, CAI)
• Experience with Red Hat Linux and Secure Agent configuration
• Advanced knowledge of Snowflake, DB2, Oracle, and SQL Server
• CI/CD automation (e.g., Jenkins, Git)
• Power BI and Cognos design and integration
• Informatica PowerCenter and Data Quality
• Informatica and Snowflake performance tuning

Preferred Skills:

• Familiarity with IBM Mainframes (COBOL, JCL, DB2)
• IDMC Cloud Administration experience
• Designing and building data models and dashboards in Power BI and Cognos
• Experience with ServiceNow and other IDMC connectors