SUMMARY:

• Having 9+ years of experience in analysis , design , development and testing client server environment with focus on Data Warehousing application using tools like Informatica PowerCenter9.x/8.x/7.x/6.x , Business Objects with Oracle , SQL Server databases
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of source systems
• Experience in using ETL methodologies for supporting Data Extraction , Data Migration , Data Transformation and developing Master Data using Informatica Power Center , Teradata
• Involved in Full Software Development Life Cycle (SDLC) involving Application Development , Data Modeling , Business Data Analysis and ETL / OLAP Processes
• Strong Data Warehousing ETL experience of using Informatica 9.6.1/9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager
• Vast experience in Extraction , Transformation and Loading ( ETL ) data from various sources into Data Warehouse and Data Marts
• Worked on Informatica Designer Components - Source Analyzer , Warehouse Designer , Transformation Developer , Mapplet and Mapping Designer .
• Having good Knowledge on SQL & PL / SQL
• Understanding the business requirements and producing quality work in time
• Practical understanding of the Data modeling ( Dimensional & Relational ) concepts like Star - Schema Modeling , Snowflake Schema Modeling , Fact and Dimension tables
• Strong experience in Extraction, Transformation and Loading ( ETL ) data from various sources into Data Warehouses and Data Marts using Informatica Power Center ( Repository Manager , Designer , Workflow Manager , Workflow Monitor , Metadata Manger ), Power Exchange , Power Connect as ETL tool on Oracle , DB2 and SQL Server Databases
• Closely worked with business users in order to develop reports according to user requirements
• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server, DB2 8.0/7.0, UDB, SQL Databases, Mongo DB, MS Access and Teradata

TECHNICAL SKILLS:

Tools: JIRA, HP ALM/ Quality Center, QTP/UFT 12.0, Selenium WebDriver, SQL Developer,JMeter, Informatica Power Center 9.6,MYSQL

SDLC: Agile, Waterfall

Databases: Oracle 10g/11g, MS SQL Server.

Language: SQL, VB Script, C++, Fortran, Maple, AZ procede.

Operating System: Windows 2012,Windows 2008R2, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential - Santa Clara, CA

Senior Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection .
• Translated requirements into business rules & made recommendations for innovative IT solution
• Involved in the Design and development of Data Mart and populating the data from different data sources using Informatica.
• Documented data conversion, integration, load and verification specifications.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked with the various enterprise groups to document user requirements, translate requirements into system solutions and produce development, testing and implementation plan and schedule.
• Used transformations like Joiner, Expression, Connected and Unconnected lookups, Filter, Aggregator, Store Procedure, Rank, Update Strategy, Router and Sequence generator.
• Developed, documented and executed unit test plans for the components.
• Set some understanding according to the business approach and making development while confirming with BA’s, if any BR (Business Rule) being used was not effective. In a way, that using the experience and business understanding to make out BR’s and implements them to design the business logics.
• Documenting the developed code, run the sessions and workflows, while keeping track of source and target row count.
• Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Extensively used un-connected Look-Ups for minimizing the run time and add to the performance of the server, while making sure to avoid duplicates of data from other source systems .
• Created pre-session and post-session shell scripts and mail-notifications.
• Extensively worked on the Informatica Designer, Repository Manager, Repository Server, Workflow Manager/Server Manager and Workflow Monitor.
• Extensive use of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
• Extensive use of Performance tuning techniques to minimize the run time and create pre-session caches with load being balanced on server.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Co-ordinated with and led off shore team (India Development team).
• Employed performance tuning to improve the performance of the entire system.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Environment: Informatica Power Center 10.1 (Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console), SQL Server 2014, Flat Files, Netezza

Confidential - CA

Informatica Developer

Responsibilities:

