> Markdown version of [/jobs/ext/3546416-informatica-developer](https://www.wearedevelopers.com/jobs/ext/3546416-informatica-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Informatica Developer

- **Company:** Innovity Incorporated
- **Location:** Des Moines, IA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Agile Methodology, Amazon Web Services, Amazon S3, Data Analysis, JIRA, Microsoft Azure, Big Data, Cloud Computing, Databases, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Migration, Data Warehousing, Database Theory, Linux, Data Intelligence, PostgreSQL, Microsoft SQL Server, MySQL, Oracle (Applications), Standard Sql, Shell Script, SQL Stored Procedures, SQL Databases, Data Streaming, Data Logging, Network Routers, Informatica Powercenter, Snowflake, Informatica Cloud, Git, Star Schema, Data Management, Jenkins, Databricks
- **Published:** September 30, 2026
- **Apply:** https://www.careerjet.com/jobad/use18f0eb0c6bc018eca04c7533bc58d2f

## About the Role

* 9+ years of experience in Informatica ETL development.
 * Strong experience with Informatica PowerCenter.
 * Strong SQL and database knowledge.
 * Experience with data warehouse and ETL development.
 * Experience working in Agile development environments is preferred.

## Description

We are looking for an experienced Informatica Developer to design, develop, and maintain data integration and ETL solutions. The candidate will work with business and technical teams to extract, transform, and load data from multiple sources into enterprise data warehouses and data platforms., * Design, develop, and maintain ETL workflows and mappings using Informatica.

 * Develop complex Informatica mappings, mapplets, workflows, and sessions.
 * Extract data from multiple source systems and load data into target databases and data warehouses.
 * Perform data transformation, cleansing, validation, and integration.
 * Analyze business requirements and translate them into technical ETL specifications.
 * Develop reusable ETL components and follow coding and development standards.
 * Monitor ETL workflows and troubleshoot production issues.
 * Optimize ETL jobs for performance and scalability.
 * Perform data analysis and validation using SQL.
 * Work with Data Architects, Business Analysts, Developers, and QA teams.
 * Implement error handling, logging, and recovery mechanisms.
 * Support deployment of Informatica code across development, testing, and production environments.
 * Prepare technical documentation for ETL processes and data flows.
 * Participate in data migration and data warehouse projects.

Required Technical Skills
Informatica

 * Informatica PowerCenter
 * Informatica Designer
 * Workflow Manager
 * Workflow Monitor
 * Repository Manager
 * Mappings
 * Mapplets
 * Sessions
 * Workflows
 * Transformations
 * Lookups
 * Joiner
 * Aggregator
 * Router
 * Filter
 * Sorter
 * Update Strategy
 * Sequence Generator

Database / SQL

 * SQL
 * Oracle
 * SQL Server
 * PostgreSQL
 * MySQL
 * Database concepts
 * Stored Procedures
 * Views
 * Indexes

Data Warehousing

 * ETL / ELT
 * Data Warehousing
 * Star Schema
 * Snowflake Schema
 * Fact and Dimension Tables
 * Slowly Changing Dimensions (SCD Type 1/2)
 * Data Migration
 * Data Quality

Cloud / Big Data - Preferred

 * Informatica Intelligent Data Management Cloud (IDMC)
 * Informatica Cloud Data Integration (CDI)
 * AWS
 * Azure
 * Snowflake
 * Databricks
 * Amazon S3

Other Tools

 * Git
 * Jenkins
 * Jira
 * Linux/Unix
 * Shell scripting, * Monitor daily ETL workflows and identify failures.
 * Troubleshoot mapping, workflow, database, and data-related issues.
 * Analyze source-to-target data discrepancies.
 * Perform root-cause analysis.
 * Restart and recover failed workflows.
 * Coordinate with database and application teams to resolve production issues.
 * Meet SLA requirements for incident resolution.


## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94)
- [GitOps for the people](https://www.wearedevelopers.com/videos/461-gitops-for-the-people)
- [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of)
- [Branch your database like your code:  How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand)
- [Developer Experience, Platform Engineering and AI powered Apps](https://www.wearedevelopers.com/videos/990-developer-experience-platform-engineering-and-ai-powered-apps)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift)
- [Why Attend a Developer Event in 2026?](https://www.wearedevelopers.com/magazine/688-why-attend-a-developer-event-in-2026)