Data Warehouse Analyst

About the Role

Key Responsibilities

• Administer and maintain Informatica IDMC services including Administrator, Data Integration, Data Quality, Data Profiling, Application Integration, and API Center.
• Deploy, configure, and upgrade Informatica Secure Agents on Red Hat Enterprise Linux (RHEL) servers, implementing agent failover, load balancing, and managing cipher suites and secure communications (TLS/SSL).
• Establish and utilize CI/CD pipelines (e.g., Git, Jenkins) for deployment of mappings, tasks, processes, and assets across multiple IDMC organizations.
• Maintain and configure platform connections, secure credentials, and optimize agent parameter tuning for performance and resource utilization.
• Manage SSO administration with SAML-based user access, roles, and security policies to ensure compliance with organizational standards and data governance.
• Coordinate with infrastructure, security, and data teams to implement best practices in platform operations and administration.
• Monitor environment performance, identify issues, troubleshoot failures, and perform root cause analysis for environment errors or bottlenecks.
• Maintain logs, perform root cause analysis, and oversee scheduling, notifications, and platform performance metrics to proactively manage SLAs.
• Perform ongoing Secure Agent health checks, configure log rotation, and manage patching processes using CLI and shell scripting on RHEL.
• Provide platform support for Cloud Data Integration, Cloud Application Integration, and Cloud Data Quality services, including upgrades and patches.
• Work closely with data engineering and business teams to enable development and deployment of pipelines and workflows.
• Stay current with Informatica Cloud platform enhancements, new features, and industry best practices to recommend improvements.

Requirements

• Bachelor's Degree in Computer Science, Information Systems, or related field, or equivalent work experience.
• Minimum of 7 years of IT work experience utilizing data management tools, business intelligence tools, and data warehousing.
• Extensive experience with Informatica PowerCenter and Snowflake is preferred.
• Experience designing data models for Business Intelligence tools like Power BI and Cognos.
• Experience with Informatica on-premises products like PowerCenter and Data Quality.
• Strong development experience with Snowflake Data Cloud.
• Prototypes, builds, and tests Power BI and Cognos reports/dashboards.
• Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration.
• Knowledge of and skill in relational database platforms including DB2, SQL Server, Snowflake, and Oracle.
• Experience analyzing transactional data stores and developing data warehouse models for reporting and analytics.
• Experience with Red Hat Linux application administration, including security patching, managing disk filesystems, and startup scripts.
• Strong experience with IDMC Connectors for Change Data Capture solutions like PowerExchange and relational connectors.
• Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.

Nice to Have

• Experience with Informatica IDMC Cloud Performance Tuning.
• Experience with Snowflake Data Cloud Performance Tuning.
• Experience administering Snowflake Data Cloud platform for statewide adoption.

Qualifications

• Educational background as specified in requirements.
• Relevant professional experience as specified in requirements.

Benefits & Perks

• Not explicitly specified in the description.