SUMMARY:

• Over 8+ years of experience in Information Technology including Data warehousing, RDBMS, Client Server applications.
• Over six years of data warehouse experience using Informatica Power Exchange, Informatica Power Center 9.x/8.x/7.x and ETL Concepts.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Involved in creating Dimensional Data Modeling, Fact table and Dimensional tables;
• Experienced in OLTP/OLAP system study, analysis and ER modeling.
• Experienced in developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling.
• Extensive experience in extraction, transformation and loading of data directly from various data sources like flat files, Excel, SQL Server, Oracle, DB2.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformations Developer, Mapplet and Mapping Designer.
• Extensive experience in implementing CDC using Informatica Power Exchange 8.x/7.x
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing, Datamart and OLAP concepts.
• Experienced with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Working experience in using Oracle … SQL Server … PL/SQL, SQL Loader, TOAD, ERWIN.
• A good understanding and experience with Business Objects Reports.
• Experience on the Oracle Data integrator, to make sure the data the right is loaded.
• Experience in using different kind of Partitions for the better performance and fast retrieval of data from the Database.
• Extensively used Partition By Range, Partition By Hash Function, Sub Partition, List Partitions.
• Extensive experienced in writing stored procedures (PL/SQL), triggers, Functions and Packages.
• Experienced in using the Informatica command line utilities like PMCMD to control workflows in non- windows environments.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensive use of Persistent cache to reduce session Processing time.
• Experienced in creating Jobs, Alerts using SQL Mail Agent. Well versed in various high availability solutions like clustering, mirroring, log shipping.
• Experienced in devising Disaster recovery strategies and effectively testing them. Experience in managing security, creating security policies and rules.
• Moved Data from external source into Oracle Database using SQL Loader
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experienced in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience of designing strategies to maintain audit tables, load balance, exception handling and high data volumes.
• Good exposure to Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support
• Experience with software development life cycle (SDLC) and project management methodologies.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, and high level of motivation.

TECHNICAL SKILLS:

Data warehousing Tools: Informatica Power Center 7.x/8.x / 9.X

Oracle 11g /10g/9i, DB2, MS: SQL SERVER

Data Modeling: Star Schema Modeling, Snowflakes Modeling, FACT &Dimensionstables

Languages: C, C++, Java, XML,SQL,PL/SQL, Teradata

Database Utilities: TOAD 8.0/7.1, SQL*Plus, SQL Developer

Environment: UNIX, LINUX, Windows 9x/2000/NT/XP/VISTA

MS Visio, Control: m, AutoSys

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Informatica Developer

Responsibilities:

• Member of core ETL team involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the source to the target DW.
• Analyzed the business requirement document and created functional requirement document mapping for all the business requirements.
• Extensive use of Datamart and OLAP concepts.
• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources systems.
• Developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Java, Java Expressions, Router, Filter, Aggregator and Sequence Generator transformations.
• Automated the load process using UNIX shell scripts.
• Involved in the data migration from Control-M to TWS scheduler
• Involved in performing data validation for various applications such as Salesforce, Annuities and Investments
• Used the features like Workload designer, Viewpoint manager etc
• Used the features like Server manager, repository server etc
• Used heterogeneous files, flat files, spreadsheets, and oracle as sources
• Created, monitored and troubleshooted sessions for daily extracts
• Involved in tuning the SQL statements to optimize the performance
• Disabled the jobs scheduled through Control-M after two weeks of successful runs in TWS.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created reusable objects in Informatica for easy maintainability and reusability.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Extensively used debugger to trace errors in the mapping.
• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors and Stored Procedures
• Involved in developing test plans and test scripts to test the data based on the business requirements.
• Created source, target, transformations, sessions, batches and defined schedules for the sessions.
• Re-designed ETL mappings to improve data quality.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Created Workflows and used various tasks like Email, Timer, Scheduler, Control, Decision, and Session in the workflow manager.
• Modifying the shell/Perl scripts as per the business requirements.
• Tuning Informatica Mappings and Sessions for optimum performance
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Partitioned sessions for concurrent loading of data into the target tables.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Used Informatica features to implement Type I, II, and III changes in slowly changing dimension tables.
• Used Shell Scripting to automate the loading process.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.
• Co-ordinate between different teams across circle and organization to resolve release related issues.

Environment: Informatica Power center 8.6, Power Exchange 8.1, Oracle 10g, DB2 Query Analyzer, SQL *Plus, XML, Flat Files, Windows, IBM UNIX(AIX), TOA

Confidential - Dallas, TX

Informatica Developer

Responsibilities :

