Job/Position Title | Data Warehouse Analyst C. Advanced |
Resume Type | Actual |
Place of Performance | Work Hours Flexibility to work hours between 7:00 AM & 7:00 PM and/or Saturdays either on a rotation or as part of a regular and on-call work schedule. Barry Building 3185 S. Blair Stone Rd Tallahassee FL 32301 |
Term of Contract | Term: The contract term for this Staff Augmentation position is intended to be ASAP - 06/30/2026 |
Education:
Bachelors Degree in Computer Science Information Systems or other related field. Or equivalent work experience.
Experience:
A minimum of 7 years of IT work experience utilizing data management tools business intelligence tools and data warehousing. Extensive experience with Informatica PowerCenter and Snowflake is preferred.
Primary Job Duties/ Tasks:
- Strong Data Integration and Data Warehousing experience with Informatica IDMC tools (IDMC tools like IDMC CDI MI CAI etc..)
- Strong Experience with Data Integration tasks like extraction transformation and load (ETL or ELT) tasks
- Experience administering IDMC platform Secure Agent Infrastructure and Snowflake Data Cloud platform for statewide adoption
- Knowledge of and skill in relational database platforms including DB2 SQL Server Snowflake and Oracle
- Analyzes transactional data stores and develops data warehouse models to optimize the warehouse for reporting and analytics.
- Experience with Redhat Linux application administration like security patching applications managing disk filesystems managing wrapper and auto-startup scripts.
- Strong Experience with IDMC Connectors to perform Change Data Capture solutions like PowerExchange and other widely used connectors like relational ServiceNow etc.
- Assists with the development and maintenance of methods and practices documentation.
- Experience with IBM Mainframes COBOL JCL and DB2 analysis.
Job Specific Knowledge Skills and Abilities (KSAs):
- Experience designing data models for Business Intelligence tools like Power BI and Cognos.
- Experience with Informatica on-premises products like PowerCenter and Data Quality.
- Strong development experience with Snowflake Data Cloud
- Prototypes builds and tests Power BI and Cognos reports/dashboards.
- Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration.
- Ensures data warehouse metadata is collected and maintained.
- Experience with Informatica IDMC Cloud Performance Tuning
- Experience with Snowflake Data Cloud Performance Tuning.