P logo

Data Warehouse Analyst

Pointwest Technologies CorpTallahasee, FL

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.1

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

pay-wall

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

Powered by JazzHR

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

pay-wall

FAQs About Data Warehouse Analyst Jobs at Pointwest Technologies Corp

What is the work location for this position at Pointwest Technologies Corp?
This job at Pointwest Technologies Corp is located in Tallahasee, FL, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
What pay range can candidates expect for this role at Pointwest Technologies Corp?
Employer has not shared pay details for this role.
What employment applies to this position at Pointwest Technologies Corp?
The employer has not provided this information. This may be discussed during the hiring process.
What is the process to apply for this position at Pointwest Technologies Corp?
You can apply for this role at Pointwest Technologies Corp either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.