Senior Informatica ETL/Data Engineer (Snowflake, Oracle)

Allied Consultants, Inc.; Austin (TX); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

Life insurance

401(K) plan with company match

Flexible spending through cafeteria

Job summary

Allied Consultants, Inc. is seeking an Informatica ETL/Data Engineer in Austin with 8+ years of experience to design, develop, and support enterprise data integration solutions.

The role emphasizes Informatica PowerCenter, Snowflake, and Oracle SQL/PLSQL, with strong SDLC collaboration and production support. You will work with a high-impact technical services team, focusing on data ingestion from diverse sources, performance tuning, and batch scheduling in a large enterprise environment.

Qualifications

• Eight years of experience designing, developing, and supporting enterprise data integration solutions.
• Hands-on with Informatica PowerCenter, mappings, sessions, workflows, and reusable transformations.
• Experience ingesting data from multiple heterogeneous sources into Oracle databases.
• Strong Oracle SQL/PL-SQL and performance tuning for ETL queries.
• Snowflake data loading, schema design, and query optimization.
• Experience with Informatica Cloud Data Integration for cloud-based ETL/ELT development.
• Gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications.
• Troubleshooting data quality issues, job failures, and production ETL bottlenecks.
• Experience with batch data loads using scheduling tools (Control-M, Autosys, Informatica scheduler).
• Preferred: SAP BO Universe design/maintenance
• Experience in state government or large enterprise IT environments (SDLC/change management).

Responsibilities

• Understand business objectives and problems to propose automated data solutions.
• Analyze requirements and design ETL workflows and data mappings.
• Develop and maintain enterprise ETL/ELT pipelines.
• Collaborate with stakeholders to deliver scalable data engineering solutions.
• Provide production support and optimize job performance.

Skills

Analytical skills

Communication skills

Data integration design

Tools

Informatica PowerCenter

Informatica Cloud Data Integration

Snowflake

Oracle SQL/PLSQL

Control-M

Autosys

Informatica Scheduler

SAP Business Objects Universe

Job description

Allied Consultants, Inc. is seeking an Informatica ETL/Data Engineer in Austin with 8+ years of experience to design, develop, and support enterprise data integration solutions.

The role emphasizes Informatica PowerCenter, Snowflake, and Oracle SQL/PLSQL, with strong SDLC collaboration and production support. You will work with a high-impact technical services team, focusing on data ingestion from diverse sources, performance tuning, and batch scheduling in a large enterprise environment.