SUMMARY

• Over 8 Years of diversified IT experience in all phases of Analysis, Design, Development, Implementation,Adminstration and support of Data Warehousing applications.
• Over 7+ years of experience specializing in Informatica PowerCenter 9.x/8.x environment such as Installation and maintaining Informatica Repository and Server processes, performing code migrations and deployment.
• Experience in designing, developing, and implementing Extraction, Transformation, and Load (ETL) techniques on multiple database platforms and operating system environments.
• Expertise in developing, implementing and executing projects in Finance, Health care, Pharmacy and other Domains.
• Worked on data integration, data modeling, data profiling, data quality, data migration with Knowledge on data analyzer tools like Informatica Data Quality (IDQ) and Metadata Manager (MM).
• Knowledge on Data and Dimensional modeling, normalization, E - R diagrams, Logical, Physical design, Star and Snow flake Schemas using Kimball and Inmon DW methodologies.
• Proficient in gathering business requirements, establishing functional specifications and translating them to technical design specifications.
• Proficient in data warehousing techniques for Data cleansing, Slowly Changing Dimension phenomenon’s (SCD) and implemented various Performance Tuning measures in sources, targets, mappings and transformations.
• Experience in Integration of various Relational data sources like Oracle, Teradata, SQL Server and Mainframes and Flat Files into Staging Area.
• Experience with Oracle 10g/11g and in writing Complex SQL queries, PL/SQL stored procedures, functions, packages triggers and materialized views.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases, Executing Test Cases and Test Scripts and perform data validation by Unit Testing, System and Integration Testing and UAT.
• Knowledge on Reporting tools like Microstrategy,OBIEE, Business Objects with an idea of Universes, Reports and adhoc reports.
• Created UNIX scripts for automation of workflows and experience in using Autosys/Control M job scheduler for automation of Unix Shell scripts and batch scheduling.
• Working experience in onsite/offshore model with ability to balance the right amount of documentation and handoff.

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 9.x/8.x, Power Exchange 9.x, IDQ,IDE,Metadata Manager

Data Modelling Tools: Erwin Data Modeler r7, MS Visio 2003

Databases: Oracle 11g/10g, Teradata V2R5/V2R4,IBM DB2, MS SQL Server 2008/ 2005,Netezza

Reporting Tools: Microstrategy

Scheduling Tools: Autosys, Control-M

RDBMS Utilities: SQL*Plus, SQL*Loader, Toad,PL/SQL Developer, BTEQ,, Netezza Workbench

Programming: UNIX Shell Scripting, PL/SQL,PERL

Operating Systems: UNIX(Solaris 10,AIX-7.1),Mainframes, Windows

PROFESSIONAL EXPERIENCE

Confidential, BIRMINGHAM, AL

Sr.Informatica Lead Developer, Architect, Administrator and Prod Support

Environment: Informatica Powercenter 9.5.1,Power Exchange 9.5.1,Informatica Administrator 9.5.1,Informatica Developer (IDQ and IDE),Metadata Manager (Thin Client),Data Masking, Oracle 11g,Microsoft SQL server 2008 R2, Toad for Oracle 12.1,IBM DB2,AIX UNIX 7.1, shell (Korn/bash) Scripting, Remedy,CONTROL-M, FILE-AID,ISPF,C-NET.

Responsibilities:

• Participated in the design of Financial Datamart (FDM) from a normalized entity-relationship business model to dimensional model and to physical model as well as Identifying business rules,facts and dimensions.
• Designed and Developed ETL architecture including the nightly batch process, physical infrastructure of ETL servers and databases.
• Involved in gathering business requirements, establishing functional specifications and translating them to design specifications.
• Experience working on Mainframe Datasets using ISPF in CNET using FILE-AID
• Experience in Mainframe Job Monitoring using BMC CTD and spool for checking status of jobs and submitting JCL jobs using 3.4.
• Knowledge on dimensional modeling to design and develop the STAR Schema using Erwin.
• Worked as an Administrator on creating users, groups, folders, categories and connections in the repository and assigned access privileges.
• Developed mappings using Informatica 9.5.1 to load data from multiple sources and file systems such as Cobol VSAM,Flat files,SEQ files into Oracle tables .
• Extensively Used Informatica client tools like Source Analyzer, Target designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
• Extensively worked with transformations like Lookup, Update Strategy, Expression, Filter, Router, Joiner, and Aggregator.
• Worked on lookup caches like Static, Dynamic, and Persistent in Lookup transformation as per the requirement for better performance.
• Created and used Mapplets and reusable transformations using Informatica Power Center and created data break points and error break points for debugging the mappings using Debugger Wizard.
• Used Mapping parameters, variables and session parameters to dynamically enter values between sessions and to parameterize Relational and Application connections, Filenames and other objects.
• Implemented Performance Tuning measures in source,target,mapping,session design
• Worked on different tasks in Workflows like sessions, event raise, event wait, decision, e-mail, command, Assignment, Timer etc.
• Developed PL/SQL procedures, for creating/dropping of indexes on tables using target pre-load and post-load strategies to improve session performance in bulk loading, for gathering statistics and archiving table Data.
• Created pre-session and post session UNIX scripts for file delete,rename,archive and zipping tasks.
• Responsible for Testing and Validating the Informatica mappings against the pre-defined ETL design standards.
• Implemented Test plans and test cases for unit-test and peer-review Test and Fixed bugs and validated mappings.
• Worked as production support and in finalizing scheduling of workflows using Control M tool and Deployed the Workflows in the production repository and server and supported them through automated Shell scripts.
• Associated with Production team in various performances related issues.
• Coordinated with the reporting team to develop the OLAP reports using Business Objects and supported work for creating Universes, Reports and adhoc reports using Business Objects.

Confidential, Bay Area, CA

Informatica Developer

Environment: Informatica Power Center 8.6.1,Toad 8.5,Oracle 9i, PL/SQL,Teradata V2R4,Flatfiles,Solaris 9, Microsoft Visual SourceSafe 6.0,Windows Power Shell,Microsoft SQL server 2005/2008,Windows server 2003,Solaris 10, shell (Korn/bash) Shell Scripting, Control M.

Responsibilities:

• Involved in gathering business user requirements, understanding the business model (E-R diagrams), database table and query design, extracts and use of report query tools and Identify technical risks, assumptions, and dependencies.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter and Source Qualifier.
• Used various lookup caches like Static, Dynamic, and Persistent in Lookup transformation to identify the incremental data relevant to data flow in ETL process.
• Created complex Informatica mappings, reusable objects of Mapplets depending on client requirements.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions and scheduling them to run at specified time with required frequency.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Wrote shell scripts to perform pre-session and post-session operations.
• Used Autosys for automating Batches and Session.

Confidential, NC

ETL Intern (SQL/ETL Developer)

Environment: Informatica Power Center 8.1, Oracle 9i, Flatfiles, TOAD 8.5, Windows NT, HP-UX11.0, Autosys.

Responsibilities:

• Understanding present process flow and business functionalities and prepare ETL process flow for Predictive analysis.
• Implemented technical specification document for ETL process and Design documents for each module. Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) with Informatica PowerCenter 8.1.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Worked extensively on Mapping Designer to design and create mappings, transformations to implement transformation logic
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems and worked with complex mappings having an average of 15 transformations.
• Extensively involved in Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Extensively worked on tuning of sessions and mappings for better performance.
• Wrote test scripts to validate the data for the testing team. Did unit testing, system integrated testing.Worked with production support in finalizing scheduling of workflows and database scripts using Autosys.