ETL / INFORMATICA Developer

ALIS Software

Austin, TX, United States

8 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

4 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Agile Methodology Airflow Amazon Web Services Microsoft Azure Cloud Database Data Governance Extract Transform Load (ETL) Data Transformation Data Warehousing Database Queries Python (Programming Language) Meta-Data Management

+13 more

Performance Tuning Scrum Methodology Workflow Management Systems Data Processing Freeform SQL Google Cloud Sql Optimization Snowflake Informatica Cloud Integration Frameworks Terraform Data Pipelines Api Management

Job description

Design, develop, and maintain ETL/ELT pipelines using Informatica Cloud (IICS).
Build, optimize, and manage data models and data warehousing solutions in Snowflake.
Write efficient and complex SQL queries for data transformation, analysis, and performance tuning.
Collaborate with data architects, analysts, and business stakeholders to understand data requirements.
Ensure data quality, governance, and reliability across all data pipelines.
Develop reusable data frameworks, automation processes, and workflow orchestration.
Monitor data pipelines, troubleshoot issues, and implement performance improvements.
Contribute to Agile teams by supporting sprint planning, backlog grooming, and release cycles.

Requirements

4-8+ years of hands-on experience as a Data Engineer.
Strong expertise in IICS (mappings, tasks, parameterization, scheduling).
Proficient in Snowflake (warehouses, stages, SnowSQL, task/stream pipelines).
Advanced SQL skills with experience in writing complex queries and optimizing performance.
Strong understanding of ETL/ELT design, data warehousing concepts, and cloud-based data architecture.
Experience working with cloud platforms (AWS, Azure, or Google Cloud Platform).

Preferred Skills:

Experience with Python for automation or data processing.
Familiarity with Terraform, DBT, Airflow, or other orchestration/automation tools.
Knowledge of API integrations and real-time/streaming solutions.
Experience with data governance, data quality frameworks, and metadata management.