SUMMARY

• 8 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Telecom, Banking, Health care and insurance.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Experienced in Data Warehousing concepts, Dimensional modeling like Star Schema, Relational modeling, Snowflake Schema, 3NF and database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Worked on Administration of Informatica PowerCenter.
• Have extensive experience in doing Informatica platform upgrade, re - plat forming and re-organizing
• Extensive experience in Data Extraction, Transformation and Loading Data using Informatica PowerCenter 9.x/8.x (Admin Console, Informatica Service, Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Worked on slowly changing dimensions like SCD type-1, type-2 and type-3 to maintain the transactional data and historical data for the need of business process and change data capture (CDC) using Informatica applications.
• Installation of Informatica patches and upgrades, user access management, deployment activities, on-call support and capacity planning.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Extensively used Source Qualifier, Connected and Unconnected Lookup, Router, Filter, Expression, Aggregate, Stored Procedure, Sequence Generator, Sorter, Joiner, XML Source Qualifier, Java Transformation, Union transformations and Mapplets.
• Implemented Data Cleansing, Data Analysis, Data Profiling, Transformation Scripts and necessary Test plans to ensure the successful execution of the data loading processes.
• Experience in UNIX shell scripting, FTP and file management in various UNIX environments.
• Experienced in debugging and performance tuning of sources, targets, mappings, and sessions in Informatica.
• Created the SQL Views, Table pairs and created the DVO jobs for validating the Source and Target Tables data as part of Automation Testing.
• Experience on ER Data Modeling tools likeErwin, ER-StudioandVisioin developing Fact & Dimensional tables, Logical and Physical models.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.x/8.x, Informatica Data Quality, Informatica Power Exchange

Operating Systems: Microsoft Windows 7/Vista/XP/2000/NT, UNIX, LINUX

Language: SQL, PL/SQL, XML, UNIX Shell Scripting

Business Intelligence: SAP Business Objects, OBIEE, IBM Cognos

Database: Oracle 11g/10g/9i/8i RAC, SQL Server, DB2 z/OS, Teradata V2R5, Netezza (7.0, 7.1)

Reporting Tools: Crystal Reports, Tableau

Tools: /Utilities: PLSQL Developer, TOAD, SQL Developer, Erwin, Microsoft Visio, Talend 5.3.1

Scheduler: Control-M, AutoSys, Active Batch 7

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Informatica Developer/ Administrator

Responsibilities:

• Performed Informatica Administrator functions like installing and configuring, enabling-disabling and starting-shutting down Repository and Integration services, creating relational connections, Groups Users, Folders, giving permissions on the folders to the users etc.
• Built the Mappings with Informatica 9.5.0 PowerCenter Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, and Stored Procedure.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads and Data Transformations.
• This involved cleansing, consolidating and re-structuring of the data as part of the data conversion and ongoing data integration processes.
• Built Scripts using Unix Shell Scripting and used the scripts in the Pre-Session Command of the session to populate the parameter file.
• Migrated data from Sybase legacy system to oracle 11g.
• Built Shell Script which will FTP the data onto the server in .dat format, merge the file form different organizations and make it into a delimited source file.
• Was involved in the performance tuning mappings, sessions, Source and Target.
• UsedNetezza SQL to maintain ETL frameworks and methodologies in use for the company and also accessedNetezza environment for implementation of ETL solutions.
• Was involved in unittestingby usingDebuggerand writing simple test scripts and eliminating thebottlenecksfor optimumperformance.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Administering High Available multi node informatica environment with sessions running on Grid.
• Configured Master Node and Backup nodes under High Availability environment.
• Performed extraction, transformation and loading of data from RDBMS tables and Flat File sources into Oracle 10g in accordance with requirements and specifications
• Responsible for creating Workflows and sessions usingInformaticaworkflow manager and monitor the workflow run and statistic properties onInformatica Workflow Monitor.
• Experience in Informatica Power Exchange 9.5, 9.6 in pulling mainframe VSAM Files & Flat file and sequential files
• Involved in managing Informatica backup and restores.

Environment: Informatica PowerCenter 9.5, Oracle 11g, Teradata, PLSQL Developer, Informatica Power Exchange, SQL, PLSQL, UNIX Shell Scripting, Autosys, Sybase.

Confidential, St. Louis, Missouri

Informatica Developer/ Admin

Responsibilities:

• Responsible for coordinating with the Business Analysts and users to understand business and functional needs and implement the same into an ETL design document.
• Performed Informatica Administrator functions like creating repository, Groups Users, Folders, giving permissions on the folders to the users etc.
• Developed various Informatica Mappings & Mapplets to load data to ODS using different transformations like Source Qualifier, Joiner, Router, Sorter, Aggregator, Connected and Unconnected Lookup
• Update Strategy, Expression, Stored Procedure, Java, Normalizer, Xml and Sequence Generator to load the data into the target tables.
• Created and Monitored Sessions and various other Tasks such as Decision, Email, Assignment, Command etc using Informatica Workflow Manager.
• Developed and implemented Error Handling Strategies for Informatica ETL process.
• Extensively worked on Informatica Versioning and Deployment Groups.
• Export VSAM copybooks to Power exchange and import to power center for subset/Mask
• Responsible for catering day-to-day administration activities, e.g.
• Environment set up for new applications, debugging issues related to any Informatica job failure, tracking any technical issues and working towards resolving the same, assisting application-testing team if they have any issues etc.
• Worked on Batch Processing or Scheduling and Shell Scripting.
• Worked on Teradata Multi-Load, Teradata Fast-Load utility to load data from Oracle and SQL Server to Teradata.
• Planned and maintained sufficient memory on application servers across the grid for better ETL Load performance
• UsedTeradata Data Moverto copy data and objects such as tables and statistics from one system to another.
• Worked with DBA team to fix performance issues in ETL programs.Coordinate with off-shore resources
• Automated migration process from Serena to Informatica QA and Production environments.
• Closely worked and assisted the QA team during the test cycles to resolve the issues and bug fixing.
• Provided 24 x 7 production support and maintenance for all the applications with the ETL process.
• Worked on Virtual Tickets during production support and used Autosys tool for scheduling.

Environment: Informatica Power Center 8.6, Informatica Power Center Data Profiling, Power Exchange, Informatica Data Explorer, Informatica Data Quality, SQL Server 2005, Teradata, XML, Unix Shell Scripts, DB2,Control M.

Confidential, Albany, NY

Informatica ETL Developer

Responsibilities:

• Analyzed functional specification documents and worked closely with the various application teams and functional teams to design Technical specification documents.
• Studied the data requirements and the impact analysis on the existing schema.
• Participated in the review meetings with functional team to signoff the Technical design document.
• Written Unix Shell Scripts to schedule the Informatica jobs using PMCMD command.
• Created various active and passive transformations to support voluminous loading of data target table using Informatica PowerCenter.
• Designed reusable transformations and mapplets.
• Mapped the source and target databases by studying the specifications and analyzing the required Business logic.
• Responsible for optimizing the ETL mappings and monitoring the load process in order to check the data.
• Performed Informatica administration activities such as code migration from Dev to Test to Production, Creating folders and users and assigning required privileges/permissions
• Involved in identifying surrogate keys for the fact table.
• Defined data definitions, and created target tables in the database.
• Written PL/SQL Procedures, Function and Packages to perform database operations and pre & post session commands.
• Involved in migrating various complex applications between environments and to Production using TBD and version control tools such as Harvest and Serena.
• Prepared User documentation to train users and functionality of each report.

Environment: Informatica PowerCenter 8.6.0, Oracle 10g, PL/SQL, Toad, UNIX, HP Quality Control

Confidential, Madison, WI

Informatica ETL Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Creating the design and technical specifications for the ETL process of the project.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Developer.
• Developed complex mappings using Informatica Power Center Designer to transform and load data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Built in mapping variable/parameters and created parameter files for imparting flexible runs of workflows based on changing variable values.
• Designed and Developed pre-session, post-session routines for Informatica sessions to drop and recreate indexes and key constraints for bulk loading.
• Maintain Development, Test and Production mapping migration Using Repository Manager.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

Environment: Informatica Power Center 8.1, DB2, Control M, UNIX, Oracle, Teradata.

Confidential

Informatica ETL Developer

Responsibilities:

• Analyzed source database (Sybase), designed mapping (using various transformations like Update Strategy, Look Up, Stored Procedure, Router, Filter, Sequence Generator
• Joiner, Aggregate and Expression) to transform and load data on target databases(SQL Server) using Informatica PowerCenter (ETL Tool)
• Analyzed and Resolved issues in Extraction, Transformation and Loading (ETL) Processes, especially in transformation and mapping development
• Debugged invalid mappings using break points, tested stored procedures, functions, Informatica sessions, batches and the target data
• Wrote stored procedures in PL/SQL and UNIX Shell Scripts for automated execution of jobs
• Identified performance bottlenecks and resolved those issues by Query optimization, dropping Indexes and Constraints, bulk loading
• Created reusable transformations and mapplets to use in multiple mappings
• Created complex/ad-hoc reports using Business Objects reporter and exported to the repository
• Generated various reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas as per client requirements

Environment: Informatica PowerCenter 7.1, Sybase, Perl, SQL Server 2000, SQL/PLSQL, UNIX Shell Programming, and Windows 2000.