PROFESSIONAL SUMMARY:

• Having around 10 years of Hands on experience in Data Warehouse/Data Mart/ Confidential application Architecture/Development/Enhancement/Support/Data Modeling using ETL tool Informatica Power Center, Informatica Power Exchange and Relational Database Technologies for Banking, Insurance, Financial Services (BFSI) and Manufacturing domain.
• Having 5+ years of experience in leading a team and team management, Project Planning, Monitoring and guiding the junior resources.
• Extensively worked with Informatica Power Center tools - Designer, Workflow Manager and Workflow Monitor.
• Experience in implementing Change Data Capture (CDC)/Replication with Informatica Power Exchange components - Power Exchange Listener, Power Exchange Logger and Power Exchange Navigator.
• Hands on experience in administration tasks such as taking Informatica repository backup, creating users and granting the privileges using Informatica Administrator.
• Hands on experience in upgrading Informatica from lower versions (9.6.1) to higher versions.(10.2.0)
• Experience in populating and maintaining Very Large enterprise level Data Warehouse of about 20+ Terabytes using various Informatica transformations, mappings, sessions and workflows.
• Experience in leading and coordinating with offshore team for activities such as plan or schedule, task accomplishment, issues and status.
• Experience in updating the data in data warehouse using Slowly Changing Dimension (SCD ) - Type 1, Type 2 and Type 3 approaches.
• Experience in working with Star schema and Snowflake schema Data Models.
• Experience in Data Modelling, Conceptual, Logical and Physical data model techniques.
• Knowledge on Normalization techniques for database designing.
• Experience with using databases such as Oracle SQL, PL/SQL, Sybase, SQL Server (T-SQL) and Teradata.
• Experience in responding appropriately to urgent technical support situations and procedures with quick and effective solutions to business problems.
• Experience in reviewing the current load processes, tune the existing jobs, providing estimates and handling ad-hoc requests.
• A demonstrated ability to own the technical deliverables and provide the timely status updates to the manager.
• Experience in understanding underlying data models and design to develop scripts using Structured Query Language ( SQL) .
• Experience with Agile Development Methodology
• Experience in Performance testing of various ETL processes/stored procedures and provide solution to the Performance improvement.
• Experience in working with Business Analysts, Data Modelers to understand requirements and to create sustainable ETL applications, technical design documents that capture source to target mapping, define transformation algorithms and document data quality rules.
• Experience with various DB product team in product selection testing for the client in terms of Performance, Reliability, Scalability and Manageability for Confidential projects.
• Experience in working with reporting tool Cognos Frame work Manager.
• Experience in gathering information from the system, analyzing program and time requirements, and preparing documentation to change existing programs.
• Experience in finding Root cause analysis and resolving static and postproduction issues.
• Good Operating Systems knowledge and associated commands (UNIX, MS Windows).
• Experience in Participate in client calls and preparing MoM, clarification list to seek clarification, list of requirements.
• Experience in creating all the project artifacts like Project Plan, Status report, Requirement docs, UAT and Handover documents.
• Interacting with users for source system study, requirement gathering, and implementation and testing of the system.
• Domain knowledge in BFSI/Manufacturing domain acquired during various implementations for Banking, Insurance and Financial Services clients.
• Continually seeks opportunities to increase customer satisfaction and deep client relationship.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center: Designer, Workflow Manager, Workflow Monitor

CDC/Replication Tools: Informatica Power Exchange: Listner,Logger and Navigator

Reporting Tools: Cognos

Database: Oracle, Sybase IQ,SQL Server, Sybase ASE

Languages: SQL,PL/SQL,T: SQL

Data Modelling methods: Conceptual, Logical, Physical and Dimensional Modelling

Data Base Management Tools: TOAD,SQL Developer, Oracle Raptor,SQL*PLUS

Operating Systems: Unix,IBM AIX,Windows

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead/ Architecture

Environment: InformaticaPowerCenter9.6.1, Informatica Power Exchange 9.6.1, Oracle 12c, SQL Server, SQL Developer, TOAD, IBM AIX

Responsibilities:

