PROFESSIONAL SUMMARY:

• A highly motivated and results oriented ETL Tech Lead with technical and analytical expertise in Data Integration and Data Warehousing implementations.
• Strong knowledge of dimensional modeling, DWH/system architecture, ETL/ELT framework, design, best practices and troubleshooting.
• Extensive experience in maintaining data mapping documents, business matrix and other data design artifacts that define technical data specifications and transformation rules
• Release management, code deployment across various environment and support/maintenance
• Ownership of overall deliverables, handle work distribution, time management, prioritizing work and assist in all the supporting tasks to ensure completion of project on time.
• Worked in Waterfall and familiar with Agile methodologies
• Excellent verbal and written communication with ability to effectively put forth ideas at functional/technical level
• Regular Contributor of ideas and process improvement suggestions by always looking for creative and innovative solutions/new features.
• A proven hunger to learn new technologies and translate them into working solution by performing proof of concepts
• 8+ years of strong demonstrated experience with InformaticaPower Center with excellent grip on
• Informatica client tools (designer, workflow monitor/manager, repository manager)
• Creation of mappings, mapplets, transformations, workflows, worklets, sessions, tasks, etc.
• Ability to handle highly complex mappings, debugging and efficient code migration
• ETL of data to/from heterogeneous technology platforms like XML Files, major RDBMS platforms, flat files (with header & trailer), third party loader and SAP
• Bidirectional SAP data migration - Power Exchange for SAP (IDoc, RFC/BAPI, OHS, flat files)
• Data integration with Mainframes
• Dynamic parameterization, partitioning, performance tuning of Informatica objects, configuring concurrent workflows, defining target load order, constraint based loading, third part loading, etc.
• Informatica Admin
• Performed Informatica Admin role with activities of repository backup & restore, code movement, user access handling, configuration changes, install & upgrade versions, server migration, Disaster recovery (DR model) setup & testing, failover process, get help from Informatica and work on solution and support for various patch updates on AIX/LINUX servers
• Strong understanding of Bi/ Data warehousing architecture, concepts, and ETL strategies
• Change data capture, audit tables, reject processing & data reconciliation, etc.
• Data cleansing, build data, data normalization & de-normalization
• Loading slowly changing dimensions (type I, II, III), constraint based loading, target load order, etc.
• Dimensional modeling (star/snowflake schema) & DW BUS architecture, different types of dimensions, fact less fact tables, maintaining hierarchical attributes etc.
• Pre-aggregation of fact tables
• Deep understanding and hands on experience in Oracle with experience in
• Writing medium to complex queries, sub queries, joins, built-in-functions
• Working with tables, views, synonyms, indexes, constraints, data types
• Analytical functions, hierarchical queries, aggregate queries
• Knowledge of UNIX Shell Scripting (bash/ksh) having experience on
• Directory structure, permissions, NFS mounts
• Major commands, pmcmd, variables, exit status, variable evaluation, processing command line arguments and environment variables
• File operation, text editors, control structures, shell script functions, i/o redirection, logging mechanism
• Process control and monitoring, foreground & background processes
• FTP, NDM, DB connectivity & spooling data

TECHNICAL SKILLS:

• Informatica Power Center v 8.1/8.6/9/9.6.1
• WebIntelgence
• SQL Developer, TOADIBM Data Studio
• WinSCP (FTP), Notepad++, Textpad
• Putty,Tufin
• Oracle 10g/11g
• DB2 10.5
• SQL Server 2008
• Teradata
• SQL & PL/SQL Programming
• UNIX Shell Scripting (bash/ksh)
• Core Java
• C & C++
• Dimensional Data Modeling
• ER Modeling
• Capital Markets (Bank Reconciliation)
• Media - Intellectual Property Management
• G lob alBran chFound at ion s - Flexcube
• UNIX (IBM AIX/Linux/UNIX)
• Win XP/7/8/10
• Waterfall
• Agile

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead / Senior Developer

Environment: Informatica 9.6.1, SAP Business Objects BI Platform 4.3, AIX and LINUX servers, Db2 10.5

Responsibilities:

