

Data WH Analyst Consultant
β - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data WH Analyst Consultant on a one-year contract, requiring US citizenship. Key skills include strong data integration and warehousing experience with Informatica IDMC tools, Snowflake, and relational databases. Experience with BI tools and Linux administration is essential.
π - Country
United States
π± - Currency
$ USD
-
π° - Day rate
680
-
ποΈ - Date discovered
July 16, 2025
π - Project duration
More than 6 months
-
ποΈ - Location type
Unknown
-
π - Contract type
Unknown
-
π - Security clearance
Unknown
-
π - Location detailed
Tallahassee, FL
-
π§ - Skills detailed
#Informatica #Security #Data Quality #Linux #Metadata #Oracle #Cloud #SQL (Structured Query Language) #Microsoft Power BI #Data Integration #SQL Server #"ETL (Extract #Transform #Load)" #Snowflake #JCL (Job Control Language) #Data Warehouse #BI (Business Intelligence) #Documentation
Role description
Heading 1
Heading 2
Heading 3
Heading 4
Heading 5
Heading 6
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
- Item 1
- Item 2
- Item 3
Unordered list
- Item A
- Item B
- Item C
Bold text
Emphasis
Superscript
Subscript
ONE YEAR CONTRACT WITH POSSIBLE EXTENSION
US CITIZEN REQUIRED
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.
Experience:
1. Experience designing data models for Business Intelligence tools like Power BI and Cognos.
2. Experience with Informatica on-premises products like PowerCenter and Data Quality.
3. Strong development experience with Snowflake Data Cloud
4. Prototypes, builds and tests Power BI and Cognos reports/dashboards.
5. Experience with IDMC Cloud Administration and Snowflake Data Cloud Administration.
6. Ensures data warehouse metadata is collected and maintained.
Experience with Informatica IDMC Cloud Performance Tuning
Experience with Snowflake Data Cloud Performance Tuning #Workwolf