Data Warehouse Analyst

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)

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), 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