ON SITE in TALLAHASSEE
Contract Senior Data Integration & Warehousing Engineer
We are seeking a seasoned Data Integration & Warehousing Engineer with at least 7+ years of IT experience, specializing in data management, business intelligence, and enterprise-scale data warehousing. The ideal candidate brings strong expertise in Informatica PowerCenter, Informatica IDMC, and Snowflake.
Key Responsibilities:
Lead ETL/ELT development using Informatica IDMC (CDI, CAI, MI)
Administer IDMC Secure Agent and Snowflake platforms
Manage and optimize data integration pipelines, including Change Data Capture (CDC) with PowerExchange
Analyze legacy data systems (e.g., COBOL, JCL, DB2 on IBM Mainframes) and design optimized data warehouse models
Support Red Hat Linux-based system administration for data applications
Develop and maintain documentation for data methods and best practices
Preferred Skills & Experience:
Proficient in relational databases: DB2, SQL Server, Oracle, and Snowflake
Hands-on with Power BI and Cognos dashboard/report design
Experience with Informatica on-prem tools (PowerCenter, Data Quality)
Skilled in Snowflake development and performance tuning
Familiarity with IDMC cloud performance optimization and system scaling
Experience with data warehouse metadata management and modeling for BI