We provide IT Staff Augmentation Services!

Dw /etl Informatica Resume

Windsor, CT


  • I.T Professional with 8 years of experience in application designing, development and implementation of Data Warehouses & Data Marts using ETL tools for Banking, Pharmacy, Insurance and Utilities industries.
  • Extensive experience in requirement gathering from business users to create Functional Specification Document (FSD) used by ETL/BI teams to build ETL/BI architecture.
  • Extensive experience in implementing business requirements, error handling, job control & job auditing using informatica PowerCenter tool.
  • Extensive experience with Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0/6.2/6.1 Client tools - Designer, Repository Manager, Workflow manager,Workflow Monitor.
  • Extensively worked with complex mappings using various transformations like Filter, Joiner, Router, Source Qualifier, Expression, Union, Unconnected / Connected Lookup, Aggregator, stored procedure, xml parser, normalize, sequence generator, etc.
  • Extensive experience in debugging mappings. Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
  • Extensive experience in design of Operational Data Store and Data Warehousing. Designed Dimensions and Fact tables.
  • Sound knowledge of UNIX Shell scripting & UNIX commands in Solaris, HP-UX, AIX environments.
  • Sound knowledge of RDBMS concepts, SQL, PL/SQL (Oracle 10G, Oracle 9i, Sql Server 200X, DB2, Teradata).
  • Excellent Informatica Administration skills like installing & configuring Informatica PowerCenter, administering user, privileges, deployment, starting & stopping server, resolving issues with Informatica PowerCenter Server
  • Extensive experience with all tasks in workflow manager to implement job control in Informatica to support dependencies in loading data in target systems including Pre-Post session commands/SQL
  • Created Technical design document from functional specification, operational manuals to support production environments.
  • Good knowledge in Business Objects. Created various list reports, cross tab reports, charts etc.
  • Sound knowledge of SDLC process and various deliverables in SDLC
  • Analyzed Business and Functional Specifications and assisted the QA team for writing a comprehensive test plan / writing test cases.
  • Experienced in creating ER diagrams in ERwin and documenting existing entities.
  • Experienced in Dimensional Modeling using Kimball and Inmon approach.
  • Experienced in creating Star and Snowflake Schemas.
  • Highly motivated, Reliable, Responsible, Good team player & communicate issue and risk appropriately to projects members

Education: Bachelor's In Computer Science.

Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0/6.2/6.1 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 6.2/6.1/5.1.2/5.1.1/4.7, Power Connect, Power Plug, Power Analyzer, Power Exchange, Datamart, ETL, OLAP, ROLAP, MOLAP, OLTP, Autosys, Control M, Maestro.SAP BO 3.4, Business Objects XI R3-R2-R1/6.1/6.5/5.1.6/5.1.QlikView 9.0/8.5, AIX, HP-UX, Sun Solaris 5.8, Windows XP/NT,DB2,Sql Server, Oracle 11g/10G/9i/8i, MSSQL Server 200X, DB2 8.0/7.0/6.0, TeradataV2R6/V2R5, C, SQL, PL/SQL, Shell programming ERwin 7.2/4.5/4.2/3.5/3.X, Power Designer, Toad, Embarcadero DB Artisan, SSH Secure Shell, putty, Liquid Editor Studio

Projects Summary:

Confidential, Windsor, CT 1/2012- Present

DW /ETL Informatica Developer

Project: 5010 Cigna (HP)
This was a defect resolution project and requirement for new enhancements to existing ODS (Operational Data store). This was a very high visibility/fast paced project in order to meet the 5010 compliance deadline. Another tower of this project also involved across the board performance tuning and developing reports.

  • The project mainly focused on solving defects and improving the performance of various production cycles.
  • Created Informatica sessions in workflow manager to load the data from staging to Target database.
  • Responsible for systems analysis, development, enhancement, maintenance and support of Oracle based Data Warehouse Applications.
  • Installed & documented the Informatica setup on multiple environments.
  • Designed, Developed, Deployed and implemented ETL mappings using Informatica.
  • Transformed business requirements into effective technology solutions by creating Technical Specifications for the ETL from the Functional Specifications.
  • Developed new and modified the existing Informatica mappings and workflows based on specifications.
  • Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation. Developed Oracle PL/SQL Packages, Procedures, Functions and Database Triggers.
  • Wrote functions and triggers using PL/SQL. Reviewed and documented existing scripts.
  • Identified and fixed bottlenecks and tuned the complex Informatica mappings for optimized performance.
  • Prepared, documented unit test plans and resolved issues escalated from system testing.
  • Collaborated with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
  • Coordinating with source system owners, performed data migration and monitored day-to-day ETL progress, Data warehouse target schema Design (Star Schema) and maintenance.
  • Used Scrum approach for solving the defects. Monitored SYT & SIT workflow cycles
  • Worked with 837IB and OB, 835 claims transactions.
  • Implemented various slowing changing mappings based on the related Star Schema data model
  • Data Warehouse Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling).
  • Dimensional Modeling for creation of Star Schema and Snow Flake Schema
  • Used Incremental aggregation for CDC (Change Data Capture).
  • Balanced Load transformation on servers using PDO
  • Created reports using BO and Qlikview and involved in developing report using BO and developed tabular matrix, parameterized chart reports.

