PROFESSIONAL SUMMARY

• Having good experience in Team management.
• Strong knowledge of ETL Tool - Informatica Powercenter 9.6, Informatica Cloud and Data Warehousing.
• Strong knowledge of Oracle PL/SQL programming.
• Strong knowledge of DB2 & SQL Server 2012.
• Good Knowledge in FS insurance domain.
• Experienced in the Analysis, Design, Development, Testing of Data warehouses and Data marts.
• Extensive Knowledge of Dimensional Data Modelling of Star Schema/Snowflake and Relational database concepts.
• Experienced in using various Transformations such as Expressions, Filters, Aggregators, Lookups, Routers, Joiner and Sequence Generator etc. to load consistent data in to Oracle, SQL Server databases.
• Worked on multiple Data warehousing projects with complete Software Development Life Cycle process starting with Requirements Analysis, Technical Analysis, Design, Build, Test, Deploy and Production support.
• Analyzed, Designed and Implemented different stages of Data Warehouse.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, My SQL, MS Access, MS Excel and Flat Files into staging area. Also experience in Optimizing Database querying, data manipulation using SQL and PL/SQL in Oracle, flat files and SQL Server databases
• Experience in Audit, Balance checks and Error handling techniques.
• Experience in data profiling and data cleansing.
• Implemented complex business rules in Informatica by creating re-usable transformations, and robust mappings/mapplets. Experience in loading data, troubleshooting, Debugging mappings, tuning mappings, etc.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Sorter, Normalizer, Sequence Generator, Router, Filter, Expression, Aggregator, Joiner and Update Strategy.
• Good working experience on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Involved in Test Planning and execution for various Test Phases: Unit Test, System and User Acceptance Testing.
• Experience in providing post deployment warranty support and Production Support.
• Experience in writing UNIX shell scripts.
• Self-motivated, able to set TEMPeffective priorities to achieve immediate and long-term goals and meet operational deadlines. Self-starter with good interpersonal and communication skills
• Green Field Training in Accenture in Informatica.
• Member of VAJRA (a voluntary group for guiding fresher) in Accenture.
• Earned Accenture Celebrates Excellence Award for Quarter 2, FY-2012 & Quarter 1, FY-2013 (dis is a very coveted award given every Quarter for Best Performance among the Individuals).

TECHNICAL SKILLS

Tools: Informatica Powercenter v9.6/9.5/9.1/v8.6, Informatica CloudControl M, TOAD

Database: Oracle 10g - PL/SQL, IBM DB2, SQL Server 2012

Languages: C /C++, HTML

Operating Systems: Windows 95/98/2000, Windows XP Professional, Unix

PROFESSIONAL EXPERIENCE

Confidential - Wisconsin

Sr. ETL Developer

Responsibilities

• Responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces (ETL) using Informatica.
• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer.
• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Extensively worked in the performance tuning of ETL mappings.
• Created reusable transformations.
• Creating data mappings to extract data from different source Databases, transform the data using ETL Informatica Transformations tan load to Oracle data warehouse. Defined Target Load Order Plan and Constraint based loading for loading data correctly into different Target Tables.
• Played major role in the Offshore / Onsite Model implementation.
• Code walkthrough with Developers & Client teams.
• Setting up of Unit / Integrated testing of interfaces (ETL) & documentation.
• Partly responsible for Informatica Administration, creating and administration Users and groups.
• Involving with developers and application team for Plan and coordinate database changes, installation of upgrades, patches and new versions, interacting with Design DBA and other infrastructure teams.
• Completely involved in the data analysis part by creating complex SQL queries and Procedures to verify the data as per business logic.
• Created TEMPeffective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Provide support to QA testing team to clarify changes and resolve testing issues or bugs.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Involved in preparing High-level design document and Source 2 Target document.
• Handling small projects and its release activity.
• Perform error handling and logging mechanism.
• Responsible for leading enhancement efforts, and coordinating with different team to support day-to-day activity.
• Responsible for maintaining Centralized Issue Logs and weekly status reports
• Supporting for go-live and release activities.

Confidential - California

ETL Onshore Team Lead

Responsibilities

