Job Title: Data Warehouse Analyst
Location: Tallahassee, FL 32301
Duration: 12 Months
Job Description:
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.
Required Skills
Education:
Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.
Location: Tallahassee, FL 32301
Duration: 12 Months
Job Description:
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.
Required Skills
- 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.
Education:
Bachelor's Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.