ETL/Data Integration Specialist

Techvilla Solutions

Austin, TX

Posted On: Jul 10, 2025

Posted On: Jul 10, 2025

Job Overview

Job Type

Contract - W2, Contract - Independent, Contract - Corp-to-Corp

Experience

8 - 18 Years

Salary

Depends on Experience

Work Arrangement

Hybrid

Travel Requirement

0%

Required Skills

  • Informatica IICS
  • PowerCenter
  • IDMC
  • data analysis
  • Python
  • automation
  • SQL
Job Description
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.

Job ID: TS250212


Posted By

Vivek

Information Technology Recruiter