• Involved in analysis of business requirements from the Data Management group for the newly identified external and internal source data for various business units.
• Coordinated with Business Users and the Offshore Development Team for solving design issues and requirements understanding for the coding phase.
• Extensively created complex mappings using transformations like Filter, aggregator, update strategy, lookup, router, stored procedure, sequence generator, and joiner using Informatica Power Center 9.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Perform error handling and logging mechanism.
• Involved in performance tuning (Applying Upgrades, Creating and running shell scripts).
• Troubleshooting production failures for Informatica.
• Responsible for leading enhancement efforts, and coordinating with different team to support day-to-day activity.
• Optimized various Mappings, Sessions, Sources and Target Databases.
• Responsible for analysing and maintaining ETL strategies and processes.
• Responsible for maintaining Centralized Issue Logs and weekly status reports
• Conducted the peer review and debugging for mappings developed and tested.
• Handled various deployment processes and communicate with team to deploy code into production.
• Involved in giving Knowledge Transition (KT) for the project
• Single point of contact for development and technical enhancements
• Completely involved in the data analysis part by creating complex SQL queries and Procedures to verify the data as per business logic.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Designed and Developed UNIX Shell scripts to enhance the functionality of ETL application.

Confidential

ETL Offshore Lead

Responsibilities

• Involved in Team management and responsible for assigning tasks to my team members.
• Involved in understanding and preparing Technical design and estimation documents.
• Recommended solutions to problems related to functional and technical design.
• Developed mappings by using various transformations as per standard format to implement business logic.
• Extensively involved in extraction of data from Oracle Database and Flat files.
• Extensively involved in the use of UNIX command for handling File.
• Conducted the peer review and debugging for mappings developed and tested.
• Handling two databases (NETEZZA & SQL Server) for taking care of data flow across five layers.
• Involved in giving Knowledge Transition (KT) for the project.
• Completely involved in the data analysis part by creating complex SQL queries and Procedures to verify the data as per business logic.
• Responsible for analysing and maintaining ETL strategies and processes.
• Communication with the client for weekly status report.
• Perform error handling and logging mechanism.
• Involved in performance tuning.
• Supported UAT and SIT environments.
• Involved in bug fixing and deployments.
• Single point of contact for development and technical enhancements.
• Root Cause Analysis of the Production Defects and fixes the same.
• Supporting for go-live and release activities.
• Single POC for all ETL development related issues.

Confidential

ETL Developer

Responsibilities

• Recommended solutions to problems related to functional and technical design.
• Developed mappings by using various transformations as per standard format to implement business logic.
• Involved in understanding and preparing Technical design and estimation documents
• Conducted the peer review and debugging for mappings developed and tested.
• Completely involved in the data analysis part by creating complex SQL queries and Procedures to verify the data as perbusiness logic.
• Responsible for analysing and maintaining ETL strategies and processes.
• Perform error handling and logging mechanism.
• Involved in performance tuning.
• Supported UAT and SIT environments.
• Involved in bug fixing and deployments.
• Single point of contact for development and technical enhancements.
• Root Cause Analysis of the Production Defects and fixes the same.
• Supporting for go-live and release activities.

Confidential

ETL Maintenance

Responsibilities

• Perform error handling and logging mechanism.
• Extensively involved in extraction of data from oracle, flat files.
• Involved in performance tuning (Applying Upgrades, Creating and running shell scripts).
• Troubleshooting production failures for both Informatica and Oracle applications.
• Optimized various Mappings, Sessions, Sources and Target Databases.
• Work on scheduling tool ($ Universe) in scheduling and maintenance of jobs.
• Communicate with various teams in order to ensure smooth running of jobs.
• Responsible for analyzing and maintaining ETL strategies and processes.
• Communication with the client for weekly status report and responsible for writing procedures in SQL server.
• Conducted the peer review and debugging for mappings developed and tested.
• Handled various deployment processes and communicate with team to deploy code into production.
• Developed and upgraded shell scripts in order to automate processes and reduce manual work.
• Fixed various bugs and errors for completion of job in time and meet the SLA / ETA.
• Ensured proper maintenance and operations of jobs in order to run smooth applications.
• Root cause and impact analysis.
• Communicate with various teams in order to ensure smooth running of jobs and avoid miss SLA’s timing.

Confidential

ETL Maintenance

Responsibilities

• Ensured proper maintenance and operations of jobs in order to run smooth applications.
• Preparing weekly status report.
• Preparation of test cases and reviews the same.
• Involved in preparing the production run book.
• Involved in preparing the issue tracker sheet.