Senior Informatica and Snowflake Data Engineer

Location: Hybrid in Austin, TX, United States

Company

hirify.global is a technology and professional services firm specializing in innovative technologies and nationwide technology management services.

What you will do

• Develop and maintain Informatica PowerCenter mappings, sessions, workflows, and reusable transformations.
• Ingest data from flat files, APIs, relational databases, and mainframe extracts into Oracle databases.
• Develop cloud-based ETL/ELT solutions using Informatica Cloud Data Integration.
• Load data into Snowflake and support schema design and query performance optimization.
• Troubleshoot data quality issues, job failures, and performance bottlenecks in production pipelines.
• Gather requirements, create source-to-target mappings, document data flows, and collaborate with business and technical stakeholders.

Requirements

• 8+ years of experience designing, developing, and supporting enterprise data integration solutions.
• 8+ years of hands-on Informatica PowerCenter experience, including cloud-based ETL/ELT development.
• 8+ years of Oracle SQL/PL-SQL experience, including stored procedures, packages, and performance tuning.
• 8+ years of Snowflake experience, including data loading, schema design, and query optimization.
• Experience with data requirements, source-to-target mapping, design documentation, production troubleshooting, and data quality issues.
• Experience with Control-M, Autosys, or the Informatica scheduler for batch data loads; strong communication and collaboration skills.

Nice to have

• Experience with SAP Business Objects Universe design or maintenance.
• Experience in state government or large enterprise IT environments.
• Experience with formal SDLC and change management processes.

Culture & Benefits

• Hybrid work arrangement in Austin, Texas.
• Structured SDLC and formal change management environment.
• Competitive salary.
• Collaborative work across business and technical teams.