Informatica Consultant Resume Samples

An Informatica Consultant assists the company in maintaining relevant sources of data and makes sure that this data is stored properly; and also provides Informatica Administration advice to the IT department. Some of the major duties associated to the role are listed on the Informatica Consultant Resume as – coordinating with business users and analysts and discussing the document requirements of the company, and transforming them into technical specification documents; performing data profiling and analysis of various objects in SFDC form, developing source-target map documents; developing ETL specification design documents; designing and developing Informatica ETL interfaces to load data incrementally from MS Access database and SFDC; and coordinating with testing team to develop unit and integration test cases for detecting and resolving development defects.

The most sought-after skills include the following – experience in Informatica administration, huge knowledge of Unix and Linux administration; familiarity with working in a production environment and grasp of data warehousing concepts; and multitasking skills. While a computer science degree is normally considered mandatory, strong programming background and relevant qualification in the field act in lieu of formal studies.

Informatica Consultant Resume example

Informatica Consultant Resume

Objective : Professional Summary: 7+ years of experience as an ETL Developer with the development of ETL's for Data warehouse/Data Migration using Informatica Powercenter version and SSIS (SQL Server Integration Services) ETL tools. Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, and Query man), Teradata parallel support, Perl and Unix Shell scripting.

Skills : Management, Organizing.

Description :

    1. Developed mappings/sessions using Informatica Power Center 8.6.1 for data loading.
    2. Build out best practices regarding data staging data cleansing and data transformation routines within the Informatica MDM solution Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normaliser, Joiner, Router, Sorter and Union.
    3. Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time.
    4. Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
    5. Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
    6. Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
    7. Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
    8. Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
    9. Increased staff productivity between 80% to 100% with Informatica B2B Data Exchange or Data Transformation.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelor's


Sr. Informatica Consultant Resume

Summary : Over 8+ years' Experience with Informatica (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager). Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake Schemas, SCD & Dimensional Modeling.

Skills : Informatica Developer, ETL Developer.

Description :

    1. Extensively use dof B2B Data Transformation for handling vendor data, where it is in EDI, Unstructured data and Complex structured data (XML Schemas).
    2. Extensively worked with structured and unstructured data.
    3. Worked with HIPAA 5010 for reduces risk.
    4. Provided flexibility and complete bidirectional transaction crosswalk transactions.
    5. Involved in analysis, requirement gathering, and documenting functional and technical specifications.
    6. Involved in the preparation of the mapping document for 5010 by identifying the minor changes from 4010.
    7. Involved in the installation of B2B plug-ins in the machine.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors


Jr. Informatica Consultant Resume

Objective : Around 7years of IT industry experience in Analysis, Design, Development and Maintenance. Experienced in Data Warehouse applications using Informatica, Oracle, DB2, MS SQL server on Windows, IBM and UNIX platforms. Highly involved in designing and developing complex mappings using ETL tools, Informatica PowerCenter Informatica MDM Hub Console developer experience with versions 9.

Skills : Management, Organizing.

Description :

    1. Provided an analysis report for the Hospital management and was focused on the usage and allocation of the hospital resources.
    2. Provided infrastructure to develop and build dashboards, automated reports, and report templates using advanced tableau.
    3. Provided guidance insight on data visualization and tableau dashboard design best practices.
    4. Involved in creating ED datamart.
    5. Extensively involved in requirements gathering, writing ETL Specifications and preparing design documents.
    6. Created complex mappings to extract transform and load data into data warehouse.
    7. Developed and executed various SQL Scripts for unit testing and system testing.
    8. Involved in Performance tuning of sessions and mappings for better performance.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelors

Informatica Consultant I Resume

Objective : Informatica Consultant member of the delivery team that would be responsible for the following project activities but not limited to developing project plans, defining project goals and objectives, developing project related deliverables, conduct workshops.

Skills : Management, Organizing.

Description :

    1. Interacts with business owners to gather both functional and technical requirements.
    2. Documents the business requirements and framing the business logic for the ETL process.
    3. Develops technical specifications and other helpful ETL documents following CME Group's standards.
    4. Uses Agile methodology for SDLC and utilize scrum meetings for creative and productive work.
    5. Designs and develops PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance.
    6. Designs, develops, and tests Informatica mappings, workflows, worklets, reusable objects, SQL queries, and Shell scripts to implement complex business rules.
    7. Loads historical and intraday trades, settlements, positions, and product data into Oracle data warehouse to enable business analysts to better understand, monitor, and analyze liquidity generating performance of Market Maker firms trading CME Group's products.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor

Informatica Consultant II Resume

Headline : An ambitious Data Enthusiast, over data to extract rich informational and interesting content in order to make data more meaningful and exploitable. A Data Enthusiast, having a total of 7years track record in implementation of Big Data, Data Warehouse,Business Intelligence, Data Integration, Data Governance, Data Quality and Data Analytics projects for various Clients belonging to Banking, Insurance,Manufacturing and Educational Domain.

Skills : Management, Organizing.

Description :

    1. Responsible for the company to become an enterprise-wide solution supporting all core business processes.
    2. Responsible for different modules of data quality procedures such as profiling, standardization, elimination of duplicates and consolidation are applied to the data.
    3. Interacted with business representatives for Requirement Analysis and to define Business and Functional Specifications.
    4. Involved in MDM architecture and design discussions with the teams.
    5. Gathered the functional and technical requirements for MDM workstream.
    6. Teamed up with Enterprise Information Quality & Governance Office and business data stewards to provide summary results of data quality analysis.
    7. Made decisions regarding how to measure business rules and quality of the data.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Bachelors

Informatica Consultant III Resume

