Data Warehouse Analyst

Pointwest-North America

Orlando (FL)

On-site

USD 87,280 - 130,920

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Pointwest-North America is looking for a Data Warehouse Analyst to enhance the Informatica Intelligent Data Management Cloud platform. Key responsibilities include platform maintenance, performance tuning, and collaborating with teams for data integration. The ideal candidate has over 7 years of experience in IT, specifically in data warehousing and business intelligence tools.

Qualifications

Minimum 7 years of IT experience in data warehousing and business intelligence.
Bachelor's degree in Computer Science or equivalent work experience.
Strong expertise in Informatica IDMC and data integration tools.

Responsibilities

Administer and maintain Informatica IDMC services.
Implement and manage CI/CD pipelines using Git and Jenkins.
Perform platform health checks and troubleshooting.

Skills

Informatica IDMC

Snowflake

Red Hat Linux

Data integration

ETL/ELT

Power BI

Cognos

COBOL

JCL

DB2

Education

Bachelor's degree in Computer Science

Tools

Informatica PowerCenter

Jenkins

Git

Job description

Join to apply for the Data Warehouse Analyst role at Pointwest-North America

1 day ago Be among the first 25 applicants

Join to apply for the Data Warehouse Analyst role at Pointwest-North America

Get AI-powered advice on this job and more exclusive features.

Description

We are recruiting for our client. Pointwest is seeking a highly skilled

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: