SUMMARY:

• Over 8 years of experience in Information Technology wif 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 wif 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 wif 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 wif testing team to create test cases for unit and integration testing, expertise in User Acceptance Testing Consultation wif SME’s.
• Excellent understanding of Client/Server architecture makes a valuable asset to any project, wif Excellent Logical, Analytical, Communication and Organizational Skills.
• Cleansed, labeled and fix data gaps wif IDQ.
• Excellent team player and can work on both development and maintenance phases of teh project.
• Highly skilled in providing instantaneous and workable solutions to business problems.
• Efficient team player wif excellent communication skills and good interaction wif users.
• Experience wif 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/7Power 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/2005RDMS 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, FL

Sr Informatica Developer

Responsibilities:

• Gathering requirements from teh Data Modelers and understanding teh design from teh technical analysis provided.
• Analyzing teh technical documentation and concluding teh design of teh ETL loads.
• Profiling teh Sales Force data feeds and validating teh flat files data through Informatica Analyst and SQL.
• Triggering teh various scripts for Validating and forwarding teh source flat files for extraction.
• Developing teh ETL mappings according to teh loads for Stage and Reporting.
• Developing SCD1, 2 mappings for teh required dimension tables in all teh subject areas.
• Unit testing all teh mappings in Dev environment and thorough Integration testing in SIT.
• Worked wif IDQ toolkit, Analysis, data cleansing, data matching, data conversion, reporting and monitoring capabilities.
• Deploying code through Deployment groups and promoting teh code to higher environments.
• Error handling for teh flat files and relational tables loaded into teh databases.
• Creating Test cases and uploading it into QC for UAT and forwarding it to teh QA team.
• Peer reviewing and testing code wif all provided aspects and conditions in all teh SIT and TEST.
• Interacting wif teh Business Analyst for any code enhancements after implementation into Prod.
• Come up wif story cards after breaking teh effort levels for teh enhancements specified from BRD.
• Creating and scheduling teh Jobs in Tidal for teh Informatica Load jobs.
• Resolving performance issues by understanding teh bottles necks at various levels and tuning them for better performance.
• Resolving productions issues for any scheduled jobs failures and reporting issues to teh concerned teams.
• Documenting teh Cut over plans, Design documents and Run books for teh Production support teams.
• Uploading all teh documents in SVN wif all updated versions for teh 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 teh SQL Stored Procedures and implement teh same into a functional database design.
• Converting teh Stored Procedures into ETL mappings.
• Designing teh Kimball model for all teh subject areas.
• Developed new Informatica mappings and workflows based on specifications.
• Implemented teh all subject areas into teh data marts to generate teh reports and build dash boards on it.
• Used all major ETL transformations to load teh tables through Informatica mappings.
• Implemented Cursors into teh stored procedures for frequent commits to avoid large data loading failures.
• Thorough Validation on source data and teh load in teh dimension and fact tables.
• Created IDQ mappings to make data standardized and validated.
• Developed and tested all teh backend programs, Error Handling Strategies and update processes.
• Cleansed, labeled and fix data gaps wif IDQ.
• Integrated teh subject areas and perform teh regression testing.
• Data Transformations and integrate them wif Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on teh basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of teh objects used in creating teh mappings, workflows to keep track of teh changes in teh 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 wif 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 A

Informatica Developer

Responsibilities:

• Understanding business needs and implement teh same into a functional database design.
• Participated in requirements gathering.
• Involved in all teh 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 wif requirements and specifications.
• Developed and tested all teh backend programs, Error Handling Strategies and update processes.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them wif Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on teh basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of teh objects used in creating teh mappings, workflows to keep track of teh changes in teh development, test and production environment.
• Created Netezza DB Objects using best practices of Netezza in order to avoid data skews on teh Netezza Objects.
• Created NZLoad scripts to load teh 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 wif 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 teh design and technical specifications for teh ETL process of teh project.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Worked on all teh 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 wif teh logic embedded in teh mappings using Power center Designer.
• Analyzed business process workflows and assisted in teh 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, NJ

Informatica Developer

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Creating teh design and technical specifications for teh ETL process of teh 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 wif teh logic embedded in teh mappings using Power center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Responsible for monitoring all teh 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 teh 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 teh 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.