JOBSEARCHER

Informatica Data Engineer

ARCHIVED
GtsAustin, TXL6 LeadSeptember 11th, 2026

We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.

Title: Informatica Data Engineer
Location: Austin Texas 78701 - Hybrid
Engagement Type: Full-time long-term contract, with renewal potential through 2030
Pay Rate: $70/hr, W2Schedule: Monday-Friday, 8:00 AM-5:00 PM, with occasional evening/weekend/holiday work by advance request
Work Authorization: Must be authorized to work in the United States on a full-time, ongoing basis without the need for employer sponsorship now or in the future.
Background Check: Must pass a criminal background check upon hire
About the Role: We're looking for an Informatica Data Engineer to join a long-term, contract supporting a Texas state government client. In this role, you'll design and build data pipelines using Informatica Cloud (IICS), move data from Oracle databases into Snowflake, and help shape how a growing Snowflake data warehouse is structured and used for reporting.
What You'll Do:
  • Build ETL/ELT data mappings and workflows in Informatica Cloud Data Integration
  • Design and build Informatica Mass Ingestion pipelines for high-volume data loads
  • Connect Oracle databases as data sources and build reliable, high-performing pipelines into Snowflake
  • Design Snowflake data lake and data warehouse structures, including dimensional modeling (facts and dimensions)
  • Build and maintain Change Data Capture (CDC) processes for ongoing bulk data movement
  • Apply Informatica push-down optimization techniques to improve pipeline performance
  • Write clean, efficient Snowflake SQLCreate clear technical documentation for pipelines and interfaces on a multi-phase, multi-release project
  • Review teammates' work, troubleshoot issues, and help the team meet tight deadlines
  • Promote code from development environments to production
  • Use GitHub (or an equivalent) for version control
What You Bring 5+ years writing advanced SQL and performing hands-on data analysis 6+ years working with Informatica products, including 4+ years specifically in Informatica Cloud Data Integration (IICS)5+ years translating business requirements into data mappings and pipeline designs 4+ years in relational database design, including direct Oracle experience 3+ years with data warehouse architecture, including Facts/Dimensions modeling 3+ years building static mappings and CDC processes for bulk data movement 2+ years with Informatica Mass Ingestion 2+ years creating, managing, and optimizing Snowflake databases, including time travel and related features
Nice to have: Exposure to Snowpark, Python, or supporting Data Scientist workflows against SnowflakeGTS Technology Solutions, Inc. is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all applicants and employees without regard to race, color, religion, sex, national origin, age, disability, genetic information, or any other protected status in accordance with applicable federal, state, and local laws. As part of our hiring process, we conduct background checks on all final candidates. These checks are conducted in compliance with the guidelines set forth by the U.S. Equal Employment Opportunity Commission (EEOC). We ensure that the information obtained from background checks is used fairly and does not unlawfully discriminate against any individual. GTS Technology Solutions participates in E-Verify to confirm the employment eligibility of all newly hired employees. If you are offered a position with GTS Technology Solutions, your employment will be contingent upon successful verification of your identity and legal authorization to work in the United States through E-Verify. For more information about E-Verify, please visit E-Verify's official website.