PR788787-R156826 Data Warehouse Analyst – Advanced (Informatica IDMC)
Sansar Tec is recruiting for our client, The Florida Department of Transportation (FDOT). We are 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
Requirements
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
Average salary estimate
If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.
Experienced Data Warehouse Analyst needed to administer and optimize Informatica IDMC and enterprise data platforms at the Florida Department of Transportation.
Experienced Senior Database Engineer needed to design, deploy, and optimize large-scale PostgreSQL environments for a top-tier defense and technology consulting firm in Huntsville, AL.
Socket requires a detail-oriented Network Design Specialist to develop GIS maps and support fiber installation planning from their Columbia, Missouri office.
Lead Azure Data Factory projects and teams building scalable data integration and ETL solutions at Dentsu in a fully remote role based in Ohio.
Experienced Senior Data Engineer needed to drive legal data platform initiatives using Microsoft Fabric and Azure services at Epiq.
Senior Data Engineer to design and develop advanced Azure cloud data solutions for SMBC Group's financial services operations.
Contribute to clinical trial success by managing and optimizing clinical data systems at the forefront biopharma company, AbbVie.
Spotify is seeking a skilled Analytics Engineer to develop scalable data models and pipelines that support Trust & Safety operations, regulatory compliance, and internal analytics.
Innovative Staff Data Engineer role at Palo Alto Networks focusing on AI/ML-driven data solutions to revolutionize cybersecurity.
Drive enterprise data architecture and governance at IDB Bank as a Principal Data Architect, shaping data strategies that empower business transformation.
PrizePicks is looking for an Analytics Engineer to build and optimize data transformation pipelines and models that power business analytics and decision-making.
Huntress is looking for a Vice President of Data and Business Intelligence to lead enterprise-wide data strategy and advanced analytics initiatives, enabling key business decisions through actionable insights.
Okta seeks a seasoned Data Architect to enhance their data architecture and governance strategy across multiple office locations in a hybrid work environment.
Innovative healthcare company seeks an experienced VP of Data & Technology to architect and lead a cutting-edge data platform that transforms value-based care for individuals with serious mental illness.
🔮
Hi, I'm Risa! Your AI Career Copilot
you, just ask me below!
