SUMMARY:

• 12 years of IT experience in the field of Data warehousing in tools like Informatica, IDQ, MDM,BODS,Teradata, Oracle.
• Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
• Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects.
• Experience in designing error and exception handling procedures to identify, record and report errors.
• Extensive Experience in developing and performance tuning of informatica mappings
• Worked extensively in onsite (client location and having exposure of direct involvement with client).
• Created source to target mapping documents for input into ETL specifications by Identifying, analyzing data sources
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner .
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
• Experience in testing the data using debugging mapping method. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Created unit test cases to test data loads and check whether the components adhere to the technical design
• Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations

TECHNICAL SKILLS:

Informatica MDM Multi: Domain, IDD, SIF

ETL Tools: Informatica 10.X/9.X/8.x (Power Center/Power Mart),IDQ BODS,Teradata SQL Assistant, TOAD, Putty.

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes

Databases: Teradata, Oracle 12g/11g/10g/9i, MS SQL Server, MS Access

Languages: SQL, PL/SQL, Data Structures, Unix Shell

ScriptTools: SQL plus, PL/SQL Developer, SQL* Loader

Operating Systems: Windows NT/2000/2003/XP/Vista/7, Unix, Linux

DAC, BMCCTRL: M, Autosys

Supporting Tools: Service Now, TSRM

PROFESSIONAL EXPERIENCE:

Confidential, Chemung, NY

Sr Informatica Consultant

Environment: Informatica 10.1.0/9.6, Oracle 12g, Tableau, EBS,SQL Developer

Responsibilities:

• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Implemented Informatica error handling, dynamic parameter file generations and coding best practices
• Responsible for technical Design Document and Details mapping document
• Analyzing and understanding functional requirements.
• Used Informatica reusability at various levels of development.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies
• Develop informatica mappings and workflows for new change requests.
• Responsible for creating Source to Target data mapping.
• Developing Informatica ETL jobs to extract data from EBS and to load into the SQL Server.
• Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Created scripts for Batch test and set the required options for overnight, automated execution of test scripts
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation, variables
• Resolving issues raised by customer
• Handling Issues during development and analyzing phase and Fixing Bugs if any
• Preparing Test Results
• Unit testing
• Defect Fixing

Confidential

Sr Informatica Consultant/Developer

Environment: Informatica 9.1,IDQ,Oracle 11g, DAC

Responsibilities:

• Responsible for technical Design Document and Details mapping document
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Responsible for creating Source to Target data mapping.
• Interacting with the onsite people and resolving the offshore issues.
• Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
• Implemented Informatica error handling, dynamic parameter file generations and coding best practices
• Analyzing and understanding functional requirements.
• Used Informatica reusability at various levels of development.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Designed and developed Informatica mappings for data sharing between interfaces utilizing SCD type 2 methodologies
• Develop informatica mappings and workflows for new change requests.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Extensively used Informatica Power Center and created mappings using transformations like Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volumeof data
• Developed sessions using different types of partitions like round robin, hash key portioning for better performance.
• Handling Issues during development and analyzing phase and Fixing Bugs if any

Confidential

Sr Informatica Consultant/Developer.

Environment: BODS, TERADATA

Responsibilities:

• Extract, transform and Load data from different sources into Oracle database using SAP BODS XI4.0 as ETL tool.
• Experience in BTEQ scripts
• Have designed history logics and written good SQLs in Teradata.
• Have involved in solving complications in the production level issues.
• Have involved SIT and UAT defects closing.
• Worked extensively in Perl, shell scripting and click stream analysis
• Handled off shore for related work in respect of unit test case preparation and documentation like implementation, warranty & support.
• Have helped in re-building of Jobs based on requirement.

Confidential, Miami, FL

Informatica Consultant

Environment: Informatica 9.1, Oracle

Responsibilities:

• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Responsible for technical Design Document and Details mapping document
• Interacting with the onsite people and resolving the offshore issues.
• Developing Informatica ETL jobs to extract data from Source and to load intothe Oracle.
• Implemented Informatica error handling, dynamic parameter file generations and coding best practices
• Responsible for creating Source to Target data mapping.
• Used Informatica reusability at various levels of development.
• Attended weekly status meetings and provide detailed status report to the client.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Preparing Test Results, Unit testing, Defect Fixing

Confidential, Amarillo,TX

Informatica Consultant

Environment: Informatica, Oracle

Responsibilities:

• Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Analyzing and understanding functional requirements.
• Responsible for technical Design Document and Details mapping document
• Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Involved in retesting the defects
• Used Informatica reusability at various levels of development.
• Fixed the invalid mapping's and troubleshoot the technical problems of the database.
• Attended weekly status meetings and provide detailed status report to the client..
• Develop informatica mappings and workflows for new change requests.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Preparing Test Results, Unit testing, Defect Fixing