Informatica Consultant Resume Samples

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.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor's

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.

Experience

10+ Years

Level

Senior

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor

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.

Experience

5-7 Years

Level

Executive

Education

Bachelors

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.

Experience

7-10 Years

Level

Management

Education

Bachelors

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.

Experience

2-5 Years

Level

Junior

Education

Bachelor's

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.

Experience

5-7 Years

Level

Executive

Education

Master's

Description :

1. Processes data on a monthly basis to support monthly data warehouse refreshes for customers.
2. Maintains a client load and takes responsibility for projects associated with those clients.
3. Implements new data sources for existing customers and for new customer implementations.
4. Leads new customer implementations of reasonable complexity.
5. Performs research and custom analysis of integrated healthcare data, interprets results, and makes recommendations based on analytic findings to business areas.
6. 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..
7. Presents analytic reports to clients and stakeholders.
8. Defines and delivers analytical solutions in support of healthcare business initiatives that drive short and long term objectives.

Experience

10+ Years

Level

Senior

Education

Bachelors

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.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor's