Data Warehouse Analyst

Pointwest Technologies Corp; Tallahassee (FL); On-site; USD 90,000 - 120,000; Full time

Job summary

Pointwest Technologies Corp is looking for a highly skilled Data Warehouse Analyst in Tallahassee, Florida. In this role, you will support the administration and optimization of the Informatica Intelligent Data Management Cloud (IDMC) platform. Key responsibilities include platform configuration, performance tuning, data integration tasks, and support for enterprise initiatives using Snowflake. The ideal candidate will have at least 7 years of experience in IT with strong expertise in data warehousing and business intelligence tools.

Qualifications

• Minimum 7 years in IT using data warehousing, business intelligence, and data integration tools.
• Strong expertise in Informatica IDMC (CDI, MI, CAI).
• Advanced knowledge of Snowflake, DB2, Oracle, and SQL Server.

Responsibilities

• Administer and maintain Informatica IDMC services.
• Implement load balancing, agent failover, secure communications (TLS/SSL).
• Maintain CI/CD pipelines for deployments.

Skills

Informatica IDMC

Data Warehousing

Snowflake

Red Hat Linux

CI/CD pipelines

SQL

Power BI

IBM Mainframe

Education

Bachelor's degree in Computer Science, Information Systems or equivalent

Tools

Git

Jenkins

DB2

Cognos

Job description

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 (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