SUMMARY

• Over 8 years of experience in Information Technology with a strong background in Database and Data warehouse Experience.
• Data Warehousing: strong Data warehousing experience using Informatica Power Center 9.6/9.0/8.6/8.0/7 (Source Analyzer, Repository Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Developer)
• IDQ 9.5/9.6, Power Connect for ETL, OLTP, OLAP, Data Mining, scheduling tool. Worked with heterogeneous source systems like flat files, RDBMS, DWH, parameterzing variables.
• Data Modeling: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snow - Flake Schema, FACT and Dimensions tables, Physical and logical data modeling and De-normalization techniques.
• Database: Using Oracle 11g/10g, Teradata TD13/TD12, Netezza, SQL, PL/SQL, SQL*Plus, SQL Server 2008/2005.
• Proficient in working with PL/SQL to write stored procedures and triggers. Expertise in WinSQL, TOAD (Tool for Oracle Application Developers).
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• Created IDQ mappings to make data standardized and validated.
• Worked with testing team to create test cases for unit and integration testing, expertise in User Acceptance Testing Consultation with SME’s.
• Excellent understanding of Client/Server architecture makes a valuable asset to any project, with Excellent Logical, Analytical, Communication and Organizational Skills.
• Cleansed, labeled and fix data gaps with IDQ.
• Excellent team player and can work on both development and maintenance phases of the project.
• Highly skilled in providing instantaneous and workable solutions to business problems.
• Efficient team player with excellent communication skills and good interaction with users.
• Experience with Sales, Retailing, Financial and Health care Domains.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 9.6/9.5/9.0/8.6/8.5/8.1/7, Power Connect, Informatica Data Quality, Informatica Analyst, OLAP, OLTP, ETL, Autosys, Maestro, CA7, Tidal, Data Cleansing, Data Profiling.

Databases: Teradata TD13/TD12, Oracle 11g/10g/9i, Netezza, MS SQL Server 2008/2005

RDMS Load Tools: TOAD 8.x, SQL Developer(Database tool), SQL Assistant

Languages/Web: SQL, PL/SQL, UNIX Shell Scripting

Environment: UNIX, Window XP/7

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Sr Informatica Developer

Responsibilities:

• Gathering requirements from the Data Modelers and understanding the design from the technical analysis provided.
• Analyzing the technical documentation and concluding the design of the ETL loads.
• Profiling the Sales Force data feeds and validating the flat files data through Informatica Analyst and SQL.
• Triggering the various scripts for Validating and forwarding the source flat files for extraction.
• Developing the ETL mappings according to the loads for Stage and Reporting.
• Developing SCD1, 2 mappings for the required dimension tables in all the subject areas.
• Unit testing all the mappings in Dev environment and thorough Integration testing in SIT.
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, reporting and monitoring capabilities.
• Deploying code through Deployment groups and promoting the code to higher environments.
• Error handling for the flat files and relational tables loaded into the databases.
• Creating Test cases and uploading it into QC for UAT and forwarding it to the QA team.
• Peer reviewing and testing code with all provided aspects and conditions in all the SIT and TEST.
• Interacting with the Business Analyst for any code enhancements after implementation into Prod.
• Come up with story cards after breaking the effort levels for the enhancements specified from BRD.
• Creating and scheduling the Jobs in Tidal for the Informatica Load jobs.
• Resolving performance issues by understanding the bottles necks at various levels and tuning them for better performance.
• Resolving productions issues for any scheduled jobs failures and reporting issues to the concerned teams.
• Documenting the Cut over plans, Design documents and Run books for the Production support teams.
• Uploading all the documents in SVN with all updated versions for the concerned tasks.

Environment: Informatica Power Center 9.6, Informatica Analyst, IDQ, Oracle 11g, QC, UNIX, Flat files, Windows 7 Professional.

Confidential, Dearborn, MI

Informatica Developer

Responsibilities:

