Automatically apply for jobs with Zippi
Upload your resume to get started.
Informatica etl developer skills for your resume and career
15 informatica etl developer skills for your resume and career
1. Unix
UNIX is a computer operating system that was first created in the 1960s and has been constantly updated since then. The operating system refers to the set of programs that enable a machine to function. It is a multi-user, multi-tasking device that works on computers, laptops, and servers. UNIX systems also have a graphical user interface (GUI), similar to Microsoft Windows, that makes it simple to use.
- Involved in writing PERL scripts for file transfers, file renaming and few other database scripts to be executed from UNIX.
- Used UNIX shell scripts to write wrapper scripts to call ETL Jobs, FTP and File-watcher Automation, PMCMD Automation etc.
2. Informatica Workflow
- Worked with deployment group to migrate the Informatica workflows form one repository to another repository.
- Developed Shell Scripts to execute Informatica workflows using PMCMD utility.
3. SQL Server
- Implemented SSIS Package Configuration using XML configuration files and SQL Server configurations.
- Analyzed source data which is MS Access files, CSV files, and existing reference tables in Oracle and SQL Server.
4. Data Warehouse
Data warehouse, often abbreviated as either DW or DWH is a system used in computing for data analysis as well reporting. The DW is also considered to be an integral component of business intelligence as they also provide storage facilities for both real-time and historical data. ETL and ELT are the two driving forces behind a data warehouse system.
- Translated business-reporting requirements into data warehouse architectural design.
- Developed Dimensional data modeling of the data warehouse projects by using star schema also developed Data mapping and filtering procedures.
5. PL/SQL
- Developed stored procedures and complex packages extensively using PL/SQL.
- Participate in Developing PL/SQL procedures.
6. Toad
Toad is software that manages non-relational and relational databases that database analysts, developers, and database administrators use. Toad helps in minimizing the cuts in delivery timelines of projects. It also helps in maximizing the investment made by users in the field of data technology by automating all the processes.
- Used TOAD and SQL Developer to analyze the execution and explain plan and accordingly tune SQL queries to improve the performance.
- Generated SQL queries and validated the data loads using TOAD and SQL Developer and monitored mapping's run process.
Choose from 10+ customizable informatica etl developer resume templates
Build a professional informatica etl developer resume in minutes. Our AI resume writing assistant will guide you through every step of the process, and you can choose from 10+ resume templates to create your informatica etl developer resume.7. Informatica Powercenter
- Worked on Informatica PowerCenter Big Data Edition and involved in high-speed data ingestion and extraction.
- Developed mappings in Informatica PowerCenter Designer to load data from staging environment to warehouse.
8. Extraction
- Performed tuning of SQL queries for speedy extraction of data and troubleshooted the long running Sessions and fixed the issues.
- Involved in extraction of data using delimited and fixed width flat files, various XML sources, and SAP.
9. Aggregator
- Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router, and Aggregator.
- Worked extensively with aggregate functions like Min, Max, First, Last, and Count in the Aggregator Transformation.
10. Data Analysis
- Collaborated with testing teams to perform data analysis, gather requirements and develop test scenarios.
- Prepared Technical design documents to meet user requirements for Reporting and Data Analysis.
11. Informatica Mappings
- Performed Tuning of the developed Informatica Mappings and Sessions by identifying and eliminating the bottlenecks for improving the performance.
- Designed and developing complex Informatica mappings including Type-I, Type-II slowly changing dimensions.
12. DB2
The DB2, known as the Relational Database Management System, is a type of procedure developed by IBM to run and operate software applications such as Windows, Unix, and the Linux System. This type of system is designed mainly for IBM but was innovated to run in various operating systems. The main feature of the DB2 is to handle and manage a big chunk of data while allowing the users to enter the database engine without any problem.
- Integrated data from different sources like SQL, Flat Files and Mainframes (DB2 and VSAM) using Power Exchange.
- Designed and developed to extract data from different sources like, Oracle tables, DB2 tables, and Flat files.
13. Oracle Sql
- Tuned the oracle SQL queries.
- Created reports for various Portfolios using the Universes and Oracle SQL as Data providers.
14. XML
XML is a medium for storing and transporting data that is independent of software and hardware. XML stands for eXtensible Markup Language. XML, like HTML, is a markup language that was created to store and transport data. It was created with the intention of being self-descriptive. There are no predefined tags in the XML language. Another feature is that XML is extensible.
- Created mapping using multiple source systems: Oracle, flat files, and XML files into data mart in Oracle database.
- Validate the data received & generate the XML files for each client and transferred to require to third parties/downstream systems.
15. Test Cases
- Reviewed Business Requirements Documents to document business rules and designed test cases for the entire application.
- Create test cases, test plans, test scripts, system integration and UAT plan effectively to deliver a quality product.
5 Informatica ETL Developer resume examples
Build a professional informatica etl developer resume in minutes. Browse through our resume examples to identify the best way to word your resume. Then choose from 5+ resume templates to create your informatica etl developer resume.
What skills help Informatica ETL Developers find jobs?
Tell us what job you are looking for, we’ll show you what skills employers want.
List of informatica etl developer skills to add to your resume
The most important skills for an informatica etl developer resume and required skills for an informatica etl developer to have include:
- Unix
- Informatica Workflow
- SQL Server
- Data Warehouse
- PL/SQL
- Toad
- Informatica Powercenter
- Extraction
- Aggregator
- Data Analysis
- Informatica Mappings
- DB2
- Oracle Sql
- XML
- Test Cases
- Windows XP
- Source Systems
- Informatica ETL
- Data Warehousing
- Source Data
- Source Qualifier
- Oracle 11G
- Business Rules
- Load Data
- QA
- Oracle 10G
- Schema
- SDLC
- Business Analysts
- Informatica Repository
- Technical Specifications
- Informatica Data Quality
- Debuggers
- Sequence Generator
- Fact Tables
- Lookup
- Data Flow
- Java
- Business Logic
- Autosys
- Profiling
- Worklets
- Data Marts
- Update Strategy
- Cache
- Data Models
- Production Environment
- Linux
- Ssis
Updated January 8, 2025
