SUMMARY:

• 6 +years of Experience in analysis, design, development, implementation and troubleshooting of Data warehouse applications.
• Data integration experience in developing ETL mappings and scripts using Informatica Power Center 9.x/8.x/7.x and Power Exchange 8.x/7.x.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, Teradata, DB2, SQL server and MS access and non-relational sources like Flat files, XML files into staging area.
• Experience in Designing Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in loading data from Oracle database and MS SQL Server database to Teradata database.
• Experience in active data ware housing on the Teradata platform, extended use of Teradata Parallel Transport, TPump, FastLoad, BTEQ and migrating legacy systems into Teradata.
• Experience in the concepts of building Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Informatica Data Quality (IDQ) and Informatica Analyst.
• Worked on creating Unit Test Cases for mapping and code reviews.
• Experience in Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Experience in logical/physical data models and Forward/Reverse Engineering using ERwin.
• Have knowledge in Business Intelligence tool Cognos 10/8.x/7.x.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase. Extensive functional and technical exposure. Experience working on high-visibility projects.
• Team player with strong communication and interpersonal skills.

ETL: Informatica PowerCenter 9.x/8.x/7.x/6.x, B2B Data Transformation, Power Mart 6.1/5.1, Power Connect 8.5.1/8.1.1 , Informatica Data Quality (IDQ).Database Modeling: ERwin 4.5/4.0/3.5

Databases: Oracle 11g,10g,9i,8i, Teradata, SQL Server 2000, MS Access 2000

GUI: VisualBasic6.0, Developer2000 (Forms 6i/6.0/5.0/4.5 and Reports 6i/6.0/3.0/2.5)

Languages: SQL, PL/SQL, C, COBOL, JAVA, C++

DB Tools: Toad, Sql Developer, SQL* plus, SQL* Loader, Import, Export

Scripting: HTML, XML, JavaScript, VBScript.

OS: Windows 7/Vista/XP/2003/2000/NT/98/95, Sun Solaris 2.x, HP-Unix, Red.

Confidential (Dublin, OH)

Informatica/Oracle Developer

Confidential is one of the leading Bank in US which has its hand into Mortgage Banking. The primary aim of the project is to develop reports with past and present data of Mortgage customers in order to submit for FRB for the verification purpose and give an opinion that chase is not bound to any type of discrimination.

Responsibilities:

• Development of reports based on the changing requirements from FRB.
• Communicating with the end Users and the BA’s to gather all the requirements and discussing different Scenarios as per the requirements.
• Created ETL mappings to pull data from various databases to Oracle staging area.
• Involved in Unit testing of the reports and worked with the end users in performing the user acceptance testing.
• Working on the Design document to prepare the Mapping document and the TSD’s.
• Working with different levels of testing teams in order to check with the data, if data is populated as per the requirement.
• Used different transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator and implemented simple to complex logics for data cleansing and scrubbing and in turn loaded it to the staging area for the report generation purpose,
• Resolved many database and informatica bottlenecks like deadlocks at database due to circular references among entities, the performance issues with de-normalization and resolved many to many and self recursive issues with complex business data flow.
• Worked on PL/SQL code optimization techniques and error handling mechanisms.

Environment: Informatica 9.1, Oracle 11g, Toad.

Confidential ( Jersey City, NJ)

Informatica Developer

