Informatica ETL Developer – Hybrid in Austin, TX (IICS, SQL, Snow...
Rishi Writes - Austin, Texas, us, 78716
Work at Rishi Writes
Overview
- View job
Overview
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
What ETL tools should I know for this role?
You should be highly proficient in Informatica IICS, IDMC, or PowerCenter.
Is this a remote position?
No. This is a hybrid role requiring 2–3 days per week onsite in Austin, TX.
What types of data sources will I work with?
You’ll work with Snowflake, Oracle, SQL Server, Access, Excel, and Adobe PDFs.
Do I need Tableau experience?
Yes. You should understand how to structure data for Tableau visualizations.
Is Python scripting mandatory?
Python is preferred, especially for automation or custom data processing.
What is the duration of the contract?
The contract is for 12+ months with a high possibility of extension.
What agile tools are used?
Jira is used for sprint planning and tracking.
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.
Are there any compliance considerations?
Yes. Familiarity with PII and PHI data handling is preferred.
Is this a client-facing role?
No, but collaboration with business analysts and internal teams is essential.
Do I need to have healthcare domain experience?
Healthcare or HHS experience is a plus but not mandatory.
Will I be required to design reports?
You’ll prepare data for Tableau reports but not necessarily build them.
Are certifications required?
Not required, but Informatica or Snowflake certifications can be a plus.
Is this position W2 or C2C?
This will depend on the employer handling the contract. Clarify during the application.
How soon can I start?
Interviews will begin immediately for eligible local candidates.
#J-18808-Ljbffr