• Analyzed Business and Systems Requirements documents and other documents as a preparation for the creation of required System Design Documents.
• Involved in Dimensional Data Modeling design and populating the Business rules into integrated data warehouse.
• Created logical and physical data models for Business users to determine data definitions and establish referential integrity of the system.
• Experience of working on Fact Tables and Dimensional tables.
• Implemented the concept of Slowly Changing Dimensions concept with various transformations, mainly Update Strategy
• Used Informatica to build the data warehouse. Performed various activities related to Informatica Server Administration (Installing and configuring Informatica Server and Client, backup, restore, Data migration & Repository Promotion).
• Used to work with the Data Migration between various Repositories.
• Extensively used and created Complex Mappings using Source Qualifier, Aggregator, Expression, Joiner, Lookup, Router, Filter, JAVA and Stored Procedure transformations.
• Used Star schema for the data warehouse.
• Created and Monitored Sessions using Informatica Power Center. Designed Sequential and concurrent workflows for whole process.
• Migrated the objects between various repositories and maintained the repository.
• Involved in working with heterogeneous data sources like flat files, DB2 and Oracle, SQL server.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX Shell scripts to automate the activities.
• Tuned the SQL queries used in the SQL overrides of the Source Qualifiers.
• Wrote SQL, PL/SQl, Stored procedures, triggers and packages.
• Used Partition by Range, List partitions for better performance.
• Constantly assisted Business Users in data validations for any data issues observed and mismatches.
• Involved in Unit testing, system testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements
• Performed Unit tests on the mappings.
• Used SQL Loader, loaded MS Excel data into Oracle.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Worked with Autosys Scheduling team to schedule jobs daily and weekly based on Feedback from Business Analysts

Environment: Informatica Power center 8.6.1, DB2, V2R3, SQL Server 2008, Oracle 11g/10g, DB2, Business Objects XIR2/6.5/5.0, PL/SQL, Power exchange 8.1, TOAD, Windows XP, UNIX maestro, ERWIN 4.2, SunSolaris10, Hyperion BRIO reporting, XML, Autosys.

Confidential - VA

Informatica Developer

Responsibilities:

• Involved in system analysis & design of the Enterprise data warehouse implementation, Requirements gathering and understanding the business flow.
• Worked with BAs for requirements gathering, documentation, business analysis, testing, and project coordination.
• Involved in the requirements definition and analysis in support of Data Warehousing efforts.
• Created the mapping documents based on the data model and the client requirements.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Developed Informatica mappings and also tuned them for better performance. Involved in designing the procedures for getting the data from all systems to Data Warehousing system.
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data. Used most of the transformations such as the Source qualifier, Aggregators, Lookups, Filters, Sequence and Update strategy.
• Created Pre & Post session commands & shell scripts, which will create the parameter, file dynamically.
• Used ETL to extract and load data from Oracle, MS SQL Server and flat files to Oracle 10g. Wrote PL/SQL Program units for data extracting, transforming and loading. Created and ran Sessions to load the data into the Data warehouse components.
• Developed and documented data Mappings/Transformations and Sessions.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Developed Schell scripts for Daily and weekly loads and coordinated with scheduling team.
• Involved in Unit testing, system testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Created Unit test cases and worked with system test team for QA Environment testing, test plan creation.
• Worked with Informatica Admin team to migrate repository objects across different Environments.
• Extensively used SQL Plus for Data validations and Unit Testing of Applications.
• Worked with Production support team and implemented fixes/solutions to issues/tickets raised by business users.
• Worked with Business users to validate Reports.

Environment: Informatica Power Center 8.1.1, Oracle 10g, MS SQL Server 2005, DB2, MS Visio, Windows 2000, and Toad 7.0, Business Objects 6.5/6.0, Erwin Designer 4.1, Hyperion BRIO reporting, Power exchange 7.1

Confidential - Bloomington, IL

Informatica Developer

Responsibilities :

• Assessed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor, Power Connect.
• Imported data from Relational databases, Legacy Systems, XML files and Flat files to Oracle database using Informatica Power Connect.
• Analyzed the source data coming from different sources and worked on developing ETL mappings/mapplets.
• Made use of various Designer transformations like Source Qualifier, Connected and Unconnected Lookups, Expression, Filter, Router, Sorter, Aggregator, Joiner, Normalizer, Rank, Sequence generator, Union and Update Strategy transformations.
• Loaded data into SAP 5.0 using IDOC'S, File Based (ABAP) and BCI.
• Created Parameter files and validation scripts, Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable worklets and workflows in Workflow Manager.
• Designed multi-dimensional Star schema, Generated the database scripts, E-R diagrams using ERWIN.
• Created UNIX KSH shell scripts to kick off Informatica workflow in batch mode.
• Involved Informatica using "pmcmd" utility from the UNIX script.
• Done the end to end to testing with the source system.

Environment: Informatica Power Center 8.6, Power Exchange, Informatica Power Connect, Oracle 11g, SAP ECC, Flat Files, UNIX.

Confidential

Informatica Developer

Responsibilities:

• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Studied the project requirement and designed the project.
• Created tables, views, synonyms and sequences.
• Creating Mappings for transforming the data.
• Creating Mapplet for transforming the data.
• Created Database Triggers, Stored Procedure, Functions and Packages
• Optimized queries using rule based & cost based approach.
• Used SQL Loader for data loading.
• Various Performance and Tuning techniques used to improve the load.
• Involved in Testing the Informatica mappings and creating QA Test Plans.
• Modified existing forms, reports, and graphs as per the enhancement.
• Tested all the new and modified program units.

Environment: Informatica Power center 7.1,Oracle,Unix