SUMMARY

• 7 years IT experience in developing BI Applications Using Informatica, Oracle, Mainframe, Sql Server & UNIX Shell Scripts.
• Diverse experience in HealthCare & Banking Domains
• Secured CTS Wah&Scope Awards for my contribution towards multiple Projects
• Secured Client Award from Confidential for contribution of project.
• High working experience with Informatica PowerCenter transformations like Joiner, Router, Update Strategy, connected and unconnected lookups, Expression, Sorter, Filter, Union, Normalizer, etc. Also worked with varied sources and targets like relational tables, flat files, VSAM files etc. Aware of the basic administrative tasks with Integration Service, Repository Manager
• 3+ years of experience in dimensional modeling techniques like Star and Snowflake schemas using Erwin
• Designed and developed EDW, DM and Data Quality Systems for prestigious clients Confidential & Confidential .
• Strong in performance tuning of complex Oracle queries.
• Involved in detailed Analysis, design, development, maintenance and upgrading systems to support business operations.
• Created and Used Workflow Variables, Session Parameters and Mapping Parameters
• Experience in Creating Tables, Views, Indexes, Synonyms, Constraints, Procedures, Shell Scripting, FTP and Remote copy
• Very flexible and can work independently as well as in a team environment
• Involved in Preparing HLD,LLD, Test cases, Test Plan, Cut over Plan and ETL Estimation
• Involved in Infra in migrate code into different environments
• Worked on different Sources such as Oracle, Power Exchange VSAM Files, SQLServer, Salesforce and Flat Files
• Experienced in Performance and tuning of the ETL.
• Shares learning and coaching experience through knowledge transfers between peers

TECHNICAL SKILLS

ETL: Informatica Power Center 9.x/8.5.1/7.x/6.x, Informatica Power Connect & Exchange for Mainframe.

DB: Oracle 11i/10g/9.x/8.x, MS Sql Server 2008

Design/Application: Microsoft Visio (Visio Soft Diagram), Control - M, TOAD, Query man, SQL Developer.

Languages/Scripting: UNIX, PL/ SQL, UNIX Shell Scripting.

Operating System: Sun Solaris, UNIX/LINUX, MS-DOS, Windows 2008/2007/ NT/2000/XP

ERP: SAP.

Other Tools: Toad, Sql Developer, Winscp, Putty, Jira, Quality Center, ClearCase

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Informatica Lead/Sr.Developer

Responsibilities:

• Created Procedures to Generate Tables Data into Files Dynamically
• Created database objects such as tables,views,stored procs,functions in Oracle
• Involved in ETL design, coding, testing and implementations.
• Designed ETL processes for optimal performance.
• Created test cases and test scripts to validate data
• Tuned the performance of complex Informatica mappings and database.
• Worked with cross functional teams to resolve the issues.
• Created slowly changing dimensions & Fact tables to meet the business requirements.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. 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.
• Performed data validations.
• Created SQL Server ODBC connections in Informatica workflow Manager.
• Worked extensively on Informatica partitioning when dealing with huge volumes of data and also partitioned the tables. Used Pass Through, Round Robin and Hash portioning.
• Involved in the defect analysis call for UAT environment along with users to understand the data and to make any modifications to code.
• Created complex queries, procedures, and functions in SQL Server.
• Performed Root cause analysis and resolved complex issues.
• Created SQL Queries to validate the data in both source and target databases.
• Prepared the recovery process in case of workflow failure due to database issues or network issues.
• Supported the applications in production on rotation basis and provided solutions for failed jobs.

Environment: Informatica 8.6/9.x, Informatica Power Exchange, Oracle 10g, Windows, UNIX.

Confidential, Minneapolis, MN

Informatica Developer

Responsibilities:

• Involved in all phases of the project life cycle including requirement gathering, analysis, design, coding, testing and implementation.
• Interpreted and comprehend business/data requirements from upstream processes
• Documented technical requirement specifications and detailed designs for ETL processes of moderate and high complexity.
• Created and documented source-to-target mappings and ETL specifications.
• Created complex Informatica mappings, mapplets and re-usable transformations and prepared various mappings to load the data into different stages like landing, staging and target tables.
• Designed and performed all activities related to migration of ETL components between environments during development (Eg. Dev to SIT, SIT to UAT and UAT to PROD repositories).
• Checked for missing data, negatives and consistency and completed field-by-field data verifications for source and target data consistency.
• Used various transformations including Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and Optimizing. 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.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.
• Handled Salesforce CRM database in ETL.
• Prepared the error handling document to maintain the error handling process and created test cases for the mappings developed then created the integration testing document.
• Involved in the defect analysis call for UAT environment along with users
• Developed workflows using Task Developer, Worklet Designer, and Workflow Designer in Workflow manager and monitored the results using Workflow Monitor.
• Informatica Mapping Design and Informatica Coding.
• Oracle Test Scripts Preparation.
• Handling Production data - Analysis on Client requirement and providing inputs/Suggestions on enhancement or performance which can improve business aspects.
• Handling New Change request and Defect Fixing.
• Working with Mainframe and UNIX Shell Scripts preparation.
• Handling User Acceptance Testing, System Integration Testing and Data Validations.

Environment: Informatica 8.5, Oracle 10g, Windows, Informatica Power Center, UNIX & Mainframe