Confidential is one of the world’s largest finance & banking corporations mainly engaged into finance and banking centered business. They are into the spectrum of Financial Services, Corporate Banking, Capital Markets, Asset Management and E-Commerce .The project here is to build a data warehouse to maintain all the details of the corporate loans across the world.

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations like Source qualifier, Connected and Unconnected Lookup, Expression, Aggregator, Joiner, Filter, Normalizer, Rank and Router Transformations.
• Worked Informatica power center tools like Source Analyzer, Mapping designer, Mapplet and Transformations.
• Developed Informatica mappings and also tuned for better performance.
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, Flat files and loaded into target.
• Developed, tested and implemented Unix Shell scripts, FTP, SFTP’s, file transfers, Teradata BTEQ, Fast Load, Mload, TPump, FastExport Oracle/DB2 stored procs & Bulk loads.
• Designed and developed data warehouse solutions, integrate new files and data’s from other applications into Enterprise data warehouse, Utilize Teradata for reporting, OLAP & history.
• Developed Procedures and Functions in PL/SQL.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk I/O and Sorts.
• Designed and Developed ETL logic for implementing CDC by tracking the changes in critical fields required by the user.
• Extensively used Informatica to load data from Flat files, Oracle database.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Performed Data Encryption on user data and client data for maintaining consistency and security.
• Responsible for Performance Tuning at the Mapping Level and Session level.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Extensively worked with both Connected and Unconnected Lookup Transformations.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involved in Unit testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required.
• Performed detail data analysis of both data elements requested by the business and data source and documenting data source definition, source-to-target mapping, and logical structures for the data warehouse/data mart
• Was involved in design, development, and the administration of Oracle data mart, the distribution of global data from the Data Warehouse.
• Used UNIX to create Parameter files and for real time applications.
• Developed shell scripts.
• Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
• Worked with many existing Informatica mappings to produce correct output.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Detail system defects are created to inform the project team about the status throughout the process.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache and Persistent Cache.

Environment: Informatica Power Center 9.1/8.6, Informatica Analyst 9.1, Informatica Developer 9.1, Data Quality (IDQ)Windows NT, Oracle 9i/10g,Teradata, SQL/PL-SQL, TOAD, XML.

Confidential (Austin, TX)

Project: National Eligibility Database

Informatica Developer

Responsibilities:

• Responsible for converting Functional Requirements into Technical Specifications.
• Worked with the team to Integrate data from multiple source systems like Health Answers, Power system, Health Plex into Single Data Warehouse system.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Creating mappings with different transformations like Parser transformation, Standardizer transformation, Address Validator in Informatica developer (IDQ) tool.
• Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.
• Extracted data from Flat files and Oracle and loaded them into Teradata.
• Designed the ETL processes using Informatica to load data from Oracle to target Teradata Database.
• Loaded the data into the Teradata database using Load utilities like FastExport, FastLoad, MultiLoad, and Tpump.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Teradata, Oracle, Flat files and loaded into target.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Created Pre-Sql and Post-Sql scripts which need to be run at Informatica level.
• Developed Oracle views to identify incremental changes for full extract data sources.
• Developed Stored Procedures which truncates the Tables and reinserts all/partial records depending on the “Load Flag” Parameter passed to the procedure. All messages/errors/load times are logged into the log table.
• Developed the automated and scheduled load processes using Fact scheduler.
• Involved in migration of mappings and sessions from development repository to production repository.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Worked on production tickets to resolve the issues in a timely manner.
• Populated and updated data dictionary, standardized naming convention.

Environment: Informatica PowerCenter 9.1/8.6, Informatica Data Quality (IDQ), Data Quality, Teradata, Oracle 11i, DB2- Surveyor 400, Solaris UNIX, Toad, Fact.

Confidential

Responsibilities:

• Chose critical tables and files for profiling activity with the help of business users.
• Created equivalent oracle tables in Staging area.
• Created ETL mappings to pull data from various databases to Oracle staging area.
• Created Data Maps to pull legacy data using Informatica Power Exchange.
• Captured various profiling results i.e. column profiling, table profiling, cross table profiling and cross application profiling results into the excel sheets so that business user can review the result.
• Involved in capturing data which requires data cleansing activity, which is also a step in migration activity.
• Participated in documentation part and tracking progress of Data Profiling project.

Environment: Informatica Power Center 8.6, Oracle 10g, SQL Server, Toad, Informatica Power Exchange, UNIX, SQL Plus and Windows 2000 / XP.

Confidential

Warehouse Power Reports

Responsibilities:

• System Study of Application functionality and gone through the Ready Reckoner.
• Involved in understanding the architecture of project upstream systems, down streams system and clients
• Developed and modified mappings and extracting data from sources like relational tables and flat files
• Writing a Stored Procedure, Triggers related to Database Function
• Reviewed the mappings and finding bottlenecks
• Involved in creating and calling shell scripts to automate the informatica workflow

Environment: Informatica 7.x, DB2, Flat Files, UNIX.