• Understanding the SQL Stored Procedures and implement the same into a functional database design.
• Converting the Stored Procedures into ETL mappings.
• Designing the Kimball model for all the subject areas.
• Developed new Informatica mappings and workflows based on specifications.
• Implemented the all subject areas into the data marts to generate the reports and build dash boards on it.
• Used all major ETL transformations to load the tables through Informatica mappings.
• Implemented Cursors into the stored procedures for frequent commits to avoid large data loading failures.
• Thorough Validation on source data and the load in the dimension and fact tables.
• Created IDQ mappings to make data standardized and validated.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Cleansed, labeled and fix data gaps with IDQ.
• Integrated the subject areas and perform the regression testing.
• Data Transformations and integrate them with Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Used Kimball data model concept to do conceptual/logical/physical data models.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Designed Excel Sheets and Visio for each mapping of their Test Scenarios.
• Worked with production issues like bottlenecks, data validation and report errors.

Environment: Informatica Power Center 9.6, IDQ, Oracle 11g, OBIEE, UNIX, Flat files, Windows 7 Professional.

Confidential, Ann Arbor, MI

Informatica Developer

Responsibilities:

• Understanding business needs and implement the same into a functional database design.
• Participated in requirements gathering.
• Involved in all the phases of SDLC.
• Developed new Informatica mappings and workflows based on specifications.
• Developed Batch Processing, Source and Target Reconciliation.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy.
• Developed various Ad-hoc mappings for various business needs.
• Performed extraction, transformation and loading of data from RDBMS tables, Flat Files into Teradata in accordance with requirements and specifications.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them with Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production environment.
• Created Netezza DB Objects using best practices of Netezza in order to avoid data skews on the Netezza Objects.
• Created NZLoad scripts to load the Flat Files into Netezza staging tables.
• Used Erwin data modeling tool to do conceptual/logical/physical data models.
• Developed UNIX shell scripts to scheduling Scripts by using scheduling tools.
• Designed Excel Sheets for each mapping of their Test Scenarios.
• Worked with production issues like bottlenecks, data validation and report errors.

Environment: Informatica Power Center 9.5/9.0, Teradata TD 13, Netezza, UNIX, Flat files, Windows 7 Professional.

Confidential, Billerica, MA

Informatica 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 all the SCD like Type 1, 2, 3 and type 2 variant.
• Designing and creation of complex logic using SCD type II involving
• Used Informatica PowerCenter for data extraction from various sources like Oracle and flat files.
• Worked extensively on Source Analyzer, Mapping Designer, Mapplet designer and Warehouse Designer and Transformation Developer.
• Designed and developed Informatica Mappings and sessions based on business rules.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations
• Transformations such as expression, joiner, aggregator, lookup, update strategy, filter.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

Environment: Informatica Power Center 8.6 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, UNIX, Flat files, Windows XP professional.

Confidential, Franklin Lakes, NJ

Informatica 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 (Power Center Designer, workflow manager, workflow monitor), Oracle 11g, UNIX, Flat files, Windows XP professional.

Confidential

ETL Analyst

Responsibilities:

• Development of General Ledger, Transaction and Profit Margins processes.
• Development of staging for equities, Derivatives and Fixed income.
• Business Analysis and Requirements gathering from the Business Users and Technical document design of these requirements.
• Designed mapping documents and developed ETL mappings using Informatica. Designed and developed Informatica mappings to build business rules to load data.
• Extensively used almost all types of transformations like filter, joiner, sorter, rank, update strategy, expression and aggregation.
• Extracted data from heterogeneous source systems.
• Involved in importing Source/Target Tables from the respective databases and created Reusable Transformations, Mapplets using Designer module of Informatica. Also involved in coding, testing in UAT.
• Created Workflow, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirements.
• Created reusable worklets and mapplets and transformations.
• Performance Tuning of sources, targets, mappings and SQL queries in transformations.
• Wrote Unix Shell Scripts to run mappings.
• Created Functions, Procedures and Triggers in PL/SQL.

Environment: Informatica Power Center 7, Oracle 9i, UNIX, Autosys.