SUMMARY:

• Professional experience of over 7+ years in the field of Enterprise DataWarehousing, Data Integration and Data/code Migration.
• Experience in all the phases of Data Warehouse life cycle involving Requirement analysis, Design, Coding, Testing and Deployment.
• Expert in Database skills using SQL, PL/SQL Developer for debugging applications.
• Experience in writing stored procedures and functions (PL/SQL).
• Strong SQL experience in Coding and Query tuning. Well versed with Oracle SQL tools like TOAD, SQL developer and SQL Plus.
• Extensively worked on various different ETL mappings, analysis and documentation of OLAP reports requirements.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling such as Star Schema and Snow Flake Schema.
• Extensive experience with informatica powercenter 9.0.1/7.x/6.x
• Extensive experience in Extraction, Transformation and Loading from various sources into Datawarehouses and marts using informatica power center(Repository manager, Designer, workflow manager, workflow monitor).
• Very good understanding of Teradata’s MPP architecture such as Shared Nothing, Nodes,AMPs, BYNET, Partitioning, Primary Indexes etc.
• Extensively created and used various Teradata Set Tables, Multi-Set table, global tables, volatile tables, temp tables.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Experience in writing various ETL procedures in order to load data from different sources like Oracle 10g, DB2, XML Files, Flat Files, MS SQL Server and MS Access into Data marts, Data warehouse using Informatica Power Center.
• Worked on flatfiles both of delimited and fixed length.
• Implemented different Slowly changing dimensions(SCD) using Informatica.
• Designed and developed various complex mappings such as Filter, Router, Connected and Unconnected lookups, update strategy, sorter, Aggregator and Joiner.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Extensive experience in writing UNIX scripts and also automation of the ETL processes using UNIX shell scripting.
• Extensive experience on working with scheduling tools like SAS Management console, Crontab and lsfadmin tools.
• Worked on performance tuning, identifying and resolving various performance bottlenecks at various levels like sources, mapping and sessions.
• Involved in Unit testing, system testing to check whether the data loads in to target are accurate.
• Expert in debugging, troubleshooting, monitoring, and performance tuning of Sources, Mappings, targets and sessions.
• Experience in designing exception handling procedures to identify, record and report errors.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure with Analytical and Technical aptitude with the ability to solve complex problems.
• Can also work very well in a team as well as independently under minimum supervision.
• Excellent written and oral communication, interpersonal skills and presentation skills.
• Experience in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.x/7.x (PowerCenter), Informatica Data Quality 9.5

Data Modeling: Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Data Quality, Entities, Attributes, ER Diagrams.

Databases: Oracle 10g/9i/8i, MS SQL Server 2005/2000, MS Access, Teradata and DB2

Tools: SQL plus, PL/SQL Developer, Toad, SQL* Loader

Query Languages: SQL, PL/SQL, C, C++, Data Structures, UNIX Shell Script, Visual Basic

Job Scheduling Tools: lsfadmin, Crontab, Control-M

Operating Systems: UNIX, Windows NT/2000/2003/XP/Vista/7, MS-DOS

Others: OBIEE,IDQ, MDM, DB2, B2B,HTML,XML, Javascript.

PROFESSIONAL EXPERIENCE:

Confidential, Madison, NJ

Informatica Developer

Responsibilities:

