SUMMARY:

• 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.5/9.0/8.6/8.1, Informatica Data Quality 9.5/9.0, OLTP, OLAP, Data Mining, scheduling tool. Worked with heterogeneous source systems like flat files, XML, RDBMS.
• 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. Proficient in working with PL/SQL to write stored procedures and triggers. Expertise in WinSQL, TOAD.
• Proficient in Analyzing Business processes requirements and translating them into technical requirements.
• 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 as well as Excellent Logical, Analytical, Communication and Organizational Skills.
• 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 and Health care Domains.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 9.5/9.0/8.6/8.1, Informatica Data Quality 9.5/9.0, OLAP, OLTP, ETL, Autosys, Maestro, CA7, Data Cleansing, Data Profiling.

Databases: Teradata TD13/TD12, Oracle 11g/10g/9i, Netezza.

Reporting: OBIEE, Advantage Suite, Cognos.

RDMS Load Tools: TOAD 8.x, SQL Developer, SQL Assistant.

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

Environment: UNIX, Windows

PROFESSIONAL EXPERIENCE:

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.
• Used most of the developer transformations like standardizer, labeler, case converter, address validator, match, and parser.
• Cleansed, labeled and fix data gaps with IDQ.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• 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.5, IDQ 9.5, Teradata TD13, Oracle 11g, OBIEE, UNIX, Flat files, CA7, Windows 7 Professional, MS Visio, MS office.

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.
• Created IDQ mappings to make data standardized and validated.
• Used most of the developer transformations like standardizer, labeller, case converter, address validator, match, and parser.
• Identified data quality issues, anomalies, patterns based on business rule and Cleansed, labeled and fix data gaps with IDQ.
• Worked for address validation and name matching task in IDQ.
• 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.
• 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.0, IDQ 9.0, Teradata TD 12, Netezza, Advantage Suite, 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 Type 1, 2 and 3 variants.
• Designing and creation of complex logic involving SCD type 2.
• 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 9.0.1, Oracle 11g, Cognos, 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.1, UNIX, Oracle, Teradata.

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.
• 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 8.1, Oracle 9i, UNIX, Autosys.