Data Warehouse Analyst
Pointwest-North America · Florida, United States · 3 mo ago
On-siteInformation TechnologyFull-time
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