SUMMARY:

• 9 years of experience in Data Warehousing using ETL and OLAP tools Informatica PowerCenter9.x/8.x/7.x, Informatica PowerExchange9.x/8.x and Business ObjectsFlat File and XML File.
• 9 years of IT experience in all phases of Software Development Life Cycle (analysis, design, development, test, implementation and support). Thorough understanding of Methodologies like waterfall, Iterative and Agile methodology.
• Expertise in Informatica Power Center Mappings, Mapplets, Transformations, Workflow Manager, Workflow Monitor, Repository Manager, FACT Tables, Dimension Tables, Star Schema Modeling, Snowflake Schema, OLTP and OLAP.
• Proficient in Optimizing Database querying, data manipulation and population using SQL, PL/SQL and Utilities in Oracle 11g/10g, Teradata 13/12/V2R6, DB2 UDB and SQL Server 2008/2000 databases.
• Strong understanding data Modeling design, develop, test, debug, and maintain application programs. Excellent working knowledge of UNIX shell scripting, job scheduling on multiple platforms, experience with UNIX command line.
• Experienced in developing and executing complex SQL queries to validate the data in the back end.
• Experience writing and modifying ETL design documentation, test results documentation and standard operating procedures (SOP) documentation.
• Ability to handle multiple Tasks and work independently as well as in a team.
• Experience in all aspects of analytics/data warehousing solutions Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions.
• Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
• Ability to self - manage time and task priorities to meet project timelines, and identify Potential project risks.
• Understand the existing ETL jobs and mappings, sessions and workflows Troubleshoot ETL jobs and fix the issues based the priorities
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Worked on Power Exchange CDC on Batch mode and Real-time mode.
• Worked on Data Transformation Studio which is an application that processes complex XML files, such as messaging formats. Automatically generate a XSD for Business object using Data Transformation Studio.

TECHNICAL SKILLS:

Data warehousing: Informatica Power Center 9.6.1/9.5.1/9.1.1/8.6/8.5/8.1/7.1, Informatica Power Exchange 9.1/8.6/8.1, Erwin 8/7.5/4.0

Business Tools: 9 Years experience of Star-Schema Modeling, Snowflake Modeling, MS Visio, Erwin, WinSCP, Autosys, Taxpad, MS Visual Source Safe, PVCS, Control M, Harvest, Remedy, Planview, Leeyo and Filegilla.

Databases: 9 Years experience of Oracle 10g, Oracle 11g, Oracle R12 MS SQL Server7.0/2000, MS Access, Sybase, DB2, MySQL, Teradata V2R6, Single View, Revpro

Languages: 9 Years XML, SQL, T-SQL, PL/SQL, UNIX Shell Scripting, Perl, Java

Operating System: 9 Years experience of Windows98/NT/2000/XP, MAC, SunSolaris, Linux/UNIX, MS-DOS, Web Logic.

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Sr. Informatica Developer and Support

Responsibilities:

• Worked with UNIX, SQL, functions, stored procedures and packages within the mappings.
• Tuned Informatica mappings, sessions task and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Create file for validate code.
• Performed the End to End testing Dev environment.
• Used UNIX to navigate around the system and check for specific files, the files’ content, change the file permissions.
• Performed UNIX script, create new script for peer and post session.
• Performed Install packages and make Tar file for deferent environment.
• Applied AFT change request as per the business requirements.
• Worked with peer sessions from various functional areas to define code reviews, unit test documentation and knowledge sharing sessions.
• Performed CDM Application.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.

Environment: Informatica power center 9.6.1(Source Analyzer, Data warehousing designer, Mapping Designer, Workflow Manager, Workflow Monitor, Worklets, Mapplet, Erwin, WinSCP Tax pad), Star-Schema Modeling, Snowflake Modeling, Oracle 11g, Toad 12.5.1.1, PL/SQL, Unix r11 client and service Now.

Confidential, Reston, VA

Sr. Informatica Developer

Responsibilities:

• Responsible for this project, Generated the code for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Involved in ETL process from development to testing and production environments.
• Extracted date from various sources like XML file, Flat files, Oracle and loaded it into Target systems using Informatica power Center 9.6.1.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with the logic embedded in the mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Performed Unit testing and validated the data.
• Created & Ran shell scripts in UNIX environment.
• Created and ran the Workflows using Workflow manager in Informatica Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Created tables and partitions in database Oracle.
• Written stored procedures in Oracle.

Environment: Informatica power center 9.6.1, Informatica TD Studio, PowerMart(Source Analyzer, Data warehousing designer, Mapping Designer, Workflow Manager, Workflow Monitor, Worklets, Mapplet, ErWin, winSCP Root, Taxpad), Star-Schema Modeling, Snowflake Modeling, Power Exchange, Teradata (Fastload, MultiLoad, T-Pump, BTEQ), Oracle 11g, Toad 12.5.1.1, PL/SQL, Autosys Unix r11 client,, Business Object and XML File.

Confidential, McLean, VA

Sr. Informatica Developer

Responsibilities:

• Analyzing the data and Mapping the data requirements developing Stored Procedures and Functions.
• Designed Mapping document, which is a guideline to ETL Coding.
• Developed ETL mappings , transformations using Informatica Power C enter .
• Implemented source and target definitions in workflow designer and production deployments.
• Involved in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.
• Working on new projects to fulfill the business needs.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix the production data issues and also provide solutions to the business users.
• Used Toad for data quality verification and unit testing the data.
• Migrated mappings from Development to Testing and Testing to Production.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour Production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

