PROFESSIONAL SUMMARY:

• 10+ years of progressive IT experience in development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica PowerCenter, MDM and Microstratagy.
• Worked on all phases of data warehouse - ETL lifecycle, from gathering requirements to implementation, testing and support.
• Good Knowledge on Data modeling and DWH concepts by Erwin by implementing star schema to OLAP systems, Reverse Engineering and creating tables.
• As a member of Corporate Data Management Team, responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Experience in creation and maintenance of entity objects, hierarchies, entity types, relationship objects
• Continually research the information technology marketplace for new and innovative technologies and application development practices. Proactively propose these new technologies as solutions to business problems.
• Extensive experience in designing and development of mappings, transformation standards and processes using Informatica Power Center and Informatica Developer.
• Expertise in performance tuning of the ETL jobs by identifying the bottlenecks.
• Experienced in producing detailed technical specs, Proof of concepts, Change requests, run book and also involved in quality assurance review.
• Extracted data from various sources like Oracle, Sybase, API’ Confidential, Flat files and XML files with knowledge of Data Warehouse concepts.
• Experience in working on Unix Shell Scripts.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Expertise in performance tuning of the ETL jobs by identifying the bottlenecks.
• Good understanding between OLTP and OLAP systems.
• Knowledge in Oracle - SQL, PL/SQL and Sybase and with knowledge in capital markets and insurance domain.
• Experienced with Teradata utilities Fast Load, Multi Load, BTEQ scripting, Fast Export, SQL Assistant.
• Experience in doing Tuning of Teradata Queries using Explain plan.
• Ability to quickly grasp new concepts, both technical and business related and utilize as needed.
• Extensive experience in software development lifecycle and adept in software coding standards.
• Maintaining high availability of Informatica platform.
• Excellent interpersonal, analytical and communication skills.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows 2010/NT 4.0/98/95/XP

RDBMS: Oracle, Teradata, Sybase, SQL Server, MS -Access

ETL Tools: Informatica 6.x/7.x/8.x/9.x, 10.x and MDM 9.6, IDD 9.6.

OLAP Tools: Microstratagy, Qlickview

Scheduling Tools: Crontab, approx., Autosys

Languages: SQL, PL/SQL, XML, Core Java

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead Developer

Responsibilities:

• Understanding the architecture of the project and the data model.
• For extracting the data feed files from the vendor location, written shell scripts with exceptional handling and restart logic.
• Involved in creating the mappings for applying the business rules and loading them into the respective tables.
• Involved in Developing mappings and workflows for different Dimensions and Fact Table loading.
• Involved in bringing the ratings data from the Fact and the different Dimensional tables in RRDW (Ratings Reporting Data Ware House) into the Staging Table.
• Involved in Unit Testing the Code.
• Used transformations like Source Qualifier, Router, Normalizer, and Connected and Unconnected lookups, Filter, Sorter and Sequence to handle situations depending upon the requirement.
• Extensively used Type 1 and Type 2 logics in mappings.
• Bug Fixing of the associated mapping (if any).
• Worked on creating the UNIX scripts for running the process, generating the parameter file and for different email notifications.
• Extensively used mapping parameters, workflow parameters and parameter files.
• Day to day coordinating between onsite and offshore from offshore.
• Ensure quality of deliverables by following predefined standards.
• Code review of Power Centre mapping/Workflow.
• Prepare process documents to stream line the process.

Environment: Informatica 10.1.1, Oracle 11g, UNIX Shell Programming, Microstratagy, Drools, Java.

Confidential

ETL/MDM Developer

Responsibilities:

• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Identified Golden Record (BVT) for Customer Data by analyzing the data and duplicate records coming from different source systems.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records
• Ensure quality of deliverables by following predefined standards.
• Wrote complex SQL Queries involving multiple tables with joins.
• Worked with DBA team to fix performance issues at Database
• Created mappings using Informatica Power center and loading data into pre-landing tables.
• Implemented source and target based partitioning for existing workflows in production to improve performance so as to cut back the running time.
• Defined and configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Understood the existing data model, ETL flow and architecture of the project
• Extensively used Joiner, Lookup and Normalizer transformation to transpose the verbal data into fact table.
• Created mapping specifications and Designed the mappings
• Created Sessions, Workflows for initial and incremental loads.
• Modified and supported UNIX shell scripts to control the entire load process.
• Discussion with client to clarify issues

Environment: Informatica 10.1.1, MDM 9.6, IDD 9.6, Oracle 11g, UNIX Shell Programming, Autosys, Java.

Confidential

Lead Technical

Responsibilities:

