Informatica Developer

HonorVet Technologies. We're a veteran-owned IT staffing firm, ISO 9001 and ISO 27001 certified, working with federal agencies, state governments, and Fortune 500 enterprise clients across the US. What makes us different isn't a tagline; it's the way we work. We don't forward resumes and hope for the best. We take the time to understand where a professional like you is headed and only reach out when we genuinely believe there's a fit worth exploring.

Title: Informatica Developer / Data Engineer
Location: Austin, Texas (Hybrid) - 2 Days Remote
Duration: 12 Months Contract
Candidates must already reside in Texas
Position Overview:

• Client is seeking a Senior Informatica Developer / Data Engineer to support the Performance Management & Analytics System (PMAS).
• The selected candidate will be responsible for designing, developing, and maintaining enterprise-level ETL and data integration solutions. This role involves working with large datasets from multiple systems, building automated data pipelines, developing Snowflake SQL solutions, and supporting reporting and analytics initiatives.
• The ideal candidate should have strong experience in Informatica PowerCenter/IICS, Snowflake, ETL development, data warehousing, and Agile environments.

Key Responsibilities:

• Design and develop ETL mappings and workflows using Informatica PowerCenter/IICS
• Integrate data from multiple data sources including Oracle, SQL Server, Excel, Access, and PDF files
• Develop complex and optimized Snowflake SQL scripts
• Build and maintain enterprise data warehouse solutions
• Support Tableau reporting and analytics environments
• Create views and materialized views in Oracle databases
• Perform data validation, testing, and troubleshooting
• Participate in Agile sprint ceremonies and SDLC activities
• Collaborate with architects, developers, and data engineering teams
• Prepare technical documentation, data mappings, and design diagrams
• Support deployment activities and ongoing system enhancements

Required Skills & Experience:

• 8+ years of experience with Informatica PowerCenter or IICS
• Strong ETL and Data Warehousing experience
• Strong experience with Snowflake SQL development
• Experience integrating data from multiple technologies and platforms
• Excellent analytical and problem-solving skills
• Experience with Visio, Erwin, MS Office Suite, and MS Project
• Experience delivering enterprise-level data solutions
• Strong understanding of software development best practices

Preferred Skills:

• Agile/Scrum experience
• Healthcare or government project experience
• Experience handling PII/PHI data
• Python scripting experience
• JIRA experience
• Knowledge of REST/SOAP Web Services
• Java or JavaScript experience
• GitHub and CI/CD pipeline experience
• MuleSoft experience
• Experience with AI tools such as Snowflake Cortex or Informatica Claire