SUMMARY

• Total 6.5 years of IT Experience in ETL data warehousing.
• 5+ year of experience in Informatica PowerCenter.
• 6 + year of experience & Certified Oracle SQL/ PLSQL Developer.
• I have worked on various stages of implementation process from requirement gathering, analysis, design, development & maintenance of various software applications mainly in data warehousing.
• Strong experience with Informatica client tools - Source Analyzer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager and Informatica Server Manager, Workflow Manage/Monitor.
• Good at Data Warehouse techniques -Dimensional data modeling, Star Schema and Snowflake Schema.
• Good Understanding on OLAP & OLTP.
• Proficient in developing solutions for Slowly Changing Dimensions, Incremental Loading, Incremental Aggregation, Constraint-Based Loading
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Expertise in implementing complex business rules by creating re-usable transformations, and Mappings/Mapplets.
• Experienced with UNIX Operating System, shell scripting to perform job scheduling.
• Good in Using Debugger wizard to find the bottlenecks in the mapping.
• Extensively worked on data extraction, transformation & loading with RDBMS & flat file.
• Experience with full Software Development Lifecycle (SDLC).
• Worked on Agile and Waterfall Methodology.
• Good knowledge on Incident Management, Problem Management and Change Management.
• Expertise in domain like Retail, Telecommunication.

TECHNICAL SKILLS

ETL Tool: Informatica Power Centre 9.1/8.6

Software Tool: Remedy, Manugistics, Toad, SSH Client, Selectica Suites of products, Model Builder, Selectica Management Centre, Preferred carrier.

Operating Systems: UNIX, Windows 9x/2000/XP/NT

Programming Languages: OOPs based language in Model Builder for Selectica

Scripting Languages: Unix Shell Scripting, Basic VB

Scheduling Tool: Control M

Database: Oracle 9i SQL, PL/SQL, MS-Access

Configuration Management Tool: Clear Case

Scripting & Markup languages: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Senior ETL Developer

Responsibilities:

• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load the data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Responsible for developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality of modules.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Joiner and Rank.
• Implemented Slowly Changing Dimensions (Type 1, Type 2).
• Responsible for testing ETL jobs before deployment to test and test to production migration.
• Document and deployment of new and enhanced ETL process into production environment.
• Responsible for Scheduling the ETL jobs in Control-M
• Involve in troubleshooting for long running or held jobs.
• Root cause analysis for production issues.
• Define standards & implement Informatica best practices to manage & support the ETL environment
• Responsibilities also included requirement analysis, preparation of high level and low level design document, impact analysis, estimation, status tracking & reporting.
• Leading effectively team of 6 ETL and PLSQL developers, guiding them during design phase, build and testing.
• Peer code review
• Cooperated with project managers, particularly in managing deliverables.
• Responsible for sharing system status report with client.

Environment: Informatica 9.1, Oracle 10g, PLSQL, Control-M Scheduler & Data Warehouse.

Confidential, Omaha, Nebraska

Informatica Developer

Responsibilities:

• Responsible for design and develop Informatica mappings, transformation logic & workflow.
• Used various active and passive transformations such as Aggregator, Expression, Sorter, Router, Joiner, connected/unconnected Lookup, and Update Strategy transformations for data control, cleansing, and data movement.
• Designed and developed Mapplets for faster development, standardization and reusability purposes
• Experienced in various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database, and Shared Cache
• Responsible for developing PL/SQL Procedures, Functions and Packages and SQL scripts into the database.
• Provided the critical production support for Informatica ETL system.
• Develop Unix Shell scripts for supporting and automating the ETL process.
• Troubleshoot Informatica, PLSQL & Unix Prog and provide solution.
• Conducted detailed analysis of issues reported by end user
• Involve in troubleshooting for long running jobs or held jobs
• Worked with the QA team to resolve and fix the defects found
• Responsible for writing Technical and functional test case.
• Responsibilities also included requirements analysis, preparation of design document, impact analysis and estimations.
• I also undertake complex analysis of systems, including diagnosis and correction of faults and recognize process improvement opportunities.
• Lead a team of 4 ETL developers and guided them through development processes.

Environment: Informatica 8.6, Oracle 9i, PLSQL, Manugistic(Decision Support System), Control-M Scheduler & Data Warehouse.

Confidential, San Jose, California

ETL developer

Responsibilities:

• Involved in requirement gathering and conversion of business requirements into technical specifications and also worked with the business analysts to implement the ETL process.
• Developed and modified various types of transformation like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Aggregation, Rank, Router, Sorter
• Modified various active & passive transformations within Informatica Like expression, lookup, filter, rank, aggregate, update strategy, joiner etc
• Developed many slowly changing dimension type 1 and type 2 transformations
• Transformations involving Incremental Loading using Mapping Variables and Mapping Parameters
• Worked on Performance Tuning at Database Level, Mapping Level, Session Level, Source level, and Target Level
• Responsible for error handling using debugger and row error logging
• Extensively worked in Oracle SQL, PL/SQL, created DDL scripts, created database objects like Tables, Views, Indexes, Synonyms and Sequences
• Worked extensively on exception handling to trouble-shoot PL/SQL code
• Involved in Unit and integration testing for the code.
• Deployment of files to application server by using UNIX box and rigorously test the application
• Worked in Incident management for resolving hundreds of production issues reported in Remedy (Alliance tool) by client or end user.
• Involved in Configuration Management team for development pushes and production pushes of codes, with using WinCVS for maintaining code bases.
• Involved in client meeting and calls.
• Meeting with other related systems for better understanding of overall business.
• Responsible for sending system status report to the client everyday/weekly/monthly.

Environment: Informatica 8.6,Oracle 9i, PLSQL, UNIX, WINCVS, TOAD.

Confidential

PL/SQL developer

Responsibilities:

• Involved in technical development for Selectica application which included PL/SQL development like procedures, triggers, view, indexes.
• Involved in Perform system testing/business validation/1st level of user acceptance testing/validating test coverage/validating system results
• Involved in various stages of the implementation process from requirement gathering to production support and processing solutions.
• Involved in Incident management for production issue reported by end user
• Involved in change Management for new enhancements.
• Involved in Configuration Management team in production pushes of codes using Clear Case for maintaining code bases

Environment: Oracle 9i (PLSQL) & UNIX