Description

You will build and optimize data integration workflows for a Health and Human Services data platform.

This role is hybrid.

Responsibilities

• Develop and optimize ETL workflows using Informatica IICS, IDMC, and PowerCenter.
• Integrate data from Snowflake, Oracle, SQL Server, Excel, Access, and PDFs.
• Build and tune advanced Oracle SQL scripts, including views and materialized views.
• Write Python scripts to automate testing and streamline data processes.
• Maintain and enhance the Java-based site powering Tableau dashboards.

Required Skills

• 8+ years of experience in ETL development and data integration.
• Proficiency with Informatica suite (IICS, IDMC, PowerCenter).
• Advanced Oracle SQL scripting capabilities.
• Experience with Snowflake, SQL Server, Excel, and Access.
• Python for data validation and automation.
• Java for web-based site maintenance.
• Data modeling and documentation using Visio or Erwin.
• QA test planning, execution, and defect tracking.

Preferred Skills

• 4+ years contributing to automation frameworks and test coverage.
• 2+ years building automated regression and functional test suites.
• 2+ years working on AI platforms or validating AI-integrated products.

Key Skills

Education

Any Gradute