INFORMATICA DEVELOPER SKILLS, EXPERIENCES, AND JOB REQUIREMENTS

Published: Sep 4, 2025 - The Informatica Developer delivers ETL and data warehouse solutions using Informatica, PySpark, and cloud platforms. This role requires expertise in design, architecture review, Python, and Talend, along with strong problem-solving and adaptability in complex environments. The developer also collaborates with diverse teams and stakeholders, applying effective communication and relationship-building skills to ensure successful project delivery.

Essential Hard and Soft Skills for an Informatica Developer Resume
  • Informatica Workflows
  • SQL Expertise
  • ETL Development
  • Data Modeling
  • Code Review
  • Data Architecture
  • Oracle PLSQL
  • Data Integration
  • Job Scheduling
  • MDM Solutions
  • Team Collaboration
  • Requirement Gathering
  • Customer Consultation
  • Issue Resolution
  • Business Analysis
  • Stakeholder Coordination
  • Solution Delivery
  • Business Collaboration
  • Team Leadership
  • User Communication

Summary of Informatica Developer Knowledge and Qualifications on Resume

1. BS in Data Science with 7 years of Experience

  • Experience in Software Development
  • Experience with SQL Server, Informatica, relational structures
  • Strong analytical and problem-solving skills, highly organized and strong attention to detail
  • Comfortable and effective in working across regions and cultures
  • Sound understanding of Business Intelligence best practices, relational structures, and data warehouse and reporting techniques as well as structured query language (SQL) skills
  • Well-versed in the area of Star Schemas and dimensional modeling, understanding and implementing business requirements, and designing and developing technical solutions
  • Must have Informatica Cloud - IICS experience
  • Must have REST-based API experience
  • Working experience in CAI and Application Integration 
  • Working experience in Informatica 
  • Hands-on experience specific to IICS Cloud Application Integration and publisher/subscriber
  • Experienced and comfortable working with client-counterparts to develop integration requirements and design specifications
  • Experience with some of the applications such as Coupa, JDE, Oracle

2. BA in Information Systems with 5 years of Experience

  • Demonstrate a positive attitude and team focus
  • Able to provide senior-level consulting and advisory services to clients as a subject matter expert for
  • Able to provide analysis and recommendations for ETL implementation
  • Able to take part in the Design Brainstorm and the design approval process
  • Strong organizational and written/verbal communication skills
  • Must have excellent presentation skills
  • Able to design and develop highly efficient/high-performance ETL mappings/workflows
  • Strong working knowledge of Oracle DDL / DML and performance tuning strategies
  • Comfortable working in a fast-paced, changing environment
  • Extensive hands-on experience with design, development and deployment of ETLs to/from data warehouse environments
  • Experience with data warehousing best practices

3. BS in Computer Science with 8 years of Experience

  • Strong hands-on Informatica Development experience
  • Working experience in Healthcare 
  • Work experience in the design and implementation of an ETL framework for complex data warehouse initiatives
  • Strong knowledge of Informatica and Informatica solutions
  • Experience with full lifecycle enterprise data warehouse build
  • Experience working with healthcare data and secure inbound and outbound data exchange
  • Strong experience in designing scalable data models and data flows
  • Experience with Informatica
  • Proficient in Informatica Development as well as multiple design techniques
  • Working proficiency in the Informatica toolset to design, develop, test, deploy, maintain and improve software
  • Strong understanding of Agile methodologies
  • Ability to work in at least one of the common frameworks
  • Strong understanding of techniques such as Continuous Integration, Continuous Delivery, Test Driven Development, Cloud Development, application resiliency and security
  • Working proficiency in a portion of software engineering disciplines
  • Demonstrates understanding of overall software skills

4. BA in Management Information Systems with 6 years of Experience

  • Working experience in Information Technology 
  • Experience in Informatica Power Center
  • Experience in Informatica Power Center
  • Must have worked independently in designing the ETL Pipelines
  • Knowledge of Agile Methodologies
  • Experience in building CI/CD pipelines
  • Strong analytical and problem-solving skills
  • Able to work in an offshore-onshore model
  • Must have a strong hold on building SQL scripts
  • Excellent oral and written communication skills
  • Ability to express information and ideas vividly
  • Demonstrates aptitude in logical and analytical thinking, as well as displaying strong problem-solving skills to resolve production issues
  • Ability to document solutions to issues and add to the knowledge document repository

5. BS in Cybersecurity with 7 years of Experience

  • Experience with Information Technology
  • Experience in Informatica ETL Projects, solution design and documentation
  • Experience in end-to-end implementation of DW BI projects, especially in data warehouse and mart developments
  • Strong knowledge and hands-on experience in SQL, Unix shell scripting, and TypeScript
  • Knowledge and experience with the full SDLC lifecycle
  • Experience with Lean / Agile development methodologies
  • Experience in Relational Modeling, Dimensional Modeling and Modeling of Unstructured Data
  • Experience with Big Data technologies
  • Hands-on programming/scripting experience skills such as UNIX shell, Perl, and JavaScript
  • Experience with the design and implementation of an ETL/ELT framework for complex warehouses/marts
  • Knowledge of large data sets and experience with performance tuning and troubleshooting
  • Ability to communicate complex technology solutions to diverse teams, namely, technical, business and management teams
  • Experience and desire to work in a Global delivery environment