Environment: Informatica Power Center 9.5/9.1, Informatica PowerExchange 9.5/9.1, Oracle Exadata, Teradata 13, MSSQL Server 2008 R2, T-SQL, ERWin 8, SQL Server 2008, TOAD, PL/SQL Developer, Linux, Tidal, Shell Scripting, Perl Scripting, Windows XP, Putty, DB2 Mainframe, Informatica Cloud, Sales force.

Confidential, New Jersey

Sr. Informatica Developer

Responsibilities:

• Comprehensive knowledge of testing Human Resource Systems-application, tools, and functionalities.
• Sound knowledge of HRMS modules testing procedures and standards.
• Excellent communicator with strong technical and problem solving skills.
• Participated in system Requirement Specification Meetings, and design Reviews.
• Managedthe Requirement Traceability Matrix (RTM) between requirements and test cases.
• Extensively used ETL to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Developed number of complex Informatics mappings, mapplets, reusable transformations to implement the business logic and load the data incrementally.
• Extracted data from Oracle and SQL Server and load the data into target database.
• Handled slowly changing dimensions of Type1/ Type2 to populate current and historical data to dimensions and fact tables in the Data Warehouse.
• Document the process for further maintenance and support.
• Checked database to determine successful transaction of test data from the application by establishing connectivity using SQL commands

Environment: e-business suite Data source Oracle 11i, Oracle R12, MS SQL Server, Oracle SQL Developer, Siebel, Revpro, SingleView, Leeyo, Remedy TOAD, PL/SQL Developer, Shell Scripting, Windows XP, Putty, DB2 Mainframe, OBIEE 11g, Sales force, Linux, bmcsoftware control-M, Informatica Power Center 9.1, Informatica PowerExchange 9.1.

Confidential, New York, NY

ETL/ Informatica Developer

Responsibilities:

• Interacted with Data Modellers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Work lets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Well versed with creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g.
• Error checking & testing of the ETL procedures & programs using Informatica session log.
• Performance Informatica Sources, Targets, mappings & sessions for large data files by increasing data cache size, sequence buffer length and target based commit interval.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Performed error handling for removing database exceptional errors.

Environment: Informatica Power Canter 8.6, Oracle 10g, Teradata V2R5, XML, TOAD,SQL, PL/SQL,IBM AIX, UNIX Shell Scripts, Web Intelligence, DSBASIC, Erwin 6.1, Remedy, Maestro job scheduler, Mercury Quality Center.

Confidential, Blue Bell, PA

ETL Developer

Responsibilities:

• Collection of requirements from business users and analyzed based on the requirements.
• Extensively used flat files for Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Designed and developed complex mappings using various transformations in Designer to extract the data from sources like Oracle, SQL Server and flat files to perform mappings based on company requirements and load into Oracle tables.
• Well versed with creating and Altering Table, Triggers, Sequences, and other DDL, DML and DCL utilities of Oracle 9i and 10g.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking & testing of the ETL procedures & programs using Informatica session log.
• Developed UNIX shell scripts to automate applications, Schedule jobs, develop interfaces and Created pre-session and post-session shell scripts and mail-notifications.
• Performed error handling for removing database exceptional errors.
• Configured Informatica Power Exchange connection and navigator.
• Created Registration, Data Map, configured Real-Time mapping and workflows for real-time data processing using CDC option of Informatica Power Exchange.
• Worked with tools like TOAD to write queries and generate the result.
• Actively involved in acquiring training on the Portico 8.0/9.0 versions of Provider Manager and Business Administrator modules of Portico.
• Working on the Data Analyzer, Data Quality and data profiler tool for handling the business logic and exception logic from the inbound feeds and also the outbound feeds.

Environment: Informatica 8.1, ORACLE 10g, UNIX, Windows NT 4.0, Sybase, UNIX Shell Programming, PL/SQL, TOAD, Putty, WinScp, Remedy

Confidential, Stoneham, MA

ETL/ Database Developer

Responsibilities:

• Developed complex mappings to extract source data from heterogeneous databases SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and PL/SQL code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT (User Acceptance Testing) with user community.
• Developed K-shell scripts to run from Informatica pre-session, post session commands.
• Involved in Data transfer from OLTP systems forming the extracted sources.
• Analyzed the sources, transformed the data, mapped the data and loading the data into targets using Power Center Designer.
• Designed and Developed Oracle PL/SQL Procedures and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Participated in the design of Star & Snow flake schema data model.

Environment: Informatica Power Center 7.1, Oracle 10g, SQL Server 2000, Erwin 3.5, XML, TOAD, HP - Unix 11.11, Harvest, Sun Solaris, DB2 Mainframe.

Confidential, New York, NY

Database Developer

Responsibilities:

• Designed mapping document, which is a guideline for ETL Coding following Standards for naming conventions and Best Practices were followed in mapping development.
• Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Optimized the SQL override to filter unwanted data and improve session performance.
• Used Debugger to track the path of the source data and also to check the errors in mapping.
• Prepared unit testing document covering field to field’s validations and source to target count.
• Assisted the other ETL Developers in resolving complex scenarios.
• Involved in promoting the folders from Development to Test and Test to Production Environment.
• Involved in different Team review meetings.

Environment: Informatica Power Center 7.1, Oracle 10g, Toad 7.6, Clarify 10.1, Tuxedo Middleware, Clear Quest, Remedy, PVCS