13484 – Data Warehouse Analyst (onsite) – Tallahassee, FL
Start Date: ASAP
Type: Temporary Project
Estimated Duration: 6 months with possible extensions
Work Setting: 100% of the time at the Client’s site. No telecommuting or remote work. This is a non-negotiable requirement from the client
Required:
• Availability to work 100% of the time at the Client’s site in Tallahassee, FL (required);
• Experience in Data Warehousing and Data Integration (7 years)
• Experience designing, developing, and supporting ETL/ELT pipelines using Informatica Intelligent Data Management Cloud (IDMC) and Informatica on-prem solutions (4 years)
• Experience with data warehouse and data mart concepts
• Experience in modeling transactional data for data warehousing usage
• Experience with Snowflake cloud data warehouse functionality
• Experience with Informatica PowerCenter Cloud Platform
• Experience with Informatica Data Quality functionality
• Experience with Informatica Data Catalog functionality
• Experience with Power BI, Tableau, and other reporting tools functionality
• Experience with relational database platforms including DB2, SQL Server, and Oracle
• Experience converting legacy mainframe (JCL, COOLGEN, COBOL, FOCUS and WebFOCUS) code into modern, IDMC data integration workflows
Responsibilities include but are not limited to the following:
• Prototypes, builds, and tests extraction, transformation, and load (ETL or ELT) jobs
• Analyzes transactional data stores and develops data warehouse models to optimize the warehouse data stores for reporting and analytics
• Creates designs, diagrams, and documents to support data integration and data warehouse solutions
• Ensures data warehouse metadata is collected and maintained
• Coaches and mentors peers in data warehousing concepts and the use of the tools utilized to analyze data, design the warehouse models, and populate the warehouse.
• Assists with the development and maintenance of methods and practices documentation.
• Collaborates with business and analytics teams to gather requirements and ensure data warehouse and ETL/ELT solutions effectively support reporting and decision-making needs.