SUMMARY:

• 12 years of IT experience in the field of Data warehousing in tools like Informatica 8x, 9x, 10x Power Center, Developer (IDQ),Analyst,AWS,Cloud, Oracle,Teradata,SQL Server and UNIX Shell Scripting.
• 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.
• Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Hands on Labeling, Standardization, validating address using Address doctor by Informatica Developer of IDQ.
• 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).
• Experienced with Informatica Power Exchange for Loading/Retrieving data from mainframe systems.
• Experience in using Address Doctor as Address Validator transformation to cleanse address data.
• Experienced in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Experience with advanced ETL techniques including staging, reusability, data validation, change data Capture (CDC)
• Experienced with Informatica Power Exchange for Loading/Retrieving data from mainframe systems
• Used Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception,Standardizer and other significant transformations.
• 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 resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Proficient in Creation of re-usable mapplets, Transformations using various transformations of Informatica.
• Notification of the session is implemented through the Emailing.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.
• Experience in developing Shell Scripts on UNIX and experience with UNIX command line.
• Involved in Informatica Interview Panel and taken interviews to the external and internal resources.
• 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.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.

TECHNICAL SKILLS:

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

Data Modeling: Physical Modelling, Logical Modelling, Relational ModellingDimensional 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

Scheduling Tools: DAC, BMC-CTRL-M, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr.Informatica Developer

Environment: Informatica PowerCenter 10.2.0,IDQ,SQL Server 2012

Responsibilities:

• Gathering Business requirements and creating technical specifications along with creating Internal and External Design documents
• Created mappings using informatica Developper tool for extracting data from DWH to Data Lake
• Medium to complex quality rule design, development and implementation patterns with cleanse, parse, standardization, global Address Validation,global phone number validation and format, Search Match, Match Merge.
• Create & deployed IDQ applications and run the applications, workflows, mappings using Unix scripts.
• Extensively worked on IDQ rules, reference table and Mapplets.
• Extensively used IDQ for functional analysis, Profiling and for development activities and also invoking IDQ as Mapplets.Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data..
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups,queries,packages and query groups.
• Worked on data cleansing and standardization using the cleanse functions in Informatica IDQ.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Used IDQ’s standardized plans for addresses and names clean ups.
• Worked on IDQ file configuration at user’s machines and resolved the issues.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality environment
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Created Batch scripts to call Informatica workflow's for number of times. Created different jobs using batch scripting to call the workflow by using Command tasks.
• Executed Sessions, Sequential and concurrent batches for proper execution of mappings.
• Used parameters/variables for Powercenter mappings, sessions and workflows.
• Debug the sessions by utilizing the logs of the sessions
• Participated in Deployment by adding objects into deployment group and moving the code from test to production.
• Monitor Workflows in Production Environment and debug/resolve issues
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Debug the sessions by utilizing the logs of the sessions.

Environment: Informatica PowerCenter 10.2.0,SQL Server

Confidential, NY

Sr.Informatica Developer

Environment: Informatica PowerCenter 10.0, Developer (IDQ),BDM,AWS,Unix,Oracle 12g,SQL Server

Responsibilities:

• Analyzed business documents and created system requirement specification.
• Extensively used Informatica power Center 10.2 for ETL (Extraction, Transformation and Loading), data from relational tables and flat files.
• Extensively worked on complex mappings, mapplets and workflow to meet the business needs and ensured they are reusable transformation to avoid duplications..
• Utilized the Informatica Data quality management suite (IDQ and IDE) to identify and merge customers and addresses.
• Performed data validation testing writing SQL queries
• Developed shell scripts for Daily and weekly Loads and scheduled using Unix Maestro utility.
• Involved in writing SQL scripts, stored procedures and functions and debugging.
• Involving in Functional Testing & Regression Testing
• Responsible for providing comments for user stories within an AGILE software development SCRUM environment.
• Created sessions and batches and tuned performance of Informatica sessions for large data files by increasing the block size, data cache size and target based commit interval.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Used debugger to test mapping at designer level.
• Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
• Created configured and scheduled the sessions and Batches for different mappings using workflow manager and using UNIX scripts.
• Handling Issues during development and analyzing phase and Fixing Bugs

Environment: Informatica PowerCenter 10.2.0, Developer (IDQ),AWS,SQL Server, Oracle 12g

Confidential, Irving, TX

Sr. Informatica Consultant

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.
• Developing Informatica ETL jobs to extract data from EBS and to load into the SQL Server.
• 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

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

Confidential

Sr Informatica Consultant/Developer

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
• 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
• Creation of re-usable mapplets, Transformations using various transformations of Informatica.
• Implementing incremental logic for data extract from ERP system.
• Scheduling the session’s tasks comprising of different mappings for data conversion, extractions in order to load data into oracle database.
• 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

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

Confidential

Sr Informatica Consultant/Developer

Responsibilities:

• Extract, transform and Load data from different sources into Oracle database using Informatica 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 shell scripting and click stream analysis
• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
• Written the scripts needed for the business requirements (BTEQ Scripts).
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Transformed bulk amount of data from various sources to Teradata database by using BTEQ scripts.
• Extracted data from various Sources like Oracle, Excel Spread sheets, XML, Sybase, Teradata and Flat Files.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion
• 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.

Environment: Informatica, TERADATA

Confidential, Miami, FL

Informatica Consultant

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

Environment: Informatica 9.1, Oracle,Unix

Confidential, TX

Informatica Consultant

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
• 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.
• 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

Environment: Informatica 8.6,UNIX, Oracle

Confidential

ETL Consultant

Responsibilities:

• Defect identification.
• Execute regression tests and feature tests, Build/Patch Verification
• AR/SPAR verification and validation
• Raising Bugs using JIRA Tool
• Preparing Quality and Technical Related Documents
• System Test effort estimation and planning.
• Feature description change request review.
• System Test matrix creation/ Updating.