Senior Data Warehouse Analyst

About the Role

Key Responsibilities

• Responsible for administration and maintaining Informatica IDMC services including Administrator, Data Integration, Data Quality, Data Profiling, Application Integration, and API Center, ensuring platform stability and optimal configuration across projects.
• Deploy, configure, and upgrade Informatica Secure Agents on Red Hat Enterprise Linux (RHEL) servers; implement agent failover, load balancing, and manage cipher suites and secure communications (TLS/SSL).
• Establish and utilize CI/CD pipelines (e.g., Git, Jenkins) for deployment of mappings, tasks, processes, and other assets across multiple IDMC organizations.
• Maintain and configure platform connections, secure credentials, and secure agent parameter tuning for optimal performance and resource utilization.
• Manage SSO administration with SAML based user access, roles, and security policies, ensuring compliance with organizational standards and data governance requirements.
• Coordinate with infrastructure, security, and data teams to implement best practices in platform operations and administration.
• Monitor environment performance, identify issues, and work with development teams to troubleshoot and resolve failures.
• Maintain logs and perform root cause analysis for environment errors or performance bottlenecks.
• Oversee scheduling, notifications, and platform performance metrics to proactively manage SLAs.
• Perform ongoing Secure Agent health checks, configure log rotation, integrate with enterprise tools, 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 agent upgrades, patches, and coordination with Informatica support.
• Work closely with data engineering and business teams to enable seamless development and deployment of pipelines and workflows.
• Stay current with Informatica Cloud platform enhancements, new features, and industry best practices to recommend improvements in performance, automation, and scalability of the data integration infrastructure.

Requirements

• Bachelor's Degree in Computer Science, Information Systems, or other related field, or equivalent work experience.
• A 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.
• Strong Data Integration and Data Warehousing experience with Informatica IDMC tools (IDMC CDI, MI, CAI, etc.).
• Experience with extraction, transformation, and load (ETL or ELT) tasks.
• Experience administering IDMC platform, Secure Agent Infrastructure, and Snowflake Data Cloud platform.
• Knowledge of relational database platforms including DB2, SQL Server, Snowflake, and Oracle.
• Experience with Red Hat Linux application administration, including security patching, managing disk filesystems, and managing wrapper and auto-startup scripts.
• Experience with IDMC Connectors for Change Data Capture solutions like PowerExchange and other connectors such as relational, ServiceNow, etc.
• Experience with IBM Mainframes COBOL, JCL, and DB2 analysis.

Nice to Have

• Experience designing data models for Business Intelligence tools like Power BI and Cognos.
• Strong development experience with Snowflake Data Cloud.
• Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration.
• Experience with IDMC Cloud Performance Tuning and Snowflake Data Cloud Performance Tuning.

Qualifications

• Bachelor's Degree in Computer Science, Information Systems, or related field, or equivalent work experience.

Benefits & Perks

• Work hours are flexible between 7:00 AM & 7:00 PM and/or Saturdays.
• In-office work five days a week in Tallahassee, FL.
• No telecommuting or relocation expenses covered.