Automatically apply for jobs with Zippi
Upload your resume to get started.
Informatica developer skills for your resume and career
15 informatica developer skills for your resume and career
1. Informatica Workflow
- Implemented addition of new partner or elimination of partners in Revenue share calculation process using Informatica workflows.
- Involved in Migration of Informatica workflows/mappings from development region to Test and Production Environments.
2. 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.
- Designed Work Flows that uses multiple sessions and command line objects (which are used to run the UNIX scripts).
- Developed UNIX shell scripts, Perl scripts to format the session log files and to extract the information from error logs.
3. SQL Server
- Designed and Developed SQL Server Database for Marketing Approval Management System.
- Performed Data Validations using Microsoft SQL Server Management Studio 2008.
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.
- Distributed data residing in heterogeneous data sources was consolidated onto target Enterprise Data Warehouse (EDW) database.
- Involved in data migration from legacy systems to Data Warehouse using Velocity methodology and Best Practices.
5. PL/SQL
- Developed PL/SQL functions/procedures/cursors/packages/database triggers to implement business logic.
- Imported data using source analyzer and exported data using Target analyzer designed and developed Oracle PL/SQL procedures.
6. Informatica ETL
- Provided solutions for data warehousing and Informatica ETL Processes to support Data Integration and Reporting requirements.
- Implemented Slowly Changing Dimension Phenomenon Type-1, Type-2 using Informatica ETL mapping.
Choose from 10+ customizable informatica developer resume templates
Build a professional informatica 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 developer resume.7. 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.
- Worked extensively on Oracle database using TOAD tool and created many complex queries for their day to day jobs loads.
- Created and reviewed scripts to create new tables, views, queries for new enhancement in the applications using TOAD.
8. Repository
- Created Repository and configured Physical Layer, Business Model and Mapping Layer and Presentation Layer using Administration Tool.
- Created Metadata Repository and Statistical tables, Intelligence Server and Project on MicroStrategy Desktop using the Configuration Wizard.
9. Aggregator
- Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look-up Transformations.
- Developed Mappings using Active Transformations such as Aggregator, Filter, Joiner, Router, Sorter, and Union Transformations.
10. Data Quality
- Developed complex power Center mappings by using different transformations and components respectively to meet the data integration and data quality requirements.
- Involved in identifying data discrepancies and data quality issues and worked to ensure data consistency and integrity.
11. Informatica Powercenter
- Participated in Informatica PowerCenter administration.
- Developed a business intelligence system to quickly identify customer needs and better target services using Informatica PowerCenter software.
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.
- Used Change Data Capture (CDC) to capture changes in source data base and applied to target DB2 data base.
- Integrated various data sources like Oracle, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
13. Data Analysis
- Performed extensive data analysis along with subject matter experts and identified source data and implemented data cleansing strategy.
- Performed extensive data analysis to understand the existing data behavior using current and historical data.
14. Informatica Mappings
- Involved in Performance tuning of the INFORMATICA Mappings and PLSQL Programs for Handling 10+ million of records.
- Involved in performance tuning and optimization of Informatica mappings and session using features like Partitions and data/index cache.
15. Oracle Sql
- Created the Unix Shell script to load the high volume flat files data into staging tables using Oracle SQL* Loader.
- Used Oracle SQL Loader utility to Bulk Load data from flat files into database tables.
5 Informatica Developer resume examples
Build a professional informatica 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 developer resume.
What skills help Informatica Developers find jobs?
Tell us what job you are looking for, we’ll show you what skills employers want.
List of informatica developer skills to add to your resume
The most important skills for an informatica developer resume and required skills for an informatica developer to have include:
- Informatica Workflow
- Unix
- SQL Server
- Data Warehouse
- PL/SQL
- Informatica ETL
- Toad
- Repository
- Aggregator
- Data Quality
- Informatica Powercenter
- DB2
- Data Analysis
- Informatica Mappings
- Oracle Sql
- Windows XP
- Extraction
- XML
- Teradata
- Test Cases
- Oracle 10G
- Business Rules
- Java
- Load Data
- Source Qualifier
- QA
- Source Data
- IDQ
- Schema
- Production Environment
- Data Warehousing
- Debuggers
- Sequence Generator
- Source Systems
- Technical Specifications
- Data Models
- Lookup
- Oracle 11G
- Data Flow
- Data Marts
- Linux
- Business Analysts
- Autosys
- SDLC
- Fact Tables
- Profiling
- Business Logic
- Update Strategy
Updated January 8, 2025