• Understanding the business rules provided to design and develop mapping for the ETL.
• Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load in Oracle warehouse.
• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Understanding the business rules provided to design and develop mapping for the ETL.
• Designed Sources to Targets mappings from Excel/Flat files to Oracle using Informatica Power Center.
• Responsible for working with DBA and Informatica admin for project coordination.
• Estimated the Database space needed based on the data volume and the data structures.
• Responsible for developing complex Informatica mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, Router, Filter, Aggregator, Expression and Update strategy transformations for Large volumes of Datasets.
• Developed complex ETL to dynamically build queries based on the rules provided by the end user.
• Responsible for Error Handling in Workflows and sessions using Informatica workflow manager and monitor the workflow run and statistic properties on Informatica Workflow Monitor.
• Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
• Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
• Doing Change Requirement for complex Informatica Mappings coding with transformations like lookup, router, aggregator, expression, update strategy, joiner and etc.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Designed Sources to Targets mappings from Excel/Flat files, Xml Files to Oracle using Informatica Power Center.
• Worked on data conversion to load the historic data from MSIS systems to TMSIS systems.
• Worked on handling performance issues, Troubleshootingof Informatica Mappings, evaluating current logic for tuning possibilities.
• Extensively worked on SQL queries along with Informatica to enhance the performance of the system.
• Used Autosys for job scheduling.
• Worked on multiple projects using Informatica developer tool(IDQ) of latest versions 9.1.0 and 9.5.1.
• Involved in migration of the mappings from IDQ to power center.
• Applied the rules and profiled the source and target table’s data using IDQ
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements.
• Worked on different environments with different source and target databases like Teradta, DB2 and SQL server.
• Developed the mapping to process multiple flat file as source and staged the data into Teradata and DB2 databases.
• Involved in Data masking for unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Responsible for creating production support documentation.
• Coordinate with business team, get the requirements from them and then coordinate with offshore team to get the work done, keeping timeline in mind.
• Involved in team weekly and by monthly status meetings.

Environment: Informatica Power Center 9.1, IDQ 9.1/9.5.1, Teradata 13.1, Oracle 11g, PL/SQL, UNIX Shell Scripts, Autosys, TOAD, windows XP.

Confidential, NYC, NY

Sr. Informatica Production Support

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules and also involved in analyzing the sources to load in oracle Warehouse.
• Generated E-R diagrams based on the actual values and also relationships held in the source data.
• Prepared ETL specifications in order to help develop mapping.
• Worked with Power center designer tools in developing mappings and mapplets to extract and load the data from flat files, oracle in to oracle database.
• Implemented code using various Informatica Transformations like UNION, Expression, Aggregator, Filter, Sequence Generator, Update Strategy, Source qualifier, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Developed mappings/Reusable Objects/mapplets by using mapping designer, transformation developer and mapplet designer, since different datatype conversions have to be dealt multiple times which are similar and also most of the lookups have been similar
• Worked with different caches in optimizing the transformations such as Index cache, Data cache and Lookup cache (Static, Dynamic, Persistence and Shared).
• Used Informatica Power Center Workflow manager to create sessions, batches to run the mappings daily, biweekly based on the business requirements.
• Implemented different Tasks in workflows which included Session, Command, E-mail, Event-Wait etc.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Created pre-session and post session scripts using UNIX/PL-SQL.
• Tuned the Sources, Targets, Transformations and Mapping to remove bottlenecks for better performance.
• Migrated mappings, sessions, and workflows from development to testing and then to Production environments
• Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Documented Cleansing Rules discovered from data cleansing and profiling.
• Created deployment groups, migrated the code into different environments.
• Worked closely with reporting team to generate various reports.

Environment: Informatica Power Center 9.1/8.6, IDQ 9.5.0, Unix scripting, MS SQL server 2005, Oracle 10g, Quality Toad.

Confidential, Boston, MA

ETL Informatica Developer

Responsibilities:

• Involved from initial stage of the requirement gathering to understand business requirements subjected to business.
• Created new mappings and also modifications in already existing mappings as per the new business rules.
• Analyzed the business requirements and suggested changes to the design accordingly.
• Prepared ETL Specifications to help in developing various mappings.
• Used different transformations such as Expression, Source Qualifier, Lookup, Filter, Update Strategy, aggregate, Router, Sequence generator and Joiner in order to create mappings.
• Created sessions and Workflows for the mappings.
• Documented the mapping process and the process that can be used in order to facilitate future development.
• Interacted with user for his requirements and also involved in various document preparation such as integration test plan, Unit test plan, Deployment Instructions, Roll Back Plans and Production Move Check lists etc.
• Modifying the queries for performance improvement.
• Involved in performance improvement in informatica.
• Involved in running the loads to the data warehouse involving different environments.

Environment: Informatica Power Center 9, Oracle 11g, TIVOLI