• Analyzed the Specifications and identifying the source data needs to be moved to data warehouse.
• Involved in Database design, entity relationship modeling and dimensional modeling using Star schema .
• ETL mappings were developed to perform tasks like validating file formats, business rules, database rules and statistical operations.
• Used Informatica Designer to create Reusable transformations to be used in Informatica mappings and Mapplets.
• This project is intended to load and extract Procurement, Order Management, and Accounting data from Oracle database.
• Performed tuning of Informatica sessions by using optimizing techniques such as database partitioning , increasing block size, data cache size, sequence buffer length, target based commit interval and SQL overrides. Identify the Bottlenecks in mappings.
• Create test cases for the above projects in providing error free solution. Monitored Workflows and sessions using Workflow Monitor.
• Involved in Error handling (Ignore, rejecting bad records to a flat file, loading the records and reviewing them).
• Used Informatica Version Control for checking all the versions of objects, used in Mappings and Workflows to track the changes in Development, Test and Production environments.
• Debug through Session logs and fix issues utilizing database for efficient transformation of data.
• Prepared Mapping documents, Data Migration documents, and other project related documents like mapping templates and VISIO diagrams.
• Expertise in Data Modeling using tools likes Erwin, ER/Studio and MS Visio along with the hands on experience in using Forward Engineering and Reverse Engineering functionality.
• PL/SQL programming to create Oracle stored procedures and calling the procedures from Informatica sessions for data manipulation and error handling.
• Used shell scripts for automating the execution of maps.
• Experience in Working with Oracle PL/SQL, UNIX Shell Scripting in UNIX environment.
• Develop technical documents in ease of improvements on existing code.
• Involved in data conversion, migration, and integration quality profiling tasks.

Environment: Informatica Power Center 8.1, Oracle10g/9i, PL/SQL Developer, SQL Server 2005, UNIX, Windows 2003, AutoSys, Toad

Confidential - Austin, TX

Informatica Developer

Responsibilities:

• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis
• Configured static lookups, dynamic lookups, bulk uploads.
• Developed ETL mapping spreadsheet and Fact-Dimension matrix prior to performing the ETL process
• Involved in Data modeling for GL Data Mart to bring in various set of books assets and balances into the warehouse
• Used complex transformations such as Connected and Unconnected Lookups, Joiner, Router, Filter and Stored Procedure transformations for data loads
• Worked with Memory management for the best throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations and involved in pipeline partitioning
• Debugged and implemented the best practices in mappings, sessions and workflows for data extraction and loading into Slowly Changing Dimensions type 1 and type 2
• Created and scheduled Informatica workflows .

Environment: Informatica Power Center 9.6, Oracle 11g, Oracle PL/SQL, Windows Application Server, SQL Server 2008 R2

Confidential - Santa Clara, CA

Informatica Developer

Responsibilities:

• Worked with business requirements analyst to identify and understand source systems.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable transformation logic, known as ‘Mapplets’ using Informatica Designer.
• Modified several of the existing mappings and created several new mappings based on the user requirement.
• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance.
• Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
• Involved in Performance tuning of various mappings and sessions to increase the performance.
• Created and executed test cases for Unit and System Testing .
• Extensively worked on tuning and thereby improving the load time.
• Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
• Used Workflow monitor to see the work flows running and get the session properties and session log.
• Performed unit testing and documented the unit test plan and its results.

Environment: Informatica PowerCenter, Microsoft Visio 2003, Oracle 8i/9i, PL/SQL, UNIX, Windows NT/2000 and Siebel

Confidential

Informatica Administrator

Responsibilities:

• Responsible in drafting the SQL queries as per business and Transformation rules.
• Responsible to work on Dim and fact tables.
• Responsible to validate to source feeds, source tables and target tables as per business and transformation rule.
• Analyzing and Understanding the Mapping document
• Understanding Business Rules and transformation rules
• Analyzing and understanding the software Requirement Specifications.
• Creation and Execution of Test Cases.
• Reviewing Test Cases of team members.
• Logging defects in QC.
• Onsite Coordination.
• Daily Status Reporting.
• Maintain documentation of test results
• Follow agreed upon quality processes and standards

Environment: ETL Informatica, OS,QCNetezza,