SUMMARY:

• Over 8 years of experience in the field of Information Technology, with extensive experience in analysis, design, development, data conversion, Data Warehouse, Unit testing and documentation.
• More than seven Years of strong experience in using ETL (Extraction, Transformation, Loading) utilizing Informatica Powercenter 8.6.1,9.1,9.5.
• Strong knowledge of Data warehousing concepts, dimensional Star Schema and Snowflake schema methodologies.
• Experience in database design, Entity - Relationship modeling and Dimensional modeling
• Participated in Design team and Requirement gathering meetings.
• Was Responsible for understanding User requirements and translating those requirements into well designed solutions.
• Proficient in understanding business processes / requirements and translating them into technical design
• Data Processing experience in designing and implementing Data Mart applications
• Solid understanding of Data Warehousing and BI life cycle and strong working experience in Data Warehousing and reporting applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources, OLTP into the Data Warehouse using Informatica.
• Extensive experience in database technologies (Creating indexes, tables, views and performing SQL tuning )
• Experience in writing Unix Shell Scripts.
• Extensive experience in end to end ETL design, documentation, development, testing and client support.
• Extensively worked on Informatica Power Center client tools including Mapping Designer, Workflow manager, Workflow Monitor and Repository Manager
• Highly motivated team player with excellent analytical & problem solving skills possessing the ability to effectively communicate with higher management and stake holders.

TECHNICAL SKILLS:

ETL Tool: Informatica Powercenter 8.6.1/9.1/9.5

Databases: Teradata 13,14, Oracle 10g/11g, SQL Server

Tools: /Utilities: TOAD, Teradata Sql Assistant, SQL Analyzer

Operating Systems: Unix, Linux, Microsoft Windows XP/Windows 7

Scheduler Tools: Ctrl-M, informatica scheduler,Dollar Universe

Defect Tracking Tools: Peregrine tool,SVN tag

Misc. Applications: ITSM,PVCS,Kintana

Languages: Unix Shell Script

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Informatica Developer

• Developed Informatica mappings based on Star schema model.
• Involved in Analyzing the LDM(logical design model) and PDM(Physical Design Model).
• Involved in preparing the LLD(Low Level Design documents).
• Tuned the Performance of Informatica processes and efficiently reduced the run time of some of the critical sessions .
• Worked on shell scripts to handle flat files which include files from source system and transferring files to downstream systems.
• Worked extensively on Informatica Power Center using Source Analyzer, Mapping designer.
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Developed several Complex Informatica Mappings to facilitate daily, Weekly,Monthly loading of Data.
• Worked extensively with Offshore Team for completing the ING Integration Projects.
• Onsite Point of Contact for Off-shore team in designing and developing ETL mappings as part of Data Warehousing project.
• Coordinated with the Change Management to deploy ETL mappings into QA, Production environments.
• Actively participate in design reviews. Identified gaps in requirements at the design stage and probe for detailed explanation of expectations.
• Obtained Business and Management’s sign off on the Design documents
• Conducted Walkthrough meeting with developers, testers and Data sourcing Teams to review Client requirements documents (CRD).
• Acted as the point of contact for any files sending to downstream applications from Development/Pre-Prod Environment.
• Working closely with code migration team to deploy the ETL code from Dev to QA, UAT and Prod to make sure code is migrating without any issues.

Environment: Informatica 9.1, Informatica 9.5, Teradata 14, SQL Assistant, Flat Files,SFTP, Control-M, UNIX Shell script,SVN tool

Confidential, Rochester, NY

Informatica Developer

• Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Periodically reviewed the requirements/design with the Business and development team and escalated the issues about project potential bottlenecks to project manager.
• Interacted with the user community to write the Functional Requirements for the business processes.
• Extensively used almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank.
• Created ETL process from source system to Core database and then to final datamarts and created ETL Design documents for review with Management Team.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements in Teradata RDBM.
• Created Tasks such as session which contains the mapping which is built in the designer and email using Workflow manager tool like Task Developer.
• Scheduled, Executed and Monitored sessions by using Informatica Workflow Manager.
• Worked closely with QA and Production team in helping them to understand the process.
• Validated business defined rules while loading the data in to Enterprise Data warehouse(EDW) using Teradata SQL's.
• Wrote Unix Shell Scripts for extracting parameters and automating the FTP and SFTP Processes.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Participated several ‘Go-No-GO’ meetings before any major release to Production.

Environment: Informatica 9.1, Teradata 14, SQL Assistant, Oracle 10g/11i,, UNIX Shell script

Confidential, Harleysville, PA

Informatica Developer

• Responsible for designing and developing the Informatica mappings.
• Involved in performance tuning of the mappings.
• Developed ETLS which run on Daily,weekly and monthly basis.
• Involved in developing the SQLs for the high level Aggregations.
• Interacted with the client to understand the business and functional requirements.
• Involved in analysing the stored procedures, triggers to maintain the referential Integrity, functions, view to handle business logic and functionality of various modules.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Users provide the source data in flat files and loading into stage tables using ETL process.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, router, sql and lookups.
• Involved in data profiling and data quality activities.
• Data validation from sources through the dashboards.
• Responsible for unit and integration testing
• Involved in code review process.
• Involved in creating the listfiles to move the code to different environments.
• Developed Unix Scripts to perform file movements and validations
• Created, scheduled sessions and tasks. Involved in the performance tuning of Informatica mappings.
• Migration of Informatica objects from Development to testing and then to production and setting up the UNIX directories for Parameter files and Logs.
• Closely interacted with the reporting team which uses Cognos for generation of reports.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans

Environment: Informatica 9.1, informatica scheduler, Teradata 14, SQL Assistant, Oracle 10g/11i,FlatFiles, UNIX Shell script, TOAD Quest software

Confidential

Informatica Developer

• Interacted with the business users in order to understand the business and functional requirements.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows.
• Data validation from sources through the dashboards.
• Responsible for unit and integration testing
• Involved in migrating the code from DEV toQA,QA to UAT,UAT to PROD
• Involved in developing the mappings for staging,Integration and symantic layers.
• Designing the data base objects using SQL Server management studio as per the project specifications.
• Involved in building the database and created stored procedures, triggers to maintain the referential Integrity, functions, view to handle business logic and functionality of various modules.
• Creation/ Maintenance of Indexes for various fast and efficient reporting processes
• Users provide the source data in flat files and loading into stage tables using ETL process.
• Developed standard mappings and mapplets using various transformations like expression, aggregator, joiner, router, sql and lookups.
• Involved in preparing the LLD(low level design document).
• Involved in data profiling and data quality activities.

Environment: Informatica 9.1, informatica scheduler, Teradata 14, SQL Assistant, Oracle 10g/11i, UNIX Shell script, TOAD Quest software

Confidential

Informatica Developer

• Responsible for designing and developing the Informatica mappings for data loads.
• Developed Parameter files for Data Integrity.
• Used almost all of the transformations of Informatica including lookups, Update Strategy, Union, Sorter, Router and others.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Worked with Informatica Best Practices guidelines to minimize performance issues.
• Responsible for weekly status updates showing the progress of development life cycle.
• Involved extensively in conducting integration, performance and UAT testing.
• Involved in Backend Database analysis in Oracle using SQL.
• Involved in DBI (Daily Business Intelligence), Oracle 11i Upgrade, Oracle Security Patches, Application Infrastructure Upgrade, Purchasing and Contract Reporting

Environment: Informatica 8.6.1,9.1, Data flux, Teradata 14, SQL Assistant, Oracle 10g/11i, Dollar universe, UNIX Shell script, PVCS(code versioning),kintana(code movement)