INFORMATICA ETL DEVELOPER SKILLS, EXPERIENCES, AND JOB REQUIREMENTS

Published: Sep 4, 2025 - The Informatica ETL Developer designs and maintains data integration solutions using Informatica, SQL, Oracle, and Unix/Linux scripting for automation and scheduling. This role requires expertise in coding complex procedures, performing performance tuning, optimizing queries, and applying strong data analysis to ensure accuracy and efficiency. The developer also supports data warehousing environments, collaborates within Agile and offshore-onshore models, and contributes effectively both independently and in team settings.

Essential Hard and Soft Skills for an Informatica ETL Developer Resume
  • Informatica Tools
  • ETL Development
  • Data Mapping
  • Oracle PLSQL
  • Performance Tuning
  • Data Architecture
  • Error Handling
  • Workflow Design
  • Data Integration
  • SQL Unix
  • Requirement Analysis
  • Team Collaboration
  • Stakeholder Communication
  • Problem Resolution
  • Offshore Coordination
  • User Support
  • Solution Guidance
  • Project Collaboration
  • Team Leadership
  • Global Collaboration

Summary of Informatica ETL Developer Knowledge and Qualifications on Resume

1. BS in Data Science with 7 years of Experience

  • IT experience with strong emphasis on ETL, DW Technologies 
  • Must have strong knowledge and hands-on experience in Informatica Power Center 9.6 and above 
  • Able to participate in team reviews of design artifacts and code, make changes, and recommend alternative solutions
  • Good debugging and problem-solving skills 
  • Must have strong knowledge of SQL 
  • Hands-on experience with Oracle Teradata
  • Hands-on experience with UNIX Shell Scripting
  • Must have good experience in ETL design, EDW Data Mart Design, and architecture 
  • Excellent communication and presentation skills
  • Ability to explain technical concepts
  • Strong conceptual and analysis skills 
  • Must have strong knowledge of SSIS 
  • Proven knowledge in the design and construction of ETL architectures that enable well-integrated transactional operational systems

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

  • ETL-Informatica experience using a variety of Databases
  • Able to advise on the application of standards/methodology practices to the project
  • Able to create complex data loading processes for Operational Data Stores, Data Warehouses and Data Marts that satisfy all functional and technical requirements
  • Able to analyze and review complex objects and data models and the metadata repository to structure processes and data for accuracy, efficiency, and maintainability
  • Able to work with various levels of project managers, data modelers, DBAs, and system administrators to design load processes and identify potential problem areas
  • Able to collaborate with the Data Architect to understand, interpret, and implement complex data integration requirements
  • Must have strong documentation skills 
  • Strong Data Analysis skills using SQL
  • Able to develop Process flow diagrams
  • Strong collaboration and communication skills within distributed project teams and in an Agile environment

3. BA in Information Systems with 5 years of Experience

  • Hands-on experience working on the Informatica ETL tool (Informatica Cloud Services - IICS)
  • Hands-on experience working on Data Warehouse (Cloud-based databases like Snowflake, Redshift)
  • Good exposure to the Cloud platform
  • Good understanding of Data Modeling, Data Warehouse, Data Catalog and Metadata Management concepts and tools
  • Skilled in writing SQL queries on relational databases
  • Strong analytical skills with the ability to collect, organize, analyze, and disseminate large data sets
  • Ability to work under direction, independently and in a team setting
  • Able to work effectively with vendors and IT leadership
  • Ability to organize information and communicate clearly and concisely
  • Ability to manage own time, activities and resources to deliver timely results

4. BA in Business Analytics with 4 years of Experience

  • Work experience in Informatica B2B (DT and DX)
  • Hands-on experience in Informatica Power Centre development
  • Good debugging and issue-resolving skills
  • Good knowledge of Unix and Oracle
  • Must have Banking Domain Payment knowledge
  • Must have strong Java knowledge
  • Ability to build collaborative skills
  • Working experience in Agile/SCRUM methodology 
  • Working experience in Azure DevOps 
  • Hands-on experience with SQL databases, SSIS/Informatica ETL, Power BI, cloud-based integration tools
  • Knowledge of Data warehousing concepts and data modeling using the Kimball methodology
  • Excellent oral and written communication skills

