Informatica ETL Developer – Hybrid in Austin, TX (IICS, SQL, Snowflake)

We are seeking a highly experienced Informatica ETL Developer for a long-term hybrid role based in Austin, TX. If you’re a local candidate who excels in data integration, performance tuning, and end-to-end ETL pipeline development, this opportunity might be perfect for you. This project involves working with cutting-edge data technologies to drive reporting and analytics capabilities for an enterprise-level environment.

About the Informatica ETL Developer Role

In this position, you’ll design, develop, and manage scalable ETL solutions using Informatica IICS, IDMC, or PowerCenter. You’ll play a vital role in acquiring and transforming data from multiple sources such as Snowflake, Oracle, SQL Server, Access, and even unstructured formats like PDFs and Excel, preparing them for visual dashboards using Tableau.

This role is best suited for developers with a passion for data engineering, deep understanding of SQL scripting, and experience working within Agile sprint environments.

---

Key Responsibilities for Informatica ETL Developer

• Develop, optimize, and maintain ETL mappings and workflows using Informatica IICS or PowerCenter

• Automate data extraction, transformation, and loading from a wide array of sources including Snowflake, Oracle, SQL Server, Excel, Access, and PDF

• Support integration efforts with data visualization tools such as Tableau

• Write and tune complex SQL queries for large-scale data environments

• Collaborate with business analysts and data scientists to align pipeline outputs with reporting needs

• Troubleshoot and resolve issues related to data accuracy, transformation logic, and performance

• Contribute to Agile ceremonies and sprint deliverables, using tools like Jira

• Document technical designs using Visio, Erwin, or other modeling tools

• Create reusable scripts in Python where applicable

---

Required Skills and Experience for Informatica ETL Developer

• 8+ years of ETL development experience using Informatica IICS, IDMC, or PowerCenter

• Proficiency in handling structured and unstructured data across multiple platforms

• Advanced SQL development skills

• Strong knowledge of Snowflake, Oracle, and SQL Server

• Hands-on experience integrating data for Tableau dashboards

• Familiarity with Python scripting

• Experience working in Agile teams and tracking tasks with Jira

• Strong technical documentation and diagramming skills

• Ability to work across multiple organizational units and software platforms

---

Preferred Qualifications for Informatica ETL Developer

• Excellent verbal and written communication skills

• Bachelor’s degree in Computer Science, Information Systems, or equivalent experience

• Prior work with HHS agencies or in the healthcare domain

• Knowledge of security principles related to PII or PHI data

• Experience in Tableau dashboard development

• Familiarity with web technologies like HTML, CSS, JavaScript, and APIs

• Hands-on exposure to REST or SOAP-based Web Services

---

Work Model

• Hybrid: 2–3 days per week onsite in Austin, TX

• Duration: 12+ months with strong extension potential

• Type: Contract

• Only local candidates will be considered

---

Ready to Apply?

If you’re passionate about data transformation and ready to join a collaborative and technically strong team, don’t wait. Apply today using the link below.

👉 Check out other positions
👉 Let’s discuss your next career move

---

Frequently Asked Questions (FAQs) for Informatica ETL Developer

1. What ETL tools should I know for this role?
   You should be highly proficient in Informatica IICS, IDMC, or PowerCenter.

2. Is this a remote position?
   No. This is a hybrid role requiring 2–3 days per week onsite in Austin, TX.

3. What types of data sources will I work with?
   You’ll work with Snowflake, Oracle, SQL Server, Access, Excel, and Adobe PDFs.

4. Do I need Tableau experience?
   Yes. You should understand how to structure data for Tableau visualizations.

5. Is Python scripting mandatory?
   Python is preferred, especially for automation or custom data processing.

6. What is the duration of the contract?
   The contract is for 12+ months with a high possibility of extension.

7. What agile tools are used?
   Jira is used for sprint planning and tracking.

8. What types of diagrams should I be able to produce?
   Entity Relationship Diagrams (ERDs), data flow diagrams, and process flows using tools like Visio or Erwin.

9. Are there any compliance considerations?
   Yes. Familiarity with PII and PHI data handling is preferred.

10. Is this a client-facing role?
    No, but collaboration with business analysts and internal teams is essential.

11. Do I need to have healthcare domain experience?
    Healthcare or HHS experience is a plus but not mandatory.

12. Will I be required to design reports?
    You’ll prepare data for Tableau reports but not necessarily build them.

13. Are certifications required?
    Not required, but Informatica or Snowflake certifications can be a plus.

14. Is this position W2 or C2C?
    This will depend on the employer handling the contract. Clarify during the application.

15. How soon can I start?
    Interviews will begin immediately for eligible local candidates.