EXPERTISE SUMMARY:

• 7+ years’ experience working as ETL developer with Informatica Power Center to Design, Develop, Analyze, Maintain and Test Data Warehouse applications. To develop complex ETL Packages.
• Excellent capabilities in developing and maintaining mappings for Type I, Type II, and Type III slowly changing dimensions.
• Experience in development, configuration and management of Informatica objects.
• Experience working on design reviews and code reviews.
• Experience integrating high level concepts of dynamic cache lookup, shared lookup, and persistence lookup into mappings.
• Experience with large scale ETL solutions and performance optimization techniques like push down optimization and doing change data capture.
• Experience in performance tuning ETL code, mappings, sessions, workflows and stored procedures.
• Experience performing Production Support for projects, troubleshooting and resolving issues.
• Expertise with handling data from external data sources such as Oracle, SQL Server, DB2, XML Files, Flat Files, etc.
• Excellent understanding of dimensional modeling methodologies including Star Schema, Snowflake Schema, Fact and Dimension tables.
• Worked with various sources such as XML, VSAM files, EBCDIC, COBOL files, Relational and Excel Data sources
• Strong understanding of relational database design concepts, Stored Procedures, PL/SQL, T - SQL, Functions, and in depth knowledge of OLAP Solutions.
• Excellent UNIX Skills. Experience writing Shell Scripts and working with UNIX to automate Informatica workflows.
• Experience in Post Production Support of ETL, which included hour’s On-Call support.
• Experience working with ORACLE, SQL Server, and My SQL databases.
• Excellent leadership, analytical, technical, and communication skills.
• Experience working in a fast paced time constrained environment.
• Good Problem solving skills, self-directed and dedicated with strong communication and analytical skills. Ability to multi-task.

TECHNICAL SKILLS:

ETL Tools: Informatica power center 9.x/8.x, Informatica Power Exchange 8.x.

Languages: SQL, Shell Scripting, PL/SQL.

Database: Oracle 11g/10g/9i, SQL Server 2008/2005, My SQL 5.0/4.1, Editors (SQL Navigator, Toad)

Operating System: Windows XP/2003/98, Win NT, UNIX

Data Modeling: Bill-Inmon Methodology, Visio Ralph-Kimball Methodology, Dimension Data Modeling, Physical and Logical Modeling, Snow Flake Schema, Star Schema, Dimension Tables, Fact Tables, Normalization, Denormalization.

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Senior Informatica Developer

Environnent: Informatica 9.1, DB2, Oracle, Win7, Citrix.

Responsibilities:

• Detailed analysis and design on Mappings, Mapplets, Worklets for the Clients in order to take precautionary measures.
• Involved in requirement gathering, Build and UAT and Deployment phases.
• Coding system has been created to show the sections to be agreed by each phases, whenever a change of relevance to BU takes place the changes.
• Optimizing Query Performance, Session Performance & Delivering objects for client that is correct an on time.
• Prepared the Documentation to describe program development logic, coding, testing and changes.
• Created the required tables for the current project and Interaction with DBA, Business & Operations.
• Involved in Requirement gathering & Analysis phase.
• Co-ordination with client side IT Team and business users.
• Involved in ETL Testing and UAT (User Acceptance testing).
• Created Informatica mappings with PL/SQL Procedures / Functions/ Triggers to build business rules to load data.
• Implemented SCD Type1 and SCD Type2 techniques to update slowly changing dimension tables.
• Coordinating with teams and ensuring the activity completion in line with customer expectations.
• Supported project as L3 support
• Understanding change requests and performing impact analysis.
• Perform impact analysis and communicate to other team members.
• Lights on support to Confidential Data warehouse
• Created database objects like views, Mview’s and etc as per the requirements.

Confidential, Houston, TX

Senior Informatica Developer

Environnent: Informatica 9.1, DB2, SQL Server, Unix, Win7, Citrix.

Responsibilities:

• Leading the Team of 3 sharing the work among the team and review.
• Design & implement ETL requirements
• Deployment has been done through the Repository, restoring the data backups.
• Generalized component development using various transformations
• Involved in Peer review activities for Code & Testing.
• Focus on analyzing the existing ETL structure and existing OWB mappings and the shell scripts.
• Perform impact analysis and communicate to other team members.
• Analyzing and developing new datasets.
• Prepare technical designs and detailed designs for the ETL approach document.
• Schedule the jobs through Jobs scheduler
• Developed mappings for policy, claims dimension tables
• Developed Informatica mappings and also tuned them for better performance
• with PL/SQL Procedures/Functions to build business rules to load data.
• Created Schema objects like Indexes, Views, and Sequences.
• Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.
• Understanding the application data & business requirement.
• Identify the sensitive information and develop processes to protect it
• Understanding data requirements for test and development
• Involved in Implementation.
• Handling the Team and Preparing the POC.