Environment: Informatica PowerCenter 9.5/9.0.1, IDQ,SAP Business Objects 3.4, Oracle 11g, BAM (Oracle), BPM, TPG flat files, HP-UX B.11.31 (U ia64), HP ALM, HP Quality Center 10.00, Erwin 7.2, Sql Developer & Toad, shell scripting, Qlik View 9.0/8.5, Tidal Scheduler

Confidential, New York 11/2009 - 12/2011

Sr. DW/ETL Informatica Developer

This Data warehouse Application was built for the Credit Cards Division and was aimed at building a data mart for Sales analysis (which is called Sales Performance data mart). The project involves providing online credit and liability information to customers and management. The project aimed at facilitating faster credit processing for the customer and also help in assessing and containing the credit risk for the bank. The project has interface with a number of subsystems, which provide it real time information to provide the global picture of a customer. This ETL initiative gets data feeds from various source systems across the globe.

  • Created Technical Design Specifications, Unit test document based on functional design specifications provided by Business Analyst
  • Designed and developed ETL Processes based on business rules, job control mechanism using Informatica Power Center.
  • Worked extensively on complex mappings using source qualifier, joiner, expressions, aggregators, filters, Lookup, update strategy, stored procedure transformations, etc.
  • Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
  • Re-engineered lots of existing mappings to support new/changing business requirements.
  • Monitored production jobs on a daily basis and worked on issues relating to the job failure and restarted failed jobs after correcting the errors.
  • Developed reusable transformations, mapplets, sessions, worklets to make Informatica code very modular and reuse as required
  • Used mapping variables, parameters, workflow variables & parameter files to support change data capture and automate workflow execution process to provide 24x7 available data processing unit via Informatica PC tool.
  • Involved in writing UNIX shell scripts (Pre/Post Session commands) for the Sessions & wrote shell scripts to kickoff workflows, unschedule workflows, get status of workflows.
  • Performed Informatica administration like user, privileges, migrations, starting, stopping pmrep/pmserver. Backup and restore repository service.
  • Supported Informatica upgrade process from 6.2.2 to 8.1.1 by validating regression testing results and providing all application details for upgrade consultant to perform application upgrade in Informatica.
  • Performed unit testing, system integration testing, and supported user acceptance testing.
  • Tuned SQL statements, Informatica mappings, used Informatica parallelism options to speed up data loading to meet defined SLA
  • Collaborated with Project Manager, Tech Lead, Developers, QA teams and Business SMEs to ensure delivered solutions optimally support the achievement of business outcomes.
  • Supported Informatica, non-informatica code migration between environments (DEV/QA/PRD)
  • Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
  • Developed Oracle PL/SQL Packages, Procedures, Functions and Database Triggers.
  • Created list reports, Crosstab reports, charts reports in Business Objects BO. Used @Where clause, @Prompt and @Variable at Universe level.
  • Used Prompts, variables at report level. Generated reports using Web Intelligence through Infoview.
  • Data Warehouse Data modeling based on the client requirement using Erwin (Conceptual, Logical and Physical Data Modeling).
  • Dimensional Modeling for creation of Star Schema and Snow Flake Schema

Environment: Informatica PowerCenter 9.1/8.6, Repository Manager, Designer, Work Flow Manager, Oracle 11g/10g , SQL Server 2008/2005, B2B, Teradata V2R6/V2R5, XML Files, Flat Files, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), BO XI 3.4, QlikView 9.0/8.5, Autosys, Erwin 7.2, OLTP, MS Visio, SQL Developer, iSQL*Plus, TOAD, Windows 2003/2007, UNIX AIX 5.3, UNIX, Toad, MDM

