SUMMARY:

• Over 10+ years of Information Technology experience in Analysis, Design, Development, Implementation, ETL Testing and Maintenance of DataWarehouse.
• Experience in Data Integration from Peoplesoft, Oracle EBS, Salesforce - CRM systems using Informatica cloud and using Informatica Power Center (9.x/8.x)/ Datastage.
• Proficiency in developing SQL with relational databases like Oracle 11g, 10g, Teradata V12 and DB2 V9.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts/Decision Support Systems using Informatica Power Center 9.x/8.x/7.x/6.x ETL tool.
• Experience in documenting High Level Design, Low level Design, Test plans, Unit test cases, Deployment documents and ongoing operational support.
• Experienced in working on projects following Agile Methodology.
• Experience with dimensional modeling using star schema and snowflake models.
• Extensively used Slowly Changing Dimension (SCD) techniques, implemented Error Handling Methodologies.
• Extensive work experience in developing ETL programs for Data Extraction, transformation and loading using Informatica Power Center.
• Experienced in using UNIX commands and in creating new/modifying UNIX Shell scripts for file processing, data validations and Job executions.
• Highly proficient in identifying performance bottlenecks and fine-tuned the processes in Informatica and at Confidential level.
• Developed Test plans and testcases to effectively test application/data quality against Requirements document and client expectations.
• Represent team in the Quality Assurance and defect management status meetings.
• Foresee issues/blockers and intimate release management about the impact.
• Expertise in scheduling Informatica jobs using Informatica, $U and Control-M.
• Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills, self-motivated and ability to work independently.
• Understands Reporting needs and functioning of Tableau/OBIEE.
• Good analytical, strong interpersonal and excellent communication skills.

TECHNICAL SKILLS:

• Informtica 9x/8.x/7.x
• Oracle 10g(TOAD)
• DB2 V9
• Teradata V13
• SQL Server
• SQL
• PL/SQL
• Microsoft Visio
• Windows NT/2000/XP
• HP-UX
• Business Objects 6.x
• $Universe
• Control-M
• Mercury Quality Center
• PVCS
• Kintana
• PPM
• Perforce

PROFESSIONAL EXPERIENCE:

Confidential,Palo Alto,CA

Senior ETL developer

Environment: Oracle 11g, Informatica 9.5.1

• Worked closely with the Users in order to understand the requirement and performed Gap Analysis to identify gaps in the existing data.
• Used Informatica Power Center to bring data from University CAP DB to Warehouse.
• Created Procedures to breakdown arrays of authors/citations/publications etc.
• Parsed JSON data to get author lists and citation counts.
• Created Summary tables and Materialised views to support report requirements.
• Developed and implemented Error Handling Strategies.
• Developed Restartability strategy for all the workflows.
• Worked on unit testing and code migration from one environment to another.
• Prepare code migration checklist.
• Scheduled the Workflows and Procedures using Informatica.
• Extend ongoing support for the developed application and existing applications.

Confidential,Palo Alto,CA

Senior ETL developer

Environment: SQL Server, Informatica 9.1, Linux, SharePoint and SFDC

• Actively involved in understanding the environment and the business requirement.
• Worked closely with the Users in order to understand the requirement and perform Gap Analysis.
• Integrated data from Oracle EBS, Salesforce and SQL Server source systems.
• Developed and implemented Error Handling Strategies.
• Informatica Designer tools are used to design the source definition, target definition and transformations to build mappings.
• Created Informtica worflows and scheduled them through Informatica.
• Deeloped Restartability strategy for all the workflows.
• Worked on unit testing and code migration from one environment to another.
• Prepare code migration checklist.
• Worked with production support team and coordinated creation of new objects in test and production environments.

Confidential, MA

Senior Informatica developer

Environment: SQL server, Informatica 9.1, Linux, SharePoint, SFDC