• Responsible to Lead, develop, maintain and enhance data warehouse and all related ETL solutions using Informatica Power Center and Database Programming Language.
• Leading and participating in new development requests, enhancements, and project initiatives.
• Involving in development of mappings, transformations, sessions and workflows using Designer, Workflow Manager and Workflow Monitor.
• Working directly with business users and functional analysts to understand the business requirements, identifying the appropriate data elements and modeling appropriate ETL solution to meet these requirements.
• Identifying Root Cause Analysis, RCA for the error processes and resolve all production issues and validating all the data after resolving the issues.
• Developing and automating ETL processes that involves error and reconciliation handling.
• Operational duties includes scheduling and migrating the ETL code to QA and Production environments.
• Performing unit testing and documenting the validation scripts.
• Involving in administrative tasks such as taking repository backup, open and manage support request tickets with Informatica Support team.
• Fully documenting all the change request, enhancements and integration of various systems into data warehouse.
• Involving in all phases of the project, notably as a developer and project lead dealing with customized business solutions.
• Administering Power Center environment to ensure security, auditability, Data Validation, Data Analysis, performance tuning and other required data integration related activities.
• Experience with SQL Server, Oracle in the areas of database administration, as well as schema design, database object development, management, optimization, and SQL programming.
• Understanding Data Sources, Using Data Modeling concepts to design and develop Dimensional Model for a Data Warehouse.
• Responsible to build SQL queries to perform ad-hoc data requests.

Confidential

Environment: InformaticaPowerCenter9.6.1, Informatica Power Exchange 9.6.1, Oracle 12c, SQL Server

Responsibilities:

• Creating Capture Registrations and Extraction Maps.
• Performing Row test for the extraction maps using Power Exchange Navigator.
• Stopping and restarting Power Exchange Listener and Logger services.
• Created mappings using Informatica Power Center to extract and load history data into Confidential .
• Understand and document existing Informatica PWX CDC jobs.
• Responsible to reconcile the Confidential data against the source systems and ensure the data integrity.

Confidential

Environment: InformaticaPowerCenter9.6.1, SQL Server, SSMS

Responsibilities:

• Understanding the requirements and providing the back-end development solutions using SQL Server database, in Confidential application development.
• Creating database objects such as tables and stored procedures.
• Transforming business and functional requirements into technical solutions using TSQL
• Preparing SQL queries to generate adhoc reports catering business users.
• Debugging the existing stored procedures to resolve the issues and communicating the solution to the peers.
• Creating Informatica jobs to schedule and execute the Confidential application jobs.
• Creating the Command tasks to call and execute the Confidential batch scripts.

Confidential

Environment: InformaticaPowerCenter9.6.1, SSMS, SSIS, SSRS

Responsibilities:

• Responsible for leading/delivery ETL Confidential work from SSIS to Informatica in a complete SDLC cycle i.e. analyze, design, build test and deploy.
• Understand the cube at each plant and listed all the Subjects/attributes/measures.
• Analysis of the SSIS Packages to listing out the all the existing dim’s and facts
• Involved in writing data conversions procedures in order to implement the business logic from SSIS to Informatica and make data available for report generation.
• Prepared ERD’s to show the relation between dimension and facts.
• Writing source queries required to build the Centralized cube.
• Developing Informatica Mappings and Workflows to build ETL solution.
• Creating Framework Manager Model in Cognos required to build the cube.

Confidential

ETL Lead

Environment: InformaticaPowerCenter9.6.1, SybaseIQ15, Oracle11g, UNIX

Responsibilities:

