Sign upLog in

Data Warehouse Analyst

Pointwest Technologies Corp

Tallahasee, FL

Apply
JOB DETAILS
JOB TYPE
Full-time
SKILLS
Administrative Skills, Automation, Best Practices, Business Intelligence, Cloud Computing, Cobol Programming Language, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Data Analysis, Data Collection, Data Management, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Disk Management, Enterprise Data Integration, Failover, File Systems, Git, IBM Cognos, IBM DB2, IBM Mainframe, Identify Issues, Informatica, Information Technology & Information Systems, JCL (Job Control Language), Jenkins, Linux Administration, Load Balancing, Microsoft SQL Server, Oracle Database, Performance Tuning/Optimization, Power BI, Red Hat Linux Operating System, Reporting Dashboards, SSL-TLS (Secure Socket Layer - Transport Layer Security), Scripting (Scripting Languages), Security Assertion Markup Language (SAML), Security Infrastructure, ServiceNow, Single Sign-On (SSO), Snowflake Schema, Software Patches, Systems Administration/Management
LOCATION
Tallahasee, FL
POSTED
30+ days ago

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

Powered by JazzHR

About the Company

P

Pointwest Technologies Corp

Resume Resources

Free Resume TemplatesFree Resume Builder