Primary Responsibilities

• Build workflows and automation using Informatica IICS/PowerCenter.
• Develop complex SQL scripts for data transformation and validation.
• Integrate data from Oracle, Snowflake, SQL Server, Excel, and PDFs.
• Create scripts for testing, validation, and automation.
• Design test plans, validate data pipelines, and track defects.
• Maintain technical specs, diagrams, and system documentation.
• Participate in Agile ceremonies and collaborate with cross-functional teams.
• Enable Tableau dashboards via curated datasets and a Java-based portal.

Additional Responsibilities

• Participate in all Agile SDLC phases, including data acquisition, transformation, and validation.
• Develop and automate data pipelines using Informatica and complex SQL scripts.
• Enhance and maintain a Java-based dashboard portal for Tableau visualization.
• Collaborate with the Data Engineering Team on optimal data design and architecture.
• Support operations and enhancement of the HHS Data Integration Hub.

Required Skills (8+ Years)

• Expertise in Informatica IICS, PowerCenter, or IDMC.
• Advanced SQL scripting and performance tuning.
• Experience with data integration from multiple sources.
• Proficient in Python for automation.
• Experience in data analysis, QA, and test planning.
• Technical documentation skills (Visio, Erwin, MS Office).
• Agile development experience with defect tracking.

Posted By