Confidential, Columbus, OH 7/2007 - 11/2009
ETL Developer/Administrator
Confidential, is a greeting card company that is mainly into Greeting card market. The main goal of this project is to build Data Warehouse & marts to provide inventory in-house, distributions, sales data and survey data.

  • Assisted in the dimensional database design (Star schema). Reviewed multiple data source systems and recommended data acquisition and transformation strategy.
  • Using Informatica ETL tool created detailed mappings to load data from multiple source databases (SQL server, Oracle, Terdata) and flat files to target Oracle Database. Implemented Aggregator, Joiner, Sorter, Router, Lookup, Update Strategy and Stored procedure transformations to optimize mappings.
  • Responsible for data modeling using ERwin 3.5.2
  • Designed data warehouse and data marts from scratch and fine tuned existing data warehouses.
  • Designed and developed several ETL scripts using Informatica, UNIX shell scripts.
  • Created and monitored Sessions and Batch jobs to execute the mappings. Provided primary support for divisional DataMart applications.
  • Developed and modified UNIX shell scripts to reset and run Informatica workflows using Pmcmd (startworkflow, getworkflowdetails, schedworkflow, etc) on UNIX Environment.
  • Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
  • Experience with upgrading repositories from 6.x to 7.1 version of Informatica.
  • Analyzed and recommended solutions within an Enterprise Data Warehousing environment
  • Analyzed, designed, developed, deployed, and maintained the Multidimensional OLAP Cubes, drill-through targets for the Cubes, Impromptu Web Reports, PowerPlay Portable Reports and ReportNet Reports
  • Created reports like Cross Tab, Stored Procedure, Invoices and many more reports in Impromptu.
  • Created cubes and published cubes using PowerPlay Transformer and created explorer & reporter reports using PowerPlay
  • Wrote stored procedures, functions. Occasionally Extracted data from other Oracle databases using Database Links.

Environment: Informatica PowerCenter 7.1/6.2.2/6.1,Microsoft SQL Server 2000, Oracle 9i/8i, Flat Files,B2B, IBM DB2 8.0 SQL Plus, PL/SQL, UNIX Shell Scripting, Linux, Windows XP, Erwin 4.2/3.5 ,QlikView 8.5, Business Objects XI 6.5, Cognos Impromptu 8.0/7.0/6.6/6.x

Confidential, New York 1/2006 - 6/2007

ETL Developer
Involved in Risk Data analysis System allowing the traders and risk mangers to see daily risk exposure by strategy, account, security, region and sector, project involved building a data warehouse by applying the business rules that pulled data from different source systems. This data warehouse helped the management in understanding the company's current status and helped them adjusting business policies and objectives.

  • Gathered business requirements, analyzing the requirements and writing detail design documents.
  • Coordinated the requirements from external clients.
  • Evaluated and documented existing processes for improvements.
  • Worked on various transformations like Lookup, Aggregator, Expression, Router, Filter, Update Strategy, and Stored Procedure.
  • Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session.
  • Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before normal run of the Workflow.
  • Involved in updating the logical model with all related entities, attributes and relationship with each entity based on the business rules/requirements using ERWIN.
  • Extensively worked with Repository Manager, Designer, Workflow Manager and Workflow Monitor.
  • Worked with Informatica Best Practices guidelines to minimize performance issues.
  • Designed mappings involving target load order and constraint based loading.
  • Wrote Stored Procedures and anonymous PL/SQL blocks.
  • Actively involved in end user training and support.
  • Assisted other team members with various technical issues.
  • Occasionally developed reports in Business Objects using universe as well as writing ad-hoc queries.
  • Involved in writing test cases, assisting Testing Team in System Testing.

Environment: Informatica PowerCenter 6.2.2/6.1, Oracle 9i/8.1.7,SQL Server 2000, Erwin 3.5, MSExcel, PLSQL, TOAD, UNIX, Business Objects 5.1.4.

Confidential, Hyderabad, India1/2005 - 12/2005

Database Developer /Data Modeler

Confidential, is one of the leading market research companies in world providing market research solutions to various clients.

  • Responsible for Business Analysis and Requirements gathering.
  • Designing the database from scratch and Relational Data Mart.
  • Designed the ER diagram using ERwin and Visio.
  • Wrote PL/SQL Stored procedures, functions, and anonymous PL/SQL block.
  • Designed and developed all the tables, views for the system in Oracle.
  • Created indexes, sequences, constraints and snapshots.
  • Developed Oracle PL/SQL Packages, Procedures, Functions and Database Triggers.
  • Wrote test cases for various conditions.
  • Involved in Unit Testing / System Testing.
  • Wrote stored procedures to summarize data.
  • Wrote functions and triggers using PL/SQL. Reviewed and documented existing scripts.
  • Wrote Test Cases and developed Unit Test Plan.

Environment: Oracle 8i/7, PL/SQL, SQL Plus.

Hire Now