SUMMARY

• 5 years of IT Experience as Data warehouse Professional focusing on Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business Intelligence with excellent Functional and Technical skills.
• 5 Years of Experienceas Team Lead, playing roles like Offshore Lead, Onshore coordinator, Application SME, Informatica Center - of-Excellence Lead and had worked with other teams of various domains, platforms and technologies.
• 5 Years of ETL and data integration experience, Extensively worked in Extraction / Transformation / Loading of the legacy data to Data warehouse using Informatica Power Center 9.1
• Experience in analysis and troubleshooting of Data warehouse applications.
• Experience in integration of data sources like Oracle DB, non-relational sources like flat files into staging area.
• Experience in working with business analysts to identify study and understand requirements and translate into ETL Requirement Documents during the Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design documentation in the Design phase.
• Extensively worked on ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Providing technical support to internal account teams related to the data stored within the database.
• Designing custom reports via Tableau to align with requests from internal account teams and Clients.
• Working with large amounts of data Independently executing data analysis, utilizing appropriate tools and techniques (Interpreting results and presenting them to both internal and external clients)
• Working with relational databases, Examining data vigilantly and analyzing it to reach conclusions
• Writing SQL queries to create end-user reports /Developing SQL Queries and stored procedures in support of ongoing work and application support, Strong understanding of the Oracle Architecture and the design and implementation of slowly changing dimensions, Star Schema, and Snowflake Schema
• Designing and executing test scripts and test scenarios, Reconciling data between multiple data sources
• Experience in creating Reusable Transformations to facilitate rapid development efforts.
• Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets. Involved in development of Informatica Jobs with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy Transformer etc.
• Extensively worked on debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control).
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensive functional and technical exposure. Experience working on high-visibility projects.
• Familiar with Agile development methodologies.
• Excellent analytical/ communication skills and a good team player.

TECHNICAL SKILLS

ETL & DB Tools: Informatica Power center 9.1 & prior versions, TOAD for Oracle, SQL Developer Tortoise SVN, WinScp, Tableau

Operating Systems: Windows, 7/2000/XP/8.1

Programming Languages: SQL, PLSQL(Basic), UNIX (basic)

Database Systems: Oracle 11g, DB2, MS SQL Server

Scheduling & ERP Tool: Control M, Unix scheduler

Key skills: Data warehousing, Business intelligence, ETL, Business Analysis, Data Analysis

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Consultant

Responsibilities:

• Experience in integration of data sources like ORACLE and non-relational sources like flat files into staging area.
• Building and maintaining database objects including, but not limited to, SQL queries, automated jobs and database tables.
• Providing technical support to internal account teams related to the data stored within the database.
• Working with large amounts of data Independently executing data analysis, utilizing appropriate tools and techniques (Interpreting results and presenting them to both internal and external clients)
• Working with relational databases
• Examining data vigilantly and analyzing it to reach conclusions
• Writing SQL queries to create end-user reports /Developing SQL Queries and stored procedures in support of ongoing work and application support
• Designing and executing test scripts and test scenarios, Reconciling data between multiple data sources and systems
• Involved in requirement gathering, Design, testing, project coordination and migration.
• Project planning and scoping; facilitating meetings for project phases, deliverables, escalations and approval. Ensure adherence to SDLC and project plan.
• Maintained the proper communication between other teams and client.
• Created requirement specifications documents, user interface guides, and functional specification documents, ETL technical specifications document and test case.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator Update Strategy, Rank, Expression, lookups (connected and unconnected), Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Identified & created various reusable transformations, UDFs, mapplets, tasks & worklets.
• Responsible for studying the existing data warehouse and also working on migrating existing PL/SQL packages, stored procedures, triggers and functions to Informatica Power Center.
• Worked with different types of partition techniques like key range, pass through, Round Robin & Hash partitioning and implemented slowly changing dimension Type 1 and Type 2 in the logic.
• Fine-tuned ETL processes by considering mapping and session performance issues.
• Responsible for Creating workflows and Worklets. Created Session, Event, Command, Control, Decision and Email tasks in Workflow Manager.

