We provide IT Staff Augmentation Services!

Senior Informatica Developer Resume

2.00/5 (Submit Your Rating)

PROFILE

  • 7+ years of total IT experience
  • 5+ years of Informatica experience
  • 2 years of Business Intelligence experience.

SUMMARY:

  • SDLC: 7+ years of IT experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Banking, Financial, Hospitality, Insurance and Telecom Industries.
  • Informatica: 5+ years of Data Warehousing experience using Informatica Power Center 8.6/8.1.1/8.0/7.1.2/7.1.1/7.0/6.1, Informatica Designer, ETL OLAP, OLTP.
  • Databases: 7+ years experience in dealing with various Data sources like Oracle 10g/9i/8i, Oracle PL/SQL, SQL Server 2000 /2005,Teradata , DB2, Ms-Access, MS – Excel and Flat files.
  • Data Modeling: 4years of Dimensional Data Modeling experience on Data modeling, ERwin 4.5/4.0/3.5.5/3.5.2, Dimensional Modeling, Ralph Kimball Approach, Star Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
  • Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
  • Involved in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages and complex SQL queries for extracting the data to system.
  • Transformations: Experience in creating Mappings and Mapplets using various Connected and Unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator and Update Strategy transformations.
  • Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
  • Worked exclusively on implementing the types of Slowly changing dimensions (SCDs)- Type I II and IIIindifferent mappings as per the requirements.
  • Data Cleansing: 5 years of Data Cleansing experience using UNIX Shell Scripting and SQL coding.
  • Designed and developed ETL workflows to work with various sources and targets like MS SQL Server, DB2, Oracle, My SQL and Flat files.
  • Performance tuning: Expertise in session partitioning, session tuning by optimizing Source, target, mappings and transformations.
  • Documentation: Expertise in preparing the ETL Design Documents like High Level and low level Design documents.
  • Implemented the command line commands like pmcmd and infacmd to perform tasks from any machine in the PowerCenter environment
  • Used different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.
  • Involved in the Unit testing , System integration testing and UAT using Quality Center.
  • Have worked on Business Analytical Reporting using BI Tools like Business Objects and Cognos 7.0.
  • Involved in scheduling the workflows through Job scheduler using UNIX scripts.

EDUCATION & CERTIFICATIONS

  • Masters in Computer Applications
  • Bachelors in Science
  • Oracle Certified Associate

TECHNICAL SKILLS

Data Warehousing

Informatica Power Center 8.6.1/8.1.1/8.0/7.1.2/7.1.1/7.0/6.1/5.1.1/4.7, Informatica Designer, Workflow Manager, Work flow Monitor, ETL, Datamart, OLAP, OLTP, Mapplet, Transformations, Toad, SQL*Plus, SQL*Loader , SQL, PL/SQL.

Dimensional Data Modeling

Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, ERWIN 4.5/4.0/3.5.5/3.5.2

  • BI Tools
  • Business Objects 6.5/6.0/5.x, Oracle Reports 9i, Cognos Series 7.0/6.0, Oracle Business Intelligence(OBIEE) 10.1.3

Databases

Oracle 10g/9i/8i/8.0/7.0, IBM DB2, MS SQL Server 2005/ 2000/7.0/6.0, Teradata V2R5/V2R4/V2R3, MS Access.

Programming GUI

Visual Basic 6.0/5.0, C, C++, HTML, Unix Shell Scripting

Environment

Sun Solaris 2.6/2.7/2.8/8.0, IBM AIX 4.2/4.3, MS DOS 6.22, Win 3.x/95/98, Win NT, Red Hat Linux, Win XP.

PROFESSIONAL SUMMARY

Confidential,NEW YORK Oct’09 – Till Date Senior Informatica Developer

Confidential,is one of the world\'s largest hotel and leisure companies, with a system that processes over $14 billion in bookings per year including more than $1 billion in online transactions. To support such a vast system they embarked onto this prestigious project. The main aim of the project was to replace its old and conventional Star link system with Valhalla, which in itself comprises of several engines called Booking, Promo, Rates, CPR, EDG, Inventory and Prop .

Responsibilities:

  • Involved in all phases of SDLC from requirement, design, development, testing, Production and support for production environment.
  • Handled 2 Terabytes of data warehouse database.
  • Involved in End-to-End development from OLTP systems to creation of Data Marts.
  • Exclusively worked on the transformations like Aggregator– to get monthly, quarterly, Yearly claim aggregations, Connected & unconnected lookups – get the claim_ids from other tables and also used SQL override to filter the data , Router-toroute the fraud cases and claims settled and Sequence Generator.
  • Involved in Performance tuning of different tables like FIRST_RESERVATIONS table which has data around 1 TB by creating partitions and using stored procedures.
  • Also involved in tuning the mappings in the transformations by tracking the reader, writer , transformation threads in the session logs and used tracing level to verbose during development & only with very small data sets.
  • Worked on flat files as sources, targets and lookups.
  • Used PMCMD to start and abort sessions and tasks. Also used INFACMD to track the status of the applications and also automate the service notification emails.
  • Implementedvarious optimization techniques in Aggregator, Lookup, and Joiner transformation.
  • Developed mappings/sessions using Informatica Power Center 8.6 / 7.1 for data loading. Developed mapping to load the data in slowly changing dimension (SCD).
  • Used Informatica parameter files to filter the daily data from the source system.
  • Involved in Data Quality Analysis to determine the cleansing requirements.
  • Used various debugging techniques and informatica debugger tool to debug the mappings.
  • Creating Test cases for Unit Test, System Integration Test and UAT to check the data quality.
  • Created Oracle Stored Procedure to implement complex business logic for better performance.
  • Created Materialized view for summary data to improve the query performance
  • Responsible for loading data into warehouse from different sources using Oracle loader to load millions of records and used Import/Export utility to load small tables.
  • Responsible for scheduling the workflow based on the nightly load.
  • Supported Oracle 10g databases running mission critical 24*7 systems.
  • Used PMCMD extensively to start, stop, schedule, and monitor infomratica workflows.