5. BA in Industrial Engineering with 7 years of Experience

  • Able to develop performance-optimized ETL jobs based on documented requirements and specifications
  • Must have a very good hand on experience with Informatica PowerCenter 10X
  • Must have hands-on experience with Oracle and SQL Server databases
  • Expert in writing performance-optimized queries
  • Must have analytical abilities to analyze existing code and improve data quality and load performance
  • Understand CDC for real-time data processing
  • Hands-on experience with Power Exchange or Golden Gate
  • Must have worked on a large dataset in the past
  • Able to assist in the development and maintenance of user manuals and guidelines
  • Strong knowledge of software implementation best practices
  • Ability to adapt quickly to an existing, complex environment
  • Ability to quickly learn new concepts and software
  • Experience in a Data warehousing project
  • Experience in working as part of a small to medium-sized development team
  • Experience in the health insurance sector 

6. BS in Computer Science with 8 years of Experience

  • Hands-on experience with Informatica IICS
  • Hands-on experience with Informatica PowerCenter
  • Extensive experience working with various data sources (SQL and Oracle database, flat files (CSV, delimited), REST API, XML, SOAP
  • Advanced SQL skills
  • Demonstrable understanding of relational databases and business data
  • Ability to write complex SQL queries against a variety of data sources
  • Knowledge of Informatica Architecture
  • Working knowledge of data modelling (conceptual, logical and physical) as well as database design
  • Experience in RDMBS (SQL Server, Oracle), including sophisticated SQL constructs and DDL generation
  • Solid understanding of PowerShell scripting or Shell scripting
  • Demonstrable experience with Business Intelligence/Analysis and Data Warehousing
  • Solid understanding of relational and dimensional data models
  • Ability to learn new technology and quickly adapt to changing environments
  • Excellent problem-solving, analytical, communication, coordination and task management skills
  • Experience migrating PowerCenter Workflows to IICS
  • Experience with Azure Data Factory

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

  • Experience in Informatica Power Center and the overall Informatica suite
  • Experience with Jenkins, Git (or appropriate source control) and scripting (e.g., Python/Unix shell)
  • Able to design, implement, or support a Data Lake environment
  • Must have Data modelling skills (e.g., Kimball, Data Vault)
  • Experience on cloud platforms such as AWS, Azure and Google Cloud Platform
  • Experience in leading projects or units of work
  • Solid experience working in either agile or waterfall environments
  • Excited by the opportunity to learn and develop
  • Demonstrated experience in the successful delivery of complex enterprise data projects
  • Strong technical and people leadership capability
  • Ability to manage key stakeholders and multiple deliverables to achieve effective outcomes

8. BA in Industrial Engineering with 7 years of Experience

  • Understand how the Bank’s risk appetite and risk culture should be considered in day-to-day activities and decisions
  • Demonstrate strong communication (verbal/written) skills and good interpersonal skills to build relationships with internal and external business partners and vendors
  • Proven track record as a strong team player
  • Proven ability to create technical specifications, develop, and implement solutions for highly available and resilient systems
  • Hands-on technical working experience as a software engineer with Informatica
  • Hands-on technical working experience with DB2
  • Hands-on technical working experience with UNIX scripting
  • Demonstrate hands-on experience authoring Standard Operating Procedures and Run Books
  • Excellent problem-solving skills to identify and resolve issues before they become a problem
  • Able to work under pressure in a dynamic environment
  • Hands-on experience responding to production incidents that cross application and technology boundaries
  • Must have an understanding and experience with security, firewalls and network protocols
  • Hands-on technical working experience in SAS, Python, Cobol, MSSQL, Cognos and SQL Server

9. BS in Bioinformatics with 6 years of Experience

  • Experience with Informatica PowerCenter
  • Experience with Informatica Data Quality
  • Experience with Informatica Power Exchange (change data capture)
  • Able to design, develop, test, implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment
  • Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment
  • Strong experience optimizing Informatica mappings, sessions and workflows
  • Experienced in writing complex SQLs, PL/SQL and Performance tuning
  • Strong database experience, data analysis and analytical skills
  • Experience creating ETL design documentation and maintaining the overall design document and deliverables
  • Strong working experience with XML Data
  • Strong written and oral communication skills
  • Good understanding of dimensional modeling and ETL designs for loading Star Schemas 

10. BA in Information Systems with 5 years of Experience

  • Informatica ETL development experience with a good Oracle background
  • Must be good at data warehousing
  • Must have very strong experience with the CA7 scheduling tool
  • Very strong programming and debugging skills
  • Deep understanding of relational database design concepts and SQL programming 
  • Strong experience in ETL Development processes
  • Strong knowledge of the Data Warehouse concept
  • Strong in UNIX scripting, Oracle PLSQL
  • Strong analytical and troubleshooting skills
  • Ability to provide technical support to offshore team members during project execution
  • Good understanding of BI Skills

11. BS in Information Technology with 8 years of Experience

  • Must have hands-on experience with Informatica and Oracle R12
  • Experience using Informatica to perform ETL
  • Experience with Informatica (IICS)
  • Working experience in coding, ETL development/engineering, analytics, or research
  • Experience working with big data in environments like Hadoop, Oracle, Azure, Snowflake
  • Experience with Snowflake, Python
  • Development experience with Workday and/or HR domain data
  • Hands-on experience with Informatica ETL programming and working with Informatica version 10+
  • Hands-on experience with writing SQL stored procedures in Teradata, including use of the corresponding batch processing tools e.g, bteq)
  • Hands-on experience with Linux shell scripting and Python 3.0 scripting
  • Good interpersonal and communication skills (verbal and written)
  • Good Knowledge and hands-on experience of Agile practices (e.g., Kanban, Scrum)
  • Working knowledge of JIRA or other ALM tools to create a productive, high-quality development environment
  • Knowledge and hands-on experience of DevOps (CI/CD) practices (e.g., Git, Jenkins, TeamCity)