• Involved complete Software Development Life Cycle (SDLC), involved in various phases - Requirements, Analysis/Design, Development, Testing, Production Deployment and Maintenance
• Performed Informatica Admin role with activities of repository backup & restore, code movement, user access handling, configuration changes, install & upgrade versions, server migration, Disaster recovery (DR model) setup & testing, failover process, get help from Informatica and work on solution and support for various patch updates on AIX/LINUX servers
• Manage ETL defects, enhancements, and new functionality requests to meet changes in the business needs And adhere to audit remediation and compliance
• Involved to produce High risk chargeback reports
• Coordination of system/Integration/UAT testing with other teams involved in project and review of test strategy
• Transform & Load Specifications, data load to STAR model, slowly changing dimensions.
• Maintain and enhance existing data extraction, cleansing, transformation, and loading processes to improve more efficiency
• Assisted Business object admin activates like bounce application, LDAP setup, take Universe backup and handle user privileges
• Document all processes and mappings related to ETL work and follow development best practices as adopted by the Data Warehouse team
• Interact with business on a regular basis and understand the end-end the business requirements
• Preparation of HLD and DLD documents on for all projects and presenting to Project Managers
• Work closely with Vendor, software developers, business analysts, product managers and release management before fixing the application related issues
• Own Informatica application and provided support for application releases activities and Involved in all phases of application and database developments
• Created metrics based status reports on timely manner to meet the project deliverables, involved in portfolio meetings, client steering committee meetings and project health check reviews. Status meetings are defined and captured that will position the team to identify and drive continuous improvements.
• Mitigate risk by identifying, escalating, and resolving issues across multiple delivery groups and/or projects
• Communication and Coordination with multiple functional areas, groups and vendors for the successful execution and implementation of applications
• End-to-End Project execution and delivery

Confidential

Senior Developer

Environment: Platform: Informatica 9.1, Power Exchange for SAP, SAP BW 7.3

Databases: Teradata

Languages & Utilities: Unix Shell Script,

OS: Windows 7

Responsibilities:

• Involved in Requirements gathering, Analysis and created High-level design, low level design documents.
• Involved in understanding the logical data model, Physical data model and created the DB scripts.
• Design & Implement sequence of security steps that validates the source system data and the total number of records
• Design and Implement Change Data Capture strategies for Historical & Incremental loads.
• Extensively used the mapping parameters, mapping variables and workflow variable and passed initial values through frame work.
• Extract data from source systems and load into Staging and ultimately into Data Marts.
• Integration and User Acceptance Testing
• Reconciliation/verification data load and error reporting for bad data
• Migrated Informatica objects using import and export method .
• Prepared migrations documents.
• Performance Tuning of ETL routines and Databases
• Experience coordinating the team and resolving the issues of the team in technically as well as functionally.

Confidential

Informatica Developer

Environment: Platform: Informatica 9.1,

Databases: Oracle 11g, SQL Server

Tools: TOAD, Putty,

Languages & Utilities: Unix Shell Script

OS: UNIX (Sun Solaris), Windows 7

Responsibilities:

• Designing of the ETL Routines based on the Functional Specifications
• Design & Implement sequence of security steps that validates the source system data and the total number of records
• Design and Implement Change Data Capture strategies for Historical & Incremental loads.
• Database objects development like functions, procedures
• Development of Mappings, Workflows and related Informatica Objects
• To extract data from source systems and load into Staging and ultimately into Data Warehouse.
• Reconciliation/verification data load and error reporting for bad data
• Job automation and scheduling
• Performance Tuning of ETL routines and Databases
• UNIX: Shell Scripting for Data transformation and Informatica Scheduling
• SDLC: Code Debugging, Unit Testing, Code Migration and Checklist Maintenance Execution of Unit, System
• Integration and User Acceptance Testing
• Interacting with the reporting team with and facilitate report development process.

Confidential

Informatica Developer

Environment: Platform: Informatica 8.6

Databases: Oracle 10g, MSSQL Server

Tools: TOAD for Oracle, Toad for SQL Server, Putty

Languages & Utilities: Unix Shell Script

OS: UNIX (Sun Solaris), Windows XP/7

Responsibilities:

• Designing of the ETL Routines based on the Functional Specifications
• Design & Implement sequence of security steps that validates the source system data and the total number of records
• Design and Implement Change Data Capture strategies for Historical & Incremental loads.
• Database objects development like functions, procedures
• Development of Mappings, Workflows and related Informatica Objects
• To extract data from source systems and load into Staging and ultimately into Data Warehouse.
• Reconciliation/verification data load and error reporting for bad data
• Job automation and scheduling
• Performance Tuning of ETL routines and Databases
• UNIX: Shell Scripting for Data transformation and Informatica Scheduling
• SDLC: Code Debugging, Unit Testing, Code Migration and Checklist Maintenance Execution of Unit, System
• Integration and User Acceptance Testing
• Interacting with the reporting team with and facilitate report development process.