Confidential

Sr. ETL Informatica Developer/ Team Lead

Responsibilities:

• Responsible for Design Consideration.
• Drive Business Value from IT Investments
• Find the optimal solution that delivers the greatest value (business benefit versus cost).
• Architecture strategy must reflect future business strategy
• Right first time
• Reduce Complexity:
• Reduce duplicated data, systems and vendors
• By moving the support process to IT and automate the existing processes to follow the enterprise standards
• Responsive to Change:
• Provide business users with the tools to support their own processes
• Fit For Purpose:
• Address total impact of a change on the Business
• Implement appropriate scalability and resilience
• Implement an appropriate level of Security
• Reduce Total Cost of Ownership:
• Drive towards open standards for interoperability
• Comply with IBM Standards Traceability Matrix
• Responding to all Business Queries.
• Standardizing application production support across all of business applications.
• Dealt with the Enhancement/Maintenance of the applications used by the banking clients.
• Institutionalizing the processes that are continuously improved and optimized by process action teams
• Preparing response strategies for quick resolution of breakdowns
• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems for OTC (Over the Counter) and GL (General Ledger)
• Created complex mapping using transformations like SQLT, Update strategy, Joiner, Lookups, Sequence generator, reusable sessions and mapplets.
• Created mapping, session, workflow parameters and variables. Responsible for extensive data validations on Data warehouse and Business object reports.
• Worked extensively on DERIVATIVE OTC, TRIAL BAL BHCR, APP CTGY, APP SUB CTGY, GDS GPR, ARDW GDR, CSLDT GL METRIC tables and mappings.
• Involved in writing the Test cases and based on Source to Target Mapping documents and Data Model diagrams.
• Defect management, bug tracking and bug Reporting using HP Quality Center.
• Tested and worked Control M scheduler with delivery schedule update and tracking.
• Performed Functional, Screen flow and Workflow test scripts as per the user requirements.
• Tested Informatica mappings and workflows and worked extensively with Informatica for data sourcing, data transformation and data loading.
• Performing System maintenance activities, maintain all application related activities etc.

Confidential

ETL Developer (Informatica)

Responsibilities:

• Responsible for End to End code changes, which included ETL Informatica, SQL, UNIX,
• Creation of a new EBU database and copying relevant existing tables for handling EBU data.
• Creation of new schedules to load EBU data into new EBU Database.
• Copying historical data in fact tables and load reference data in new EBU tables as part of Data migration activity done by Informatica jobs.
• Creation of new ETL jobs to load reference data from Source files done using Unix .
• Testing of ETL process
• Analyzed Issues and Risks associated.
• Coordination with BO developer so as to see that dashboard delivered to business users in the form of BO reports is correct.

Confidential

ETL Developer (Informatica)

Responsibilities:

• Responsible for Partitioning of the tables by month effectively, means that the history is automatically managed by Teradata avoiding the need to implement code to move data to history tables.
• Wrote Queries involving date ranges on the partition key column which will automatically be directed to only the relevant partitions of the table.
• Responsible for Implementing housekeeping routines, means that the amount of data in these tables can be limited to stop them growing indefinitely and redundant data that is no longer required can be removed.
• Designed ETL mappings in Informatica based on the requirements, implementing Data warehousing concepts.
• Developed complex mappings with transformations like lookup, router, aggregator, expression, update strategy, normalizer and joiner etc confirming to the business rules and documented.
• Responsible for Unit Testing wrote test cases, executed them and collected the artifacts.
• Point of contact for raising tickets with Informatica - Raised technical service tickets with Informatica when next level of assistance is required
• Code Deployment - Responsible for Code deployments and implementations.
• Created the implementation Plans needed post deployment for the Operations Team.
• Responsible for the Performance tuning of the overall commissions process which was highly appreciated by the client and is currently LIVE.
• Performance tuning/optimizations of all SQL queries based on the Explain plan.
• Involved in all stages of SDLC like, requirements gathering, freezing the design, development with onshore team, meetings with all stakeholders, communicating the regular status.