12. BS in Data Science with 7 years of Experience

  • Experience in data acquisition, enrichment and matching using COTS ETL tools such as Pentaho or Informatica
  • Knowledge of AWS and cloud-based technologies
  • Experience in big data platforms (e.g., Hadoop) and traditional RDBMS technologies
  • Experience in developing custom and self-service BI reporting capabilities using COTS tools such as Tableau, QlikView and SQL
  • Proficiency in Transact SQL/Stored Procedures
  • Able to rewrite existing ETLs
  • Good knowledge of Teradata SQL 
  • Excellent communication skills and stakeholder management
  • Ability to work independently in an IC role
  • Good understanding of Azure SQL Database
  • Good understanding of Azure Data Factory
  • Familiarity with Azure DevOps

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

  • Hands-on experience working with database and warehouse technologies and architectures
  • Hands-on experience in various data definition and modeling projects
  • Demonstrated capabilities in carrying best practices and common objects/components to other projects 
  • Experience with development processes and production release management
  • Experience with healthcare-related data
  • Experience or knowledge of FACETS or a similar claims processing system
  • Excellent communication (oral/written) skills with respect to team members, peers, and staff at all levels
  • Ability to write functional and technical specifications for assigned projects
  • Excellent Microsoft Office product skills, especially Word, Excel, Outlook, Access, and PowerPoint
  • Demonstrated ability to work both independently and as part of a team
  • Must possess excellent organizational skills
  • Ability to meet critical deadlines

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

  • In-depth hands-on Experience with Informatica ETL tool, Unix scripting and automation
  • In-depth SQL skills with MS-SQL 2016 and Oracle 12C
  • Experience coding complex stored procedures, Packages and Triggers for application in Oracle and MS-SQL
  • Proficient in Unix/Linux shell scripting for job automation and exposure to scheduling tools like IBM-Tivoli
  • Strong data analysis skills (utilize DB tools, SQL, explain issues clearly, offer solutions and options for issues encountered)
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • Understanding of Data warehousing concepts and Reporting Environment
  • Good to have exposure to JSON string and Web Api application-related Understanding
  • Agile project development experience and offshore-onshore working model
  • Highly effective working in a team, as well as working independently
Relevant Information
Informatica Administrator Skills, Experiences, and Job Requirements
Informatica Architect Skills, Experiences, and Job Requirements
Informatica Developer Skills, Experiences, and Job Requirements