• As an ETL Consultant, is involving in designing, coding and implementing new business application sources to be extracted, transformed and loaded to the data warehouse using Informatica Power Center.
• Involved in developing Informatica Power Center mappings, sessions and workflows.
• Involved Extracting data from non-relational sources and relational databases and applying business logic to load the data into Data Warehouse.
• Involved in creating data transformation procedures using SQL, PL/SQL.
• Involved in creating Reconciliation scripts.
• As an ETL Consultant, had good listening skills to be able to understand business needs and interpret those needs into an efficient and effective application design.
• Develop load scripts using Sybase IQ utilities and SQL.
• Checking the data consistency in tables after the loading by reconciliation process.
• Preparing data model table structures,source to target mapping sheets based on the report format.
• Assist in establishing and following transformation standards in order to maintain data Integrity within the data warehouse.
• Involving in tuning the existing processes to improve the performance.
• Created and transported objects from Development /Test/Quality/Production .
• Performed system and UAT testing to check the BI functionality and fix if there any break down.
• Co-ordination with user for UAT, resolution of UAT issues & taking them to closure and Productionization
• Prepared various technical documents as per the requirement.
• Performance tuning of Informatica Power Center mappings & Sybase IQ databases.

Confidential

Environment: Informatica Power Center9.6.1, SybaseIQ15, UNIX

Responsibilities:

• Responsible to conduct POC around a set of use cases, which cover the key analytics capabilities, desired out of the new Vertica and Teradata platform.
• Responsible to prepare Product Evaluation Document in respect to Vertica and Teradata database.
• Responsible for identifying and prepare a master list of database objects to be migrated.
• Responsible for database clean up activity by identifying the objects to be dropped after seeking the approval from the respective stakeholders.
• Responsible to test the existing DB objects in Vertica and Teradata database for the performance.
• Involved in Post Confidential activities like count of tables to be matched with the old and new server, checking record count for the important tables.
• Involved in Pre Confidential Activities with the Sybase and Vertica and Teradata Product Team for Product Evaluation by performing some tests like Queries per hour, Mixed workload etc..
• Involved in Effort and Time estimation by identifying the % of changes need to be done at the code level in the newer version and time takes to modify the processes.
• Involved in Post Confidential activities like System Health Check .

Confidential

Environment: Informatica Power Center 9.6.1, Sybase IQ15, Oracle11g, UNIX

Responsibilities:

• Co-ordinating with users to gather requirements for various enhancements to the existing data warehouse.
• Managing the ETL design, construction, UAT & closure for new CRs
• Integrating new source systems into warehouse using by creating Informatica mappings .
• Involved in extracting incremental data using mapping parameters and variables .
• Managing and analysing & resolving data issues within the given TAT.
• Providing support to the Ops team in case of loading failures.
• Establishing processes like periodical automated recon , optimizing load etc.
• Maintaining healthy client relationship to in force credibility for new business.
• Involving in tuning the existing processes to improve the performance.

Confidential

ETL Developer/Lead

Environment: Informatica Power Center 9.5, Informatica Power ExchangeSybase IQ12, Oracle10g, DB Design

Responsibilities:

• As an ETL Consultant, was responsible to create an ETL process using Informatica Power Center and Sybase IQ database .
• Worked with various kinds of transformations in order to implement business logic.
• Created various stored procedures with SQL in Sybase IQ to transform, consolidate, and cleanse data.
• Feasibility analysis and converting business requirements into technical solution.
• Actively involved in the Source system stud y and understanding the Gaps in Source system to meet the customer requirements.
• As an ETL Consultant, was responsible for the overall management of the Data Mart .
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center .
• Created Informatica mappings, sessions and objects to integrate new sources to Data Mart .
• Worked on improvement in Jobs execution time.
• Handled post production issues in a timely manner.
• Performed ETL activities from multiple source systems to BI system. Ensured data quality and consistency.
• Single Point of Contact for the entire DataMart
• Involved in creating stored procedures, functions, packages and SQL scripts to facilitate the functionality for various modules/applications.
• Developed scripts for loading the data from flat files to database tables.
• Involved in creating Informatica Mappings, sessions and workflows .
• Involved in writing SQL queries using data warehouse data for representing the data as per the client requirement.
• Involved in fine-tuning of the queries and rewriting the queries to improve the performance.
• Created Informatica Power Center Workflows for scheduling the jobs.
• As an ETL Consultant, is involving in designing, coding and implementing business rules for the reports generation using Informatica Power Center and Database.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• As an ETL Consultant, Co-ordinating with users to gather requirements for various Reports.
• Responsible to load the data from the flat files into database using Sybase scripts, Informatica Power Center.
• Responsible to create data transformation stored procedures .