SUMMARY:

• 12 years of in - depth and comprehensive experience in design, development, Testing, Security and Support for Data Warehousing, and Client/Server projects.
• 9 Years of Experience in Informatica Power Center/IDQ
• Experienced application developer in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Informatica Power Center
• Expertise in Informatica tools such as Informatica (Power Center Repository Manager,WorkFlowManager,Designer,Work Flow Monitor And Administration Console)
• Experience using ETL Tools Informatica Power Center data mart life cycle development, design, development and testing of ETL procedures using Informatica.
• Extensive experience in integration of various data sources like Teradata, Oracle, SQL Server and DB2 UDB
• Strong background collaborating with customers, end-users and management utilizing excellent communication skills.
• Knowledge of migrating legacy systems from other ETL tools to Informatica. Solid understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data Modeling using Erwin.
• Experienced in developing implementation plans and schedules and preparing documentation for the jobs according to the business requirements.
• Strong experience in coordinating and providing support to UAT/BAT/QA Team during testing phase of Project life cycle.
• Experience on working in a production support(24x7) environment, resolving the issues, providing support with technical and business issues.
• Experience in providing knowledge transfer and support to the team.
• Ability to handle co-ordinate onsite and offshore teams and implement various activities related to the project as per the requirement and up to the satisfaction level of the management.

TECHNICAL EXPERTISE:

ETL Tools: Informatica Power Center 8.x/9.x, DataStage

RDBMS: Oracle Client 10g, SQL Server 2005, DB2, Teradata, MS Access

Languages: XML, SQL, Pl/SQL

Operating Systems: Windows NT/2000/XP, Unix, Z/OS

Other Tools: TOAD, SQL Assistant, WinSQL, VSS, Developer 2000, Crystal reports.

DataModeling Tools: Erwin 4.1.2,Visio.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Senior ETL Developer/Architect

Technology: Informatica 10.1, Oracle 11g

Responsibilities:

• Understanding existing data model, ETL load process, identified existing system bottleneck and end user expectation.
• Involved in developing the ETL frame work for the project
• Conducted workshop session with Business and other stake holders to identify the requirements
• Interact with source system application stake holders to understand the data
• Involved in designing the architecture of Integration Layer
• Involved in development of Integration layer End to End using Informatica and PL/SQL
• Used Oracle procedures, Functions and Package
• Involved in scheduling the jobs using Control M
• Involved in creating project in Data transformation studio and calling them in power center for converting JSON files.
• Used Informatica Data Quality (IDQ) Mapplets to cleanse the demographic information
• Used parallel processing and multiple pipelines to improve the performance.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort
• Created Reusable UDFs to standardize validation and transformation of data
• Lead a team of 10 people at maximum capacity which includes dev team and system testing team
• Developed complex mappings using transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Transaction control, Source qualifier, Update Strategy.
• Used dynamic lookup cache to synchronize data between target and lookup cache for better performance.
• Used SQL queries to effectively extract the data from multiple source
• Used scripting to validate the incoming file and moving the files accordingly after processing.
• Performed SCD type2 implementation
• Used parallel processing to improve the performance.
• Work as onshore lead with the offshore team in reviewing the code and resolving any bottle necks faced by the team
• Review the code developed by the team to ensure code is according to the standards and with optimized performance.
• Change the design of mappings to improve the performance of jobs.
• Involved in writing the Unix scripts.
• Perform the impact analysis if any of the requirements are changed due to the business needs and identify the percentage of code to be changed.
• Perform the unit testing for the code developed.

Confidential, Morrisville, NC

Senior ETL Developer

Technology: Informatica 9.6, Oracle 11g

Responsibilities:

• Participate in the requirement session
• Understand the requirements complexity and analyze the data in profiling database
• As part of data profiling, identify any data conflicts when compared to the requirements andClarify/resolve them with the help of customer.
• Design the performance optimized process from end to end using the best practices.
• Used SQL queries to effectively extract the data from multiple source
• Used scripting to validate the incoming file and moving the files accordingly after processing.
• Used Informatica Power center to build the ETL jobs to extract the data from multiple source,transform and load the data (via multiple layers) into Landing zone from where the MDMpicks up the data for performing match and merge and generating the golden copy of record.
• Performed SCD type2 implementation in Informatica mappings
• Used power center as a web service client to a RESTful webservice outside power center.
• Used UDF to format the different date format in to the required format.
• Used parallel processing and multiple pipelines to improve the performance.
• Work as onshore lead with the offshore team in reviewing the code and resolving any bottle
• necks faced by the team
• Review the code developed by the team to ensure code is according to the standards andwith optimized performance.
• Change the design of jobs to improve the performance of jobs.
• Involved in writing the Unix scripts.
• Perform the impact analysis if any of the requirements are changed due to the businessneeds and identify the percentage of code to be changed.
• Perform the unit testing for the code developed.
• Review the unit test data and results for the code developed by the team.
• After the completion of unit testing, move the code to the QA environment
• Identify the root cause for the defect if any raised by QA. Correct the code for the codingdefect and get in touch with business users if the defect is out of scope of requirements.
• Schedule the ETLs as per the requirement
• Prepare KT documents and performed K during hypercare.