Informatica Developer
Confirmed on the employer's own hiring board on Nov 3, 2026. First seen by Alion on Aug 13, 2026. Elfonze Technologies scores B on the Alion truth index.
Key
Responsibilities Design, develop, and maintain ETL/ELT workflows using Informatica. Develop mappings, mapplets, workflows, sessions, and reusable transformations. Work with Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC/IICS). Gather technical requirements and translate business requirements into scalable data integration solutions. Develop complex SQL queries, stored procedures, and database objects. Integrate data from multiple sources including relational databases, flat files, APIs, and cloud platforms. Perform data cleansing, transformation, validation, and reconciliation. Troubleshoot ETL failures and production issues and provide root-cause analysis. Optimize mappings and workflows for improved performance and scalability. Implement error handling, logging, restartability, and data quality checks. Participate in deployment activities across development, testing, and production environments. Work closely with data architects, business analysts, QA teams, and other technical teams. Prepare technical documentation and support knowledge-transfer activities. Mandatory Skills 7+ years of experience in Informatica Development. Strong hands-on experience with Informatica PowerCenter. Experience with Informatica IICS/IDMC is highly preferred. Strong knowledge of ETL concepts and Data Warehousing. Strong SQL skills with experience in Oracle, SQL Server, PostgreSQL, or similar databases. Good understanding of Dimensional Modeling, Star/Snowflake Schema, Facts and Dimensions. Experience in performance tuning of Informatica mappings and workflows. Strong troubleshooting and production support experience. Good understanding of SDLC and deployment processes. Good to Have Experience with AWS/Azure/GCP data platforms. Exposure to Snowflake, Databricks, or Azure Data Lake. Experience with Unix/Linux shell scripting. Knowledge of REST APIs and web-service integrations. Experience with scheduling tools such as Control-M, Autosys, or similar. Exposure to CI/CD and DevOps practices. Experience in Agile/Scrum environments.
Soft Skills Strong analytical and problem-solving skills. Good communication and stakeholder-management skills. Ability to work independently as well as collaboratively. Strong ownership of deliverables and production issues.