• Understood the requirements and designed the ETL process.
• Interacting with Client and gathering requirements on enhancements changes.
• Understood the requirements and designed the ETL process.
• Worked on Transformations like Source Qualifier, Expression, Mapplet Input, Mapplet Output, Look-up, Filter, Normalizer, Router, Update Strategy and Sequence Generator.
• Involved in Performance tuning/bottlenecks and eliminated the bottlenecks to optimize the performance.

Environment: Informatica 10.1.1, UNIX, Oracle 11g, Java

Confidential

Senior Software Engineer

Responsibilities:

• Understanding the Client Requirements and Developed Mappings as per Client Requirements.
• Interacting with Client and gathering requirements on enhancements changes.
• Installed Informatica Power Center8.6.1 on Development Server and configured Domain, Node, Integration and Repository Services.
• Worked on Power Center Designer - for developing Mappings in Mapping Designer, for Creating Mapplet in Mapplet Designer, for Creating Reusable Transformations in Transformation Developer.
• Worked on Workflow Manager to develop Workflows and Reusable/Non-Reusable Sessions.
• Worked on Transformations like Source Qualifier, Expression, Mapplet Input, Mapplet Output, Look-up, Filter, Normalizer, Router, Update Strategy and Sequence Generator.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, fast-export, multi load, and fast load.
• Worked with Teradata utilities such as M-load, F-load, export etc. to load or extract tables.
• Worked on Teradata SQL Assistant querying the target tables to validate the BTEQ scripts.
• Proactively identified, managed, and corrected data quality issues with reports provided to Clients Using Teradata - BTEQ, MLOAD and FASTLOAD.
• Worked on Teradata and its utilities - tpump, fastload through Informatica.
• Involved in Performance tuning/bottlenecks and eliminated the bottlenecks to optimize the performance.
• Involved in Preparing Unit test cases, System Test Cases and User- acceptance test case.

Environment: Informatica 9, Oracle 9, UNIX, Teradata

Confidential

Senior Software Engineer

Responsibilities:

• Understanding the architecture of the project and the data model.
• Understanding the Functional Requirements and creating mapping design doucments.
• Prepared the ETL specifications for business logic’ Confidential
• Involved in the preparation Unit Test Plan and Change Request documents.
• Extesively used Type 1 and Type2 logics in mappings.
• Tuning the Mappings and sessions to enhance the performance.\
• Worked on Teradata SQL Assistant querying the target tables to validate the BTEQ scripts.
• Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Responsible for consolidation of team status report
• Onsite-Offshore Co-ordination

Environment: Informatica 9.1, Oracle 9i, Teradata, Erwin, UNIX Shell Programming.

Confidential

Lead Tech Consultant

Responsibilities:

• Understanding the Functional Requirements and creating mapping design doucments.
• Prepare the ETL specifications for business logic’ Confidential
• Involved in the preparation Unit Test Plan and Change Request documents.
• Used different transformations like Expression, Normalizer, Update strategy, Lookup, Union, Router and Filter etc in creation of mappings.
• Tuning the Mappings to enhance the performance.
• Onsite-Offshore Co-ordination.

Environment: Informatica 8.1, Oracle 10g, SQL Server 2008, UNIX, Qlickview.

Confidential

Senior Developer

Responsibilities:

• Preparation of DOU.
• Created mappings using informatica tool for DQ checks and bring the data from source to staging tables and from staging table to target tables.
• Involved in development of mapplets using various transformations of informatica according to business logic.
• Worked on Lookup, Router, Union, Joiner and Sql Transformations.
• Tuning the Mappings to enhance the performance.
• Worked on UNIX scripts and able to write basic scripts.
• Ensure quality of deliverables by following predefined standards.
• Wrote complex SQL Queries involving multiple tables with joins.
• Worked with DBA team to fix performance issues at Database

Environment: Sybase, Informatica 8.1, UNIX, BO XI, Windows XP

Confidential

Senior Developer

Responsibilities:

• Responsible for Production Support
• Process Monitoring
• Fixing the Production issues on high priority basis.
• Change requests.
• Created complex mappings using Unconnected Lookup, Aggregate, Normalizer and Router transformations for populating target table in efficient manner.
• Recover the failed Sessions
• Prepare process documents to stream line the process.

Environment: Informatica 7.1/8.1, Oracle 9i, UNIX, Business objects.

Confidential

Junior Developer

Responsibilities:

• Development of Java Server Pages.
• Involved in coding in Masters Module, Reports Module, and Utilities Module.
• Developing and deploying Enterprise Java Beans for Business logic.
• Developing the Deployment Descriptor for WEB components.
• Perform manual testing for entire application and debugging.
• Perform manual testing for entire application.

Environment: J DK1.4, JDBC, Servlets, JSP, Windows2000, Web Server: Tomcat 4.14.