ETL Developer (Informatica)

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

Informatica
Data Warehouse
Data Visualization
ERwin
Data Integration
Data Engineering
Data Analysis
Modeling
Information Systems

Job Details

Job Description
Seeks an experienced Systems Analyst 3 (ETL Developer) to support the development, implementation, and maintenance of the HHS Data Integration Hub. The role involves analyzing business needs, designing efficient solutions, and collaborating with cross-functional teams using agile methodologies.
The selected candidate will work closely with architects, developers, and business stakeholders to automate data acquisition, transform and integrate data from multiple sources, and support data visualization and reporting initiatives using Tableau, Informatica, and SQL.
Key Responsibilities
Analyze business requirements, identify solutions, and create detailed system specifications.
Design, develop, and automate ETL processes using Informatica IICS, IDMC, or PowerCenter.
Acquire and integrate data from various sources (Snowflake, Oracle, SQL Server, Excel, Access, Adobe PDF).
Develop complex SQL scripts for data transformation and integration into dimensional models.
Build automation processes for verification and validation of SQL scripts and ETL workflows.
Participate in agile ceremonies (planning, reviews, stand-ups, retrospectives).
Collaborate with Data Engineering Team to optimize data models and integration strategies.
Maintain and enhance a Java-based web application delivering Tableau dashboards to multiple user roles.
Create mockups, gather feedback, and refine solutions based on stakeholder validation.
Develop and maintain technical documentation (specifications, diagrams, process flows).
Support configuration and implementation of development tools and environments.
Participate in requirements gathering, design sessions, and change impact analysis.
Ensure compliance with security standards, especially regarding PII/PHI data.
Minimum Qualifications
8+ years of experience developing ETL processes with Informatica IICS, IDMC, or PowerCenter.
8+ years of experience acquiring and integrating data from multiple sources (Snowflake, Oracle, SQL Server, Excel, Access, Adobe PDF) for use in Tableau.
8+ years of experience writing and optimizing complex SQL scripts.
8+ years of experience as a Systems Analyst for data analytics, performance management, or data warehousing projects.
8+ years of experience with technical writing, diagramming, and modeling (Visio, Erwin, MS Office Suite).
8+ years of experience in software platform planning and delivery across multiple organizational units.
8+ years of experience developing Python scripts.
8+ years of experience on agile sprint teams using JIRA.
Preferred Qualifications
Excellent oral and written communication skills.
Experience writing well-designed, testable, efficient code using best practices.
Understanding of security principles related to healthcare data.
Experience with data visualization and business intelligence environments.
Ability to manage multiple priorities in a dynamic environment.
Bachelor s degree in Computer Science, Information Systems, or Business (or equivalent experience).
Experience in Healthcare Industry or prior work with HHS agencies.
Experience handling PII/PHI data.
Hands-on experience with Web Applications and programming (HTML, CSS, JavaScript, JQuery, APIs).
Experience with REST/SOAP Web Services.
Experience developing dashboards and reports using Tableau.
please share resume to

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Nueve Solutions, LLC