Environment:Informatica Power Center 8.6/7.1.1, Oracle 9i & 10g, PL/SQL, Goldengate,
Microstrategy 7i, Mainframe DB2, MS Visio, ERWIN Data Modeling tool, TOAD, Windows 2000,
UNIX AIX 5.1

Confidential, COLUMBUS , OH Dec’07 - Sep’09
Senior Informatica Developer

Confidential,is one of the largest insurance and financial services companies of the world. It offers a full range of insurance and financial products for home, car, family, and financial security. The main objective of the project was to track and analyze the time taken for claim settlement which indeed concentrates on reducing the business loss. Informatica Power Center 7.0/6 was used as ETL tool to extract data from source system to target systems. Implemented various loading techniques like Slowly Changing Dimensions and Incremental Loading ,constraint based loading.

Responsibilities:

  • Extensively used ETL to load data from Oracle database, My SQL , DB2, Excel sheets, flat files to different target systems.
  • Expertise with connected and unconnected transformations like look up , Stored procedure ,aggregator , Expression transformations.
  • Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
  • Created the data models using the Erwin modeler.
  • Worked with the flat files in both the direct and indirect methods and also worked with XML files.
  • Used the techniques like Incremental aggregation, Incremental load and Constraint based loading for better performance.
  • Created Reusable Transformations, Mapplets, Sessions and Worklets and made use of the Shared Folder concept using shortcuts wherever possible to avoid redundancy.
  • Understand business process and draft technical design documents based on the functional documents.
  • Involved in the development of Informatica mappings and also tuned the session for better performance by implementing the pre/post-load stored procedures for target optimization.
  • Used various Oracle Index techniques and partitioning concepts on databases to improve the query performance.
  • Extensively worked on client information stored in Oracle database using Toad.
  • Worked on the Database Triggers, Stored Procedures, Functions and Database Constraints.
  • Written Unix Scripts for event automation which included PMCMD to start the workflows.
  • Generated reports using MS Access Reports.

Environment: Informatica PowerCenter 7.1, Informatica PowerMart, MS Access Reports, Unix Shell Scripting, SQL*Plus, ERwin , SQL*Loader, MS SQL Server 2000, Sun Solaris 2.7, DB2 .

Confidential, COLUMBUS, OH Oct’05 - Nov’07
ETL Informatica Developer

This project involved working with a financial data warehouse fed periodically by source systems. Scope of the project was maintenance of the CRPS DWH. The DWH maintains the customer information, financial balance details of the customer and different bank branch details. Reporting involved like city wise customer reports, customer grade reports floating balance reports, valuable customer reports, branch performance details reports etc. some of these reports are mission critical as those contained financial data and was critical for business planning.

Responsibilities:

  • Interacted with the business community and database administrators to identify the business requirements and data realties.
  • Created Design Document and Informatica mappings based on business requirement.
  • Created dimensions and fact tables for the project.
  • Used update strategy and implemented SCD type-3 to effectively migrate data from source to target.
  • Moved the mappings from development environment to test environment and then to production environments.
  • Worked on lookup, aggregator and joiner caches for performance enhancements .
  • Involved in designing of Testing plan (Unit Testing and system testing)
  • Played a vital role in moving the project to Production and prepared the documentation at every level.
  • Tested scripts by running workflows and assisted in debugging the failed sessions.
  • Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
  • Used persistent caches whenever data from workflows were to be retained.
  • Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
  • Involved in the Release Management team and verify the Production checklist documents necessary for the Production Activities
  • Used PMCMD to start and abort sessions and tasks. Also used INFACMD to track the status of the applications and also automate the service notification emails.
  • Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
  • Setup Developer Access for Development , QA and Production Environments in Informatica
  • Set up Project Folders in all Environments.
  • Perform Maintenance, including: Manage Space, Remove Bad Files, Remove Cache Files and monitoring services.
  • Set up Permissions for Groups and Users in all Environments (Dev,UAT and Prod)
  • Migration of developed objects across different environments
  • Also involved in conducting and leading the team meetings and providing status report to project manager

Environment: Informatica Power Center 8.1.1/7.1, Business Objects 6.5.1, Oracle 10g/9i, PL/SQL, Windows NT, ERWIN (4.5), PL/SQL Developer, OBIEE 10.1.3.3 ,DB2, and UNIX.

We'd love your feedback!