SUMMARY

• 9 years of experience in analysis, design, development, testing, integrating and architecting solutions, migration, reporting, implementation and administration of data warehouse.
• Experience in various databases, reporting and UNIX System
• Business Intelligence - Well versed with DW concepts, Dimensional modeling, Star, Snowflake Schema for designing Data Warehouse/Data Mart.
• Performed analysis, design, development of different Data Warehouses and Data marts.
• ETL Development - Expertise in architect, design, development, testing, implementation and maintenance of data warehouse solutions using ETL tool Informatica PowerCenter 6.1/7.1/8.6.1/9.0.1/9.6 and Power Exchange.
• Expert in developing complex mappings and debugging mappings/sessions to test and fix errors.
• Implemented best practices include processing several files, duplicate management, usage of parameter files, partitions, usage of re-usable components and QA process etc. Expertise in performance tuning of Informatica.
• Exposure in administering Informatica 7.1/8.1/9.0.1 and maintained users/folders.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server, DB2.
• Strong hands on experience using Teradata architecture and utilities (Fast Load, Multi-load, Fast Export, B-TEQ, and SQL Assistant).
• Systems Integration and maintenance - Managed enterprise applications and various teams to deliver scalable, solutions across platforms.
• Successfully integrated Windows, UNIX and Mainframe systems. Provided 24x7support to key production environments.
• Troubleshooting Skills - Skilled in troubleshooting, debugging using Informatica Debugger, diagnosing application, and operating system issues.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS

ETL: Informatica PowerCenter 8.1/8.6.1/9.6/10.1 , Source Analyzer, Mapping Designer, Workflow Monitor, Workflow Manager, Informatica, Data Cleansing, Data Quality, Repository, Metadata, Data Mart, OLAP, OLTP, Web services, DVO

Data modelling tools: Erwin 7.x/ 4.2/3.x, Microsoft Visio

Operating Systems: Windows 2000/2003/NT/XP, Linux, UNIX (Sun Solaris, AIX)

Database: SQL Server 2008/2005/2000 , Oracle 11g/10g/9i, IBM DB2

Web Tools: Java, HTML, XML

Languages: SQL, PL/SQL, C, C++.

Web/Apps Servers: IIS, Tomcat

Tools: TOAD, Visio, Eclipse, HPQC, Tivoli, WLM

PROFESSIONAL EXPERIENCE

Confidential, North Brook, IL

Informatica/ETL Lead

Responsibilities:

• Instrumental in providing technical architecture and direction to the team
• Make sure team is adhering to agreed Allstate standards and methodologies while design and development.
• Be in continuous contact and sync with Allstate technical architects to discuss the status and technical direction of the team
• Resolve the technical issues faced by team during development for example integrating Java code with Informatica for hash value generation using SHA256 algorithm, difficulty in reading large XML files etc.,
• Performance tuning of Informatica mappings to handle large volume of data.
• Worked with the Scheduling/Operations teams for scheduling the ETL jobs on Tivoli
• Developed the complex Informatica/Abinitio ETL artifacts as per the business requirements
• Developed Linux scripts to call ETL jobs and data load jobs.
• Closely worked with DBA’s in defining the schema and data bases objects and resolving the issued related to data loads and fine tuning data loads like analyzing the tables, dropping and rebuilding indices.

Environment: Informatica 9.6, Oracle, UNIX Shell scripts.

Confidential, Woodland Hills, CA

Tech Lead/Sr. ETL Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Managing and guiding the team in design and developing the ETL artifacts.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Reviewed and analysed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 9.1, Informatica, DB2 UDB, UNIX Shell scripts.

Confidential, North Brook, IL

ETL Lead

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production and support for production environment.
• Provide guidance and leading to the team.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 9.1 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Building Reports according to user Requirement.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Extracted data from Oracle and SQL Server then used Oracle for data warehousing.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica 9.1, Oracle 11g, SQL Server 2005, TOAD, HPQC, DVO, UNIX.

Confidential, North Brook, IL.

Sr. ETL Developer

Responsibilities:

• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center9.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.

Environment: Informatica 9.1 Power Center, Oracle 11g, HPQC, UNIX.

Confidential, Lansing, MI

ETL Informatica developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Wrote UNIX scripts for the business needs.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Created Universes and generated reports on using Star Schema.

Environment: Informatica PowerCenter 8.6, Oracle 10g, SQL Developer, UNIX.

Confidential

Informatica developer

Responsibilities:

• Interacted with Business users to understand the Business requirements and prepare technicaldocuments for implementing the solutions as per business needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
• Involved in logical and physical data modeling and analyzed and designed the ETL processes.
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Extensively used Informatica client tools to extract data from different sources like flat files and oracle.
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Daily, Monthly and Yearly Loading of Data.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Involved in Debugging, Troubleshooting, Testing, and Documentation of Data Warehouse.
• Created new Tables, Indexes, and Sequences where needed.
• Creating solution documents for developed mappings.
• Involved in solving day-to-day problems, giving support to the users.
• Communicated issues and progress to project manager.

Environment: Informatica Power Center 8.0, Oracle 9i, SQL, PL/SQL, TOAD 9.0, Windows XP.

Confidential

Informatica developer

Responsibilities:

• Worked as ETL developer.
• Creating the Detail Design Document.
• Developing and modifying changes in mappings & Workflows according to business logic.
• Performed Debugging for Mapping.
• Creating and Executing Unit Test cases.
• Creating Migration check list and KT document.
• Involved in peer review.

Environment: Informatica Power Center 7.1, Sql server, UNIX.