We provide IT Staff Augmentation Services!

Informatica Consultant Resume

2.00/5 (Submit Your Rating)

NC

Summary of Qualifications:

  • More than 8 years of IT experience in System design, development and maintenance.
  • More than 7 years of Technical and Functional experience in Decision Support Systems – Data Warehousing, ETL development.
  • Extensive hands-on expertise using Informatica 8.x/7.x/6.x/5.x, with strong business understanding of Agriculture, financial,Healthcare, Banking, Insurance and Telecom sectors.
  • Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema) with some experience in using Erwin 3.5/4.0 Data Modeling tool.
  • Good understanding of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle, TeraData, DB2, and SQL Server 2000 using Informatica Powercenter.
  • Strong experience in data extraction and migration from legacy systems using Informatica
  • Experience in relational database development using PL/SQL and SQL in various relational databases like Oracle, SQL Server, and DB2.
  • Extensive experience in error handling and remediation using Informatica.
  • Good experience in Oracle Golden Gate CDC (Change Data Capture), Informatica Data Quality and Informatica Powercenter Data Analyzer.
  • Experience in writing shell scripting for various ETL needs.
  • Good knowledge of Installing and Configuring Power Center 7/8.
  • Good understanding of SDLC principles.
  • Development experience on Windows NT/2000/XP, UNIX (Solaris, HP UX, AIX) platforms.
  • Excellent communication and interpersonal skills.

Technical Competencies:

ETL Tools: Informatica 5.x/6.x/7.x/8.x (Power Mart & Power Center)
Data Modeling Tools: Erwin 3.x/4.x, MS – Visio.
RDBMS: Oracle 10g/9i/8i, DB2, SQL Server 2000, Teradata
Database Tools: SQL *Developer (Oracle), SQL*Plus, TOAD
OLAP: OBIEE 10.1.3.x, Business Object 5.0, COGNOS.
Languages: C, C++, XML, HTML, Visual Basic, SQL, PL/SQL, Perl, Shell Scripting.
Operating Systems: Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Solaris, HP-UX, AIX).
Office Applications: MS-Office 97/2000/XP/2007, Open Office Suites.
Other Application/Software: Informatica Web Services, Autosys

Professional Experience:

Confidential,NC March 09 - Present


Role: Informatica Consultant

The Financial Control Re-Design Reports (FCDR) project development is an overall effort to move much of FAF processing and the production MVS Mainframe system to an Oracle RDBMS system to produce the reports. FCDR involved with two processes, one is Upstream Process and the other one is the Downstream Process. This will help us in generating the reports in a simple and timely manner.

Responsibilities:

  • Performed business and data analysis based on the functional specifications provided by the end users and managers.
  • Worked with subject matter experts and data management team to get information about the business rules for the legacy and new systems.
  • Worked extensively with CSV (flat-file) and Oracle sources.
  • Interacted with data modeling team to better understand, and help design and develop the data model.
  • Created various documents including high-level design documents, mapping documents and knowledge transfer documents.
  • Developed the transformation logic for both reference as well as transactional data flow from Legacy to New, and New to Legacy systems.
  • Developed multiple ETL processes to synchronize data between Legacy and New systems, moving in both directions (Old to New and New to Old).
  • Sourced transaction data being staged by Golden Gate tool CDC (Change Data Capture) through Informatica Powercenter and loaded into the target based on the DML action indicated by Golden Gate.
  • Designed and implemented Exception Remediation process for handling error records coming from the source.
  • Created exception reports for end-users using Informatica Data Analyzer.
  • Worked with various Powercenter transformations like Source Qualifier, Aggregator, Joiner, Union, Lookup, and SQL transformation to name a few.
  • Identified process bottlenecks and implemented performance tuning at mapping and session levels.
  • Used Debugger to troubleshoot cause of invalid results, if any, after running a process.
  • Wrote shell scripts using Command task when dealing with flat-file sources for some processes.
  • Wrote complex SQL queries in order to perform unit testing for validating output data.
  • Worked with Autosys team to implement real-time scheduling for transactional ETL processes designed for batch loading.
  • Worked with QA team to find and fix bugs in mappings.
  • Used versioning and labeling options in powercenter to keep track of mapping and workflow changes.
  • Developed mappings for other Informatica ETL based projects.
  • Performed knowledge transfer to the production support team.