6. BA in Computer Information Systems with 5 years of Experience

  • Expert in Informatica or other ETL Technologies And Oracle and NoSQL Technologies, Couchbase, Postgres, Casandra, Hadoop
  • Data Engineering experience related to Classical Amdocs BSS and Microservices C1/D1
  • In-depth knowledge of Billing, CRM, and OMS, including data model
  • Excellent analytical and debugging skills
  • Experience in E2E development, Life cycle starting from pre-scoping till Deployment
  • Understanding of Amdocs process, methodology, product background and delivery experience
  • Familiar with Amdocs tools and technologies
  • Must be comfortable working in a fast-paced environment, adhere to policies and procedures, while using sound judgment to solve problems
  • Ability to work independently and drive issues to closure
  • Good interpersonal and communication skills

7. BA in Industrial Engineering with 6 years of Experience

  • IT experience dealing with data management activities
  • Experience in Informatica (9.X and above) MDM on small/medium/large scale implementation
  • Hands-on experience in data profiling, data standardization and developing reusable data quality rules using IDQ
  • Working knowledge of Informatica Data Governance (DG) and tech products - EDC, Axon
  • Good understanding of Data Modeling, Metadata Management concepts and tools
  • Experience in Snowflake and Informatica IICS 
  • Excellent written and verbal communication skills, and able to work with multiple vendors
  • Experience with UNIX shell scripts for automation of jobs 
  • Experience with process documentation and efficiency improvement
  • Strong technical and project management/process leadership skills
  • Knowledge of healthcare industry systems and applications
  • Ability to work within a diverse, technically oriented team setting
  • Ability to take ownership of incidents, coordinate effective response, and drive improvements through root cause analysis and lessons learned
  • Experience with DataStage V.11.7.

8. BS in Bioinformatics with 7 years of Experience

  • Development experience working with Informatica Data Quality and Power Center
  • Able to install, configure, secure, and administer Informatica Data Quality V10.x 
  • Experience working with Informatica developer tools to configure, connect, create data objects, and deploy applications
  • Experience working with Developer workflows and transformations 
  • Able to identify bottlenecks and optimize mapping performance and workflow execution 
  • Able to design and develop an exception management interface for data stewards 
  • Able to collaborate with technical enterprise data stewards and business users on the technical implementation of business rules 
  • Strong understanding of relational databases and data models 
  • Strong SQL Server database knowledge to write highly performant SQL 
  • Development experience in Informatica, B2B, DX, Oracle PL/SQL and Facets
  • Experience in other programming languages or technologies like EDI, C#, .NET 
  • Experience working in an Agile-based work environment (SAFe, Scrum, XP, etc.)

9. BA in Information Systems with 5 years of Experience

  • Hands-on experience in ETL projects using Informatica
  • Hands-on experience with end-to-end implementation of DW BI projects, especially in data warehouse using PySpark
  • Knowledge of Redshift, S3 and AWS cloud
  • Experience in Design and architecture review
  • Ability to work in a team in a diverse/ multiple stakeholder environment
  • Ability to thrive in a fast, sophisticated environment and can take care of ambiguous situations
  • Ability to be creative and tackle complex problems
  • Possess skills to communicate and build positive relationships with business and other key partners
  • Experience with any cloud platform (Snowflake, AWS, Azure)
  • Experience with Python and Talend

10. BA in Business Analytics with 4 years of Experience

  • Experience with Informatica Power Center
  • Working experience in PostgreSQL SQL 
  • Strong experience with ETL development and process from diverse data sources
  • Advanced experience with Informatica Power Exchange, Control-M
  • Experience with data modeling concepts
  • Experience in development, maintenance, and enhancement of Informatica Mappings, Workflows, and processes
  • Good verbal and written communication skills
  • Ability to interface with all levels of management
  • Ability to perform complex tasks with minimal supervision and guidance
  • Excellent time management, scheduling and organizational skills
  • Ability to work well independently or in a team setting
  • Knowledge of IRS business systems and data

11. BA in Management Information Systems with 6 years of Experience

  • Good communication skills, independent and motivated
  • Development experience in Informatica / ETL Tools
  • Working experience in Informatica Power Center 9.x or DataStage
  • Experience in Oracle, SQL Server
  • Working experience in Data Warehouse / Data Mart / Business Intelligence delivery
  • Experience in Informatica development experience
  • Must be strong with SQL and able to write stored procedures
  • Experience implementing Informatica PowerCenter
  • Strong experience with SQL and can write stored procedures
  • Experience in B2B, EAI, ESB, web services, service-oriented architecture
  • Experience implementing B2B integration solutions using Informatica B2B DX/DT, Informatica PowerCenter

12. BS in Cloud Computing with 8 years of Experience

  • Experience with Informatica Power Center 8.x/9.x
  • Experience with Oracle 10g or higher
  • Experience with Oracle SQL (DML and DDL), PL/SQL, packages, stored procedures, triggers
  • Expertise in reviewing business requirements, technical requirements documentation
  • Expertise in writing high and low-level design documentation
  • Experience in writing re-usable unit test documents
  • Extensive experience with developing, unit testing, and break/fix support of Informatica ETL
  • Skilled in performance tuning, query plan / explain plan analysis, indexing, and table partitioning
  • Excellent communication skills, both verbal and written
  • Experience leading technical teams
  • Familiarity with the use of version control/source code management tools (CVS, Dimensions, etc.)
  • Well-organized, detail-oriented, and able to multitask
  • Excellent time-management, planning and prioritization
  • Comfortable working with all project stakeholders (business users, architects, project managers, business analysts, developers, test analysts, production support team)
  • Experience working with Agile methodology
  • Experience with HP-ILM (previously known as Quality Center/Test Director)