Confidential

Senior ETL Developer

Environment: Informatica 9.1, Oracle 10g, Microstrategy.

Responsibilities:

• Developer and tester in the team.
• Interacting with the Business Analyst to gather and understand the business requirements.
• Designing applications as part of design phase of the project.
• Extensively worked with Source Analyser, Warehouse Designer, Transformations
• Analyzing and developing new datasets.
• Prepare technical designs and detailed designs for the ETL approach document.
• Created Informatica mappings with PL/SQL Procedures / Functions/ Triggers to build business rules to load data.
• Implemented SCD Type1 and SCD Type2 techniques to update slowly changing dimension tables.
• Developed unit test scripts and test cases for unit testing and system testing.
• Involved in production deployments of the projects.

Confidential

Senior ETL Developer

Environnent: Informatica 9.1, Teradata 12, Microstrategy, DB2, Oracle, Mainframe, SQL Server, T-

Responsibilities:

• Prepare technical designs and Detailed designs for the ETL approach document
• Perform the impact analysis andcommunicate to client accordingly
• Develop and test complex mappings in Informatica that include un-connected look-up transformation, Stored Procedure transformation and SQL transformation)
• Improve the ETL mappings by performance-tuning using Partitions (Round-Robin, Hash, Pass-through and Key-Range) and bulk load methods.
• Automate the ETL mappings to execute in sequential/parallel through the implementation of Stored procedures and re-usable sessions, worklets in Informatica
• Involved in quality code migration.
• Aftercare support for code implemented to production.
• Developed Complex Reports (Used multiple data providers, Union, Intersection and Master/Detail, cross tab, Charts).
• Planned coordinated and executed Business Objects deployment for End-users and documented the project
• Participate in performance tuning of jobs, which have shown degradation in performance or have started to impact SLAs.
• Co-ordination with client side IT Team and business users
• Coordinating with teams and ensuring the activity completion in line with customer expectations.
• Understanding change requests and performing impact analysis.
• Created database objects like views, Mview’s and etc as per the requirements.
• Developed various Informatica Mappings, Sessions, and workflow to load the data into data warehouse using different transformations like Source Qualifier, Expression, Re-usable transformations, Router, Lookup and Update Strategy.
• Responsible for creating business solutions for Incremental and full load
• Batch job monitoring (24x7) including Month End, Quarter End and Year-End Support.
• Creating reconciliation scripts to ensure the data present in the data warehouse is same as the one, which is available in the source systems.
• Implemented performance tuning in Informatica Mappings by identifying the bottlenecks.
• POC for development activities & Involved in Peer Reviews.
• Involved in testing Phase of UAT (User Acceptance testing)
• Ensuring the quality of the deliverables
• Creation and execution of unit tests cases.
• Bug Fixing & error resolution.

Confidential

ETL Develope

Environnent: Informatica 8.6, Oracle, DB2, SAP R/3 GUI, TOAD, Mallard, Win XP.

Responsibilities:

• Build the Acquire and Localize processes based on mapping documents and direction from Data Leads, Super Users.
• Involved in new object development we have never loaded before by developing Informatica Mappings and Workflows.
• Add new data cleansing rules, Bug fix to localize based on data action inputs from data leads and Super user’s inputs.
• Working Informatica PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer and Transformation Developer.
• Using most of the transformations such as the Source Qualifier, Application Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, and Joiner.
• Using Developed SQL scripts for business data loads.
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica client Tools.
• Using shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Using Workflow Manager for workflows and session management, Database connection management.
• Supported the system as L2 Support.
• Optimizing Query Performance, Session Performance.
• Delivering objects for client that is correct an on time.
• Prepared the Documentation to describe program development, logic, coding, testing, changes and corrections.:
• Monitoring the jobs handle in 3 refreshes (CORP, APAC and EMEA).
• Attend & Resolve when the production job fails.
• Escalation to existing CDW SMEs in case the issue cannot be resolved and / or pertains to data.
• Receiving pages from the Cisco Operations Team for any failed jobs in CDW production environment. Acknowledging (via ST chat) to the Cisco Operations team that the issue(s) is being looked at.
• Alliance remedy tool is being used for case management.
• The Team has to proactively work on the PVCS, $Universe, Informatica, Teradata and Linux.
• Running Month end / Quarter end jobs (most of them need manual intervention) and resolving issue(s).
• Communication to the concerned mail aliases for any failure that results in missing the existing.
• SLAs for reasons within / beyond our control.
• Interaction with DBA, Sys-Admin s, Operations & $U teams.
• Participate in the infrastructure process improvement and tool improvement of any existing tools as well as participate in the definition any new processes and tools as needed
• Help the application support team in case of any issues.
• Proactively participate in performance tuning of jobs, which have shown degradation in performance or have started to impact SLAs.