Environment:Informatica Power Center 8.6.1, SQL Developer 2.1.1,Mainframe Sources (SVAM), Oracle 10g, Oracle Golden Gate CDC, Informatica Data Analyzer, MS-Visio 2010, Autosys, Unix, Win XP, TOAD.

  • Confidential,Roseville, CA April 07 – March 09

Role- Informatica Consultant

  • This project is to collect all SAP GIS Contract data from BW in order to replace the current data now being provided by ES ODS for Field Material Planning. Material Planning IT will then apply all required business logic to
  • these raw SAP GIS contract data extracts such that the data utilized for Field Material Planning matches the data now being provided by ES ODS. The business process includes three steps: 1. Collect the contract data, 2. Scrub the Data and 3. Feed the data to Xelus Extend as specified in the original BRD. The Field Planning requirement is to ‘extract’ the data from the flat files sent by SAP BW source system(s) to support the MC Min process (CON04), SBD MIN process (MLQ01) and create the necessary feeds for Xelus Extend (CON/CUS). This process is implemented for all the three regions Americas, EMEA and Asia Pacific.

Responsibilities:

  • Played a key role in the project as an application design Analyst and as a lead Developer.
  • Involved in Meetings with technical and program staff to determine business scope and technical requirements.
  • Involved in the Analysis, Design and dimensional Modeling.
  • Worked on Source to Target Mappings and Design Documents.
  • Involved in designing the database structure for data staging area and loading the BW data in to Fireplace Database.
  • Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
  • Involved in the development of Informatica mappings, sessions and workflows.
  • Involved in creating stored procedures and packages to facilitate the data movement from end to end.
  • Involved in writing the UNIX and PERL scripts to automate the ETL process.
  • Involved in creating TIDAL jobs for scheduling Informatica process.
  • Involved in Creating test plan validation documents.
  • Involved in system integration test, user acceptance test (UAT) and MTP the process.

Environment: Windows NT, HP UNIX, Power Center 7.1, Oracle 10g, PLSQL, TOAD, Beyond compare, ERWIN, Tidal job scheduler.

Confidential,CA July 06 – March 07


Role- Informatica Consultant

This project is to develop a new Facility data mart that will include licensing data for all State-licensed facilities and serve as the facility dimension for both the IP and EDAS data marts, and for future data marts and enterprise reporting. The main goals of subject area data mart will be to Enable enterprise management and dissemination of facility data to support cross subject area reporting for OSHPD, Automate facility updates between the new data mart and the Enterprise Geographic Information System (EGIS) vector database, Create a uniform facility fact and dimension and Provide expanded facility reporting capability for the IP and EDAS subject areas (data marts).

Responsibilities:

  • Upgraded Informatica from 6.2 to 8.1.1 on Windows 2003 and performed Admin role.
  • Involved in Meetings with technical and program staff to determine business scope and technical requirements.
  • Involved in the Analysis, Design and dimensional Modeling.
  • Worked on Star Schema, Source to Target Mappings and Design Documents.
  • Involved in designing the database structure for staging area.
  • Worked on Informatica tool -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, and Transformations.
  • Involved in the development of Informatica mappings and tuned for better performance. Worked closely with the DBAs and end users.
  • ETL Scripts for loading expanded licensing data for the expanded facility dimension from the ALIRTS database and for loading facility licensing data into the EGIS vector database and sourcing geographic attribute data from the EGIS vector database.
  • Written views in Oracle to facilitate the data movement.
  • Involved in Creating test plan validation document.
  • Involved in Unit test, integration test and the MTP process.
  • Involved in level 2 production support.
  • Training/knowledge transfer for ISS users on database design, ETL scripts, Business Objects Universe changes, and maintenance processes
  • Final System Documentation and Documentation for the maintenance and support services.

Environment: Windows NT, Informatica PowerCenter7.1/8.1.1, Oracle 9i/10g, SQL Server 7.0/7.5,TOAD, Beyond compare, ERWIN.

Confidential,Cleveland, OH Jan 05 – July 06


Position: ETL Developer

Key Bank businesses comprise the financial service sector’s most diverse consumer product offerings — banking services, credit cards, loans etc. This Project required building a data warehouse for business analysis, where source data containing credit/debit card transactions, checking/saving accounts transactions were transformed to view 5 years of historical monthly snapshot data on every account.