Summary : 10+ Years of IT experience in development and design of ETL methodology for Implementations of Data warehousing Applications, supporting data transformations & processing in a corporate wide ETL Solution using Informatica , SQL Server and Oracle10g/11g. Worked in all phases of the Software Development Life Cycle (SDLC).

Skills : Management, Organizing.

Description :

    1. Consolidated and summarised data to provide a strategic view of the data for decision-making purposes.
    2. Provided timely information on the company, the customer and the market to the business in terms of sales.
    3. Responsible for development and support of ETL routines and designed Informatica loads required for populating the data warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for the Application.
    4. Extensively used various Data Cleansing and Data Conversion Functions in various transformations.
    5. Involved in Dimension modeling of Data warehouse designed the business process, grain, dimensions and measured facts.
    6. Created necessary repositories using repository manager to handle the metadata in the ETL process.
    7. Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, duplicate elimination and exception handling and monitoring capabilities of IDQ Used IDE to identify data duplication, understand the quality of data and report generation.
Years of Experience
Experience
7-10 Years
Experience Level
Level
Management
Education
Education
Bachelors

Asst. Informatica Consultant Resume

Objective : Over 9+ years of professional experience in IT with progressive experience in design, development, testing and implementation of Data warehouse applications. Experience in data modeling, data warehouse, Ralph Kimball models with Star/Snowflake Schema designs with analysis-definition, database design, testing, and implementation and Quality process.

Skills : Management, Organizing.

Description :

    1. Developed data models using Erwin 3.5.
    2. Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.
    3. Involved in Database design, entity relationship modeling and dimensional modeling using Star schema.
    4. Extensively used all the features of Informatica Versions 7.x including Designer, Workflow manager and Repository Manager, Workflow monitor.
    5. Developed and modified UNIX shell scripts to reset and run Informatica workflows using pmcmd on UNIX Environment.
    6. Responsible for ETL mappings were developed to perform tasks like validating file formats, business rules, database rules and statistical operations.
    7. Worked extensively with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
    8. Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
Years of Experience
Experience
2-5 Years
Experience Level
Level
Junior
Education
Education
Bachelor's

Associate Informatica Consultant Resume

Headline : 10 years of experience in Data Warehousing & Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager and Informatica server), Informatica PowerMart [] Power Analyzer, Power Connect, OLTP, OLAP, Autosys, Control M, Crontab, IMS Rx Data (Xponent, Xponent Plantrak, PlanTrak, Rx Data) Data Modeling experience using Dimensional Data modeling, Relational Data modeling, Star Join Schema modeling, Snow-Flake modeling, FACT and Dimensions tables, Physical and logical data modeling, Erwin [] Oracle Designer, MS Visio Designing experience on Data Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis Data Cleansing experience using Firstlogic and Trillium 7.

Skills : Informatica, Teradata, Oracle, Maestro, Unix Administration.

Description :

    1. Focused upon the successful implementation of the Financial Data Mart (FDM) which will allow for consolidated Segment Financial Reporting.
    2. Worked with Business analysts for requirement gathering, business analysis, and testing and project- coordination.
    3. Analyzed source data and gathered requirements from the business users.
    4. Worked on understanding and creating ETL Design documents and specifications.
    5. Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
    6. Created Logical and Physical models for the Datamart using Erwin 4.5 Created Autosys jobs and scheduled Informatica jobs through Autosys.
    7. Developed mappings with transformations and mapplets confirming to the business rules.
Years of Experience
Experience
5-7 Years
Experience Level
Level
Executive
Education
Education
Master's

Lead Informatica Consultant Resume

Summary : Responsible for data transformation, production cycle processing, implementation of new customers and related data analysis. Data Operations team members work closely with our Customer Experience team, customers and external data suppliers.

Skills : Informatica, ETL, Oracle, SQL, PL/SQL, Informatica Data Quality, Unix, Teradata.

Description :

  • Processes data on a monthly basis to support monthly data warehouse refreshes for customers.
  • Maintains a client load and takes responsibility for projects associated with those clients.
  • Implements new data sources for existing customers and for new customer implementations.
  • Leads new customer implementations of reasonable complexity.
  • Performs research and custom analysis of integrated healthcare data, interprets results, and makes recommendations based on analytic findings to business areas.
  • Collaborates with account managers, customers and data suppliers regarding recommendations about data collection methods, metrics definition, evaluation methods, design and execution of analytic studies to answer business and research questions..
  • Presents analytic reports to clients and stakeholders.
  • Defines and delivers analytical solutions in support of healthcare business initiatives that drive short and long term objectives.
Years of Experience
Experience
10+ Years
Experience Level
Level
Senior
Education
Education
Bachelors

Informatica Consultant Resume

Objective : Directly help clients transform their business and solve complex problems. define the scope and vision for projects that deliver customized solutions using your knowledge of IBM platforms, serving as a liaison among business partners, technical resources, and project stakeholders.

Skills : Management, Organizing,

Description :

    1. Developed a wholesale 4G LTE wireless broadband communications network integrated with satellite coverage across the United States using a block of frequencies located near the band used by the Global Positioning System (GPS).
    2. Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.
    3. Interacted with Source system SME's to analyze how various business processes have been tracked across the source tables.
    4. Designed Data warehouse target tables by using Dimensional Modelling Techniques - Star and Snowflake Schemas.
    5. Created Dimensions and Fact tables using Erwin.
    6. Extracted data from various data sources such as Oracle, Flat file, XML, DB2 and transformed and loaded into targets using Informatica.
    7. Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.
    8. Designed and developed initial and incremental data loads using Informatica.
    9. Designed and Developed several mapplets and work lets for reusability.
Years of Experience
Experience
0-2 Years
Experience Level
Level
Entry Level
Education
Education
Bachelor's