Data Warehouse Analyst

Pointwest-North America; Town of Florida (NY); On-site; USD 100,000 - 130,000; Full time

Job summary

Pointwest-North America is looking for a Data Warehouse Analyst to support the optimization of the Informatica Intelligent Data Management Cloud (IDMC) platform. The role requires strong skills in administering Informatica services and managing data integration initiatives with Snowflake.

This position demands at least 7 years of IT experience, particularly in data warehousing and integration tools, with a focus on Informatica IDMC and Red Hat Linux administration. Join an innovative team driving enterprise data integration!

Qualifications

• Minimum 7 years in IT using data warehousing and integration tools.
• Strong expertise in Informatica IDMC, particularly CDI and MI.
• Advanced knowledge in Snowflake, DB2, Oracle, and SQL Server.

Responsibilities

• Administer and maintain Informatica IDMC services.
• Implement load balancing and agent failover on Red Hat Linux.
• Manage Snowflake Data Cloud and CI/CD pipelines.

Skills

Informatica IDMC expertise

Data warehousing experience

Snowflake experience

Red Hat Linux administration

CI/CD automation

Power BI integration

IBM Mainframe experience

Education

Bachelor's degree in Computer Science or equivalent

Tools

Informatica PowerCenter

Jenkins

Git

Cognos

Job description

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