Responsibilities:
  • Performed business analysis and requirements per high-end users and managers and performed requirement gathering.
  • Extracted Erwin physical models into repository manager using Informatica.
  • Studied the existing OLTP systems and created facts, dimensions and star schema representation for the datamart using Erwin.
  • used SQL*Loader to first write the target rows to a flat file and then upload the data to the tables in the Oracle database.
  • Extensively worked on Informatica 7.1 and its tools; Repository Manager, Mapping Designer, Mapplet Designer, Transformation Developer, Warehouse Designer, Workflow Manager and Workflow Monitor.
  • Developed complex mappings and mapplets using corresponding sources, transformations and targets.
  • Implemented Slowly Changing Dimensions (SCDs, Type 1, Type 2 and Type 3).
  • Worked with Oracle, teradata, SQL Server and flat file sources.
  • Developed both usable and reusable tasks like Session, Email, Decision, Assignment, Command and Event Wait and Event Raise.
  • Performed Exception Handling and executed Stored Procedures and Functions using PL/ SQL
  • Used SQL*Loader for bulk loading the data into the target tables.
  • Implemented SOA (Service oriented Architecture) using Informatica as ETL tool.
  • Implemented Performance Tuning for transformations to increase the session performance time.
  • Used TOAD 8.0 to analyze the execution of SQL queries for performance tuning purposes.
  • Worked extensively on SQL, PL/SQL, Perl and Unix shell scripting.
  • Used parallel processing capabilities and Session-Partitioning and Target Table partitioning utilities.
  • Executed workflows using the pmcmd commands.
  • Used session and workflow error logs to debug the session and find problems in the mapping.
  • Developed Datawarehouse to view 5 years of historical monthly snapshot.
  • Used Debugger to create debug sessions and break points to test the mappings developed

Environment: Informatica PowerCenter 7.1, Unix, Perl, Windows NT, TOAD 8.0, Oracle 9i,TeraData, Flat files, SQL Server 2000, SQL*Loader, PL/SQL, MS Visio.

Confidential,Bloomington, IL Sept 03 – Dec 05


Role- Informatica Consultant

Project Description: State Farm Group is one of the largest multi-line insurers in the North American property/casualty industry. State Farm has been the leading provider of workers compensation insurance, programs and services. The primary objective of this project is to get data from different sources (DB2, Oracle, Flat files) and perform the necessary operations on the data as per the user requirement and load it on to the Oracle which will eventually be used by other applications like PAL claims.

Responsibilities:

  • Involved in Designing the specifications, Design Documents, Data modeling and design of data warehouse.
  • Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
  • Created Informatica Mappings to load data using transformations.
  • Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
  • Cleansed the source, extracted and transformed data with business rules, implemented Boolean logic to address complex business requirements, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
  • Involved in the development of Informatica mappings and also performed tuning for better performance.
  • Extensively worked on tuning and there by improving the load time.
  • Extensively used PL/SQL for creating packages, procedures and functions.
  • Written Unix Shell Scripts for getting the data from all systems to the data warehousing system. The data was standardized to store various business units in tables.
  • Created Data warehouse to load the data in Oracle.
  • Tested the target data against source system tables by writing Some QA Procedures.
  • Tested all the applications and transported the data to the target Warehouse Oracle tables.
  • Created documentation for the Informatica processes, naming conventions and best practices.

Environment: Informatica PowerCenter 6.2, UNIX, Oracle8i/9i, SQL, PL/SQL, SQL * Loader, HP UNIX, Windows NT, SQL * Loader, TOAD, MS Visio.

Confidential,India June 02 - August 03


Position: Database Developer/Informatica Trainee

ICICI is a diversified financial service company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The data warehouse was primarily designed to provide Marketing Managers with the complete understanding of customer pattern (market based analysis) and their preference (Trend Analysis). This data warehouse was later extended to cater the needs of Sales, Marketing and Human Resources.

Responsibilities:
  • Installed and Configured Informatica 5.1
  • Created necessary Repositories to handle the metadata in the ETL process
  • Performed Extraction, Transformation and Loading Process
  • Created Dimension Tables and Fact Tables based on the warehouse design.
  • Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates
  • Integrated various sources in to the Staging area in Data warehouse to Integrate and for Cleansing data.
  • Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema
  • Created the Source and Target Definitions in Informatica PowerCenter Designer
  • Created Reusable Transformations and Mapplets to use in Multiple Mappings
  • Created Sessions and Batches using Server Manager for data movement through Mappings

Environment: Informatica 5.1, SQL Server 2000, Flat Files, SQL, PL/SQL, MS Visio, Windows 2000.

Educational Qualifications:

    • Bachelor of Technology.

We'd love your feedback!