Automatically apply for jobs with Zippia
Upload your resume to get started.
Informatica consultant skills for your resume and career
15 informatica consultant skills for your resume and career
1. Java
Java is a widely-known programming language that was invented in 1995 and is owned by Oracle. It is a server-side language that was created to let app developers "write once, run anywhere". It is easy and simple to learn and use and is powerful, fast, and secure. This object-oriented programming language lets the code be reused that automatically lowers the development cost. Java is specially used for android apps, web and application servers, games, database connections, etc. This programming language is closely related to C++ making it easier for the users to switch between the two.
- Experience in the MDM messages queues by using the customized Java code to call the Web services.
- Involved in writing some of the IDD User exits in Java for Merge / Unmerge.
2. Informatica Workflow
- Developed Tidal jobs to schedule Informatica Workflows.
- Write complex Unix scripts to invoke informatica workflows and daemon jobs in UNIX to load the environment files.
3. 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.
- Managed an enterprise files transfer application across windows and Unix environments.
- Leveraged Shell Scripting in UNIX and LINUX for automating several tasks such as Back up of repositories and domain etc.
4. SQL Server
- Extracted data form Flat Files and XML, applied business logic to load them in the central Microsoft SQL Server database.
- Distributed data is coming from the heterogeneous sources like SQL server, Oracle and in flat files from the clients.
5. PL/SQL
- Created PL/SQL procedures to enable and disable the users while running the jobs and to load the data in control tables.
- Worked with Dates in PL/SQL Dates are a relatively complex scalar data type, in both SQL and PL/SQL.
6. Informatica ETL
- Designed the Informatica ETL flow to load source files into PSA area.
- Designed and Created data cleansing and validation scripts using Informatica ETL tool.
Choose from 10+ customizable informatica consultant resume templates
Build a professional informatica consultant 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 consultant resume.7. 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 is consolidated into the target Oracle enterprise Data Warehouse database.
- Worked with Data Modeler to develop data warehouse models, design specifications, metadata processes and documentation.
8. Repository
- Maintained Development, Test and Production Repositories using Repository Manager.
- Created session and repository variables to achieve desired functionality.
9. 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 DB tools like TOAD to run SQL queries and verify and validate the loaded data in target tables.
- Worked on SQL developer, TOAD and DB Visualizer tools to write complex SQL queries
10. 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.
- Involved in analyzing the source data coming from different Data sources such as XML, DB2, flat files.
- Project involves setting up Change Data Capture Real Time CAPXRT with distributed databases system db2 and USBANK mainframe Z/OS.
11. Informatica Powercenter
- Created reusable transformations and mappings by using mapping designer Transformation developer in Informatica PowerCenter and used them in mappings.
- Solved the Informatica PowerCenter/Cloud/Development/performance/enhancement related issues faced by the users.
12. Aggregator
- Implemented various transformations like Expression, Lookup, Sequence generator, and Source Qualifier, Rank, Aggregator etc.
- Optimized mappings using transformation features like aggregator, filter, joiner, expression and lookups.
13. Windows XP
- Experience in usage of Operating Systems such as UNIX, WINDOWS XP/NT/2000/98/95.
- Prepared a production monitoring and support handbook Environment: Informatica power center 6.1/7.1, Oracle, windows XP, MS office Suite
14. Informatica Mappings
- Developed various detail and summary Extensively Designed, Developed, Tested complex Informatica mappings.
- Developed slowly changing dimension Type1 and Type2 Informatica mappings.
15. Extraction
- Tested all the applications and transported the data to the target Warehouse tables, schedule and run extraction and load process.
- Used technical transformation document to design and build the Extraction, Transformation, and Loading (ETL) modules.
5 Informatica Consultant resume examples
Build a professional informatica consultant 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 consultant resume.
What skills help Informatica Consultants find jobs?
Tell us what job you are looking for, we’ll show you what skills employers want.
List of informatica consultant skills to add to your resume
The most important skills for an informatica consultant resume and required skills for an informatica consultant to have include:
- Java
- Informatica Workflow
- Unix
- SQL Server
- PL/SQL
- Informatica ETL
- Data Warehouse
- Repository
- Toad
- DB2
- Informatica Powercenter
- Aggregator
- Windows XP
- Informatica Mappings
- Extraction
- Load Data
- Oracle 10G
- Test Cases
- Business Rules
- Oracle Sql
- Source Data
- XML
- Source Systems
- Metadata
- Teradata
- QA
- Source Qualifier
- Informatica Data Quality
- Schema
- Oracle Ebs
- Oracle 11G
- Profiling
- Sequence Generator
- Linux
- Debuggers
- UAT
- Data Models
- Business Logic
- Production Environment
- Business Analysts
- Lookup
- Data Warehousing
- Technical Specifications
- IDD
- Cognos
- Autosys
- Data Flow
- Worklets
- DEV
- Update Strategy
Updated January 8, 2025