• Actively involved in understanding the environment and the business requirement.
• Worked closely with the Users in order to understand the requirement and performed Gap Analysis.
• Informatica Designer tools are used to design the source definition, target definition and transformations to build mappings.
• Integrated data from Oracle EBS and Teradata source systems
• Developed and implemented Error Handling Strategies
• Informatica Designer tools are used to design the source definition, target definition and transformations to build mappings.
• Integrated data from Oracle EBS and Teradata source systems
• Developed and implemented Error Handling Strategies
• Created Informatica workflows, parameter files to make code reusable, develop audit system to check number records for a file, schedule the workflows, peer review, document test results and move code to perforce.
• Involved in unit testing and code migration from one environment to another.
• Prepare code migration checklist.
• Worked with production support team and coordinated creation of new objects in test and production environments

Confidential

Senior Informatica developer

Environment: DB2 V9, Informatica 8.6, Control M

• Prepare Use cases based on Requirement documents.
• Development and review of test cases/scripts, Upload test cases.
• Identify and perfrm checks to ensure the environment readiness.
• Create test data covering all the scenarios.
• Test case execution, Bug identification, tracking and closure, communicate across stakeholders for understanding the requirement, getting signoffs on the test cases, tracking defects and status reporting during Test Cycles.

Confidential

Senior Informatica developer

Technical Environment: DB2 V9, Informatica 8.6, Control M, Unix, Oracle 10g

• Understand the design and develop the application, analyze and estimate the impact of changes in design during development.
• Created the several mappings to extract the data from fixed width and delimited flat files from DB2.
• Create mappings which involve various business rules to populate the data from Stage1 to Stage2 and from Stage 2 to EDW.
• Created various transformations like Source Qualifier, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Worked on loading techniques like SCD's and incremental loading for extraction, transformation and loading of the data.
• Worked extensively with various passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator and Lookup Transformation.
• Extensively used SQL override in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join and Master Outer Join in the Joiner Transformation.
• Created connected and unconnected Lookup transformation to get the related values.
• Responsible for performance tuning of Sources, Targets, Mappings and SQL queries in the Transformations.
• Experienced in writing PL/SQL Stored Procedures.
• Unit testing of the code
• Involved in code reviews to ensure that organizational and client standards are maintained in code and document unit test results
• Coordinate with the testing team in addressing the defects and resolved on time.

Confidential,San Jose,CA

Senior Informatica developer

Technical Environment: Informatica 8.6, Control M, Unix, Oracle 10g, TOAD, OWB,

• Test Scoping, Test strategy preparation
• Development of test cases/scripts, Test script reviews, Test case execution, Bug identification, tracking and closure
• Developed unit test cases and prepared test data for testing.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• As a QA Tester, performed both functionality and back end testing.
• Developed SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked with Production environment to resolve several data issues.
• Used SQL queries and custom programs to perform data validation.
• Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.
• Coordination with offshore team
• Daily test status reporting and metrics, UAT coordination.

Confidential,San Jose,CA

Senior Informatica developer

Technical Environment: Oracle10g, Teradata, TOAD, Informatica 8.6, $U

• Translated business processes into Informatica for building data marts.
• Worked with different sources such as Oracle, SQL Server and Flat files.
• Used Informatica Administrator to create repository, user groups, and managed users by setting up their privileges and profile.
• Designed Informatica ETL jobs for extracting data from heterogeneous source systems, transforming and finally loading into the data marts.
• Created source table definitions in the Informatica repository by studying the data sources.
• Created re-usable components using shared containers for local use or shared use.
• Created shell scripts that will invoke the Informatica jobs passing all variables for job to execute with parameterized databases connection information.

Confidential

Informatica developer

Technical Environment: Oracle10g, Teradata, TOAD, Informatica 8.6, $U

• Involved in attending meetings with the business users to gather the requirements
• Involved in design and development of Enterprise Data Warehouse (EDW)
• Analyzed the business requirements and functional specifications Worked closely with Project Team, Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications
• Used Informatica Power Center 9.1 for extraction, transformation and load (ETL) data into the EDW and other Oracle Interfaces.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator, Stored Procedure, XML and so on.
• Developed complex mappings in Informatica to load the data from various sources like Oracle, TIBCO, flat files and so on.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings. Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse Confidential .
• Performing Validations at the backend, using TOAD to check that the data is loaded into the Target tables.
• Performed unit test of all the components.