SUMMARY:

• Over 10 years of IT experience as specialist in performing Analysis Design Development Testing Deployment and Maintenance for various software applications.
• Responsibilities include working with multiple clients as a ETL Lead, Onsite - coordinator, Tech Lead for various projects, with the ability to lead diversified teams and interests.
• Good understanding of Data warehousing and ETL concepts.
• Extensive experience in ETL design development and maintenance using RDBMS database systems and Informatica Power Center / Cloud on UNIX and Windows platforms.
• Expertise in Data Warehousing, Data Migration and Integration using Business Intelligence BI tools such as Informatica PowerCenter, Power Exchange CDC, B2B Data Transformation, Data Quality, SSIS etc.
• Proficient in Informatica administration work including installing and configuring Informatica and repositories servers on Windows and UNIX platforms, backup repositories, enabling security and user account maintenance.
• Experienced in Installing, Configuring, Upgrading and Administering Complete Informatica PC, IDQ, PIM and B2B Components.
• Expertise in creating Deployment Groups and Applying Labels. Managing Informatica servers and Informatica services.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Extensively worked in SAP Integration/Migration Project using ETL (Informatica); Built Interfaces (Inbound/Outbound) or Data migration using BCI, RFC and IDOC through Informatica to load data into the system (Oracle, SQL Server).
• Generated and Installed ABAP Program / SAP R3 Code Using Informatica 9.6.1.
• Experienced with Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling and Data Governance.
• Extensive knowledge of RDBMS like MSSQL, Oracle 9i, 11g, Teradata.
• Experience in UNIX shell scripting, automation of ETL processes using Cron tab.
• Experience is performing data migration from legacy system to Salesforce.COM.
• Good working knowledge in querying Salesforce.com database using SOQL & SOSL queries using Force.com Explorer & Workbench.
• Experience working in production support environment.
• Having Greater Flexibility in working with any Data Warehousing Tool.

TECHNICAL SKILLS:

Operating Systems: UNIX (Sun-Solaris, HP-UX), AIX, Windows Platforms

Tools: Informatica PowerCenter 10x/9x/8x/7x, Informatica Cloud /Power Exchange 9.5.1, Informatica Data Quality Analyst/Developer 10.1, Salesforce.com, SAP NetWeaver 730, SSIS, IBM iSeries, Control-M, Autosys, Tidal, Cognos, SQL Developer

Languages: SQL, PL/SQL / Shell Scripting

Databases: Oracle 9i/10g/11g/12c, Teradata V2R6.2, MS SQL Server 2012/08/05, Greenplum DB

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, Memphis

Environment: Informatica 10.1, 9.6.1, IDQ 10.1, Oracle 12c Enterprises Edition, SAP, UNIX Shell Scripting, ServiceNow

Responsibilities:

• Led a team of Developers, which includes an outsourced development team, on the day-to-day efforts across multiple projects and provided architectural road map, direction and work packets for ETL needs.
• Performed the roles of Senior ETL Informatica and Data Quality (IDQ) developer and responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy.
• As a developer; Worked with Functional consultant and SAP developers to design the function modules for extract the data from SAP R3 systems.
• Read data from SAP BCI and full extract and loaded data to SAP targets through IDOC prepare transformation.
• Extensively used Experience in working with SAP Developers to create Function modules or transparent (Z Table in SAP) tables for Migration /Loading of Data from SAP R3, SAP BW to Oracle and then loading to external targets like SQL Server and Flat files.
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query.
• Developed ABAP Programs (reports) to upload the data/download the data. Performed unit, integration and system level performance testing.
• Extensively worked on Informatica pushdown optimization. Also, worked on mapping / session / table level optimization etc.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Monitor Informatica platforms Performance across all the environments and taking necessary actions in case of File system/permission/space issues.
• UNIX shell scripting, for various functions such as maintenance, backup, and server health checks.
• Perform Disaster Recovery of ETL systems.
• Provided 24/7 production support to all the ETL Informatica applications and Projects.
• As an admin; provided operational support services relating to informatica components, installation, applications and infrastructure.
• Created and managed global and local repositories. Worked on creating Informatica repositories, backup repositories, enabling security.
• Configure and optimize all aspects of Informatica platform Server suit, including policies, control standards, procedures and dashboards.
• Administer projects, roles, user, and privileges across all the environments.
• Creating and managing connections and providing the required access levels Using Repository Manager.
• Regular Monitoring and troubleshooting the Informatica domain.
• Regular repository backup / recovery activities as part of disaster recovery plan.
• Environment setup by Installation and configuration of Informatica suite (IPC, IDE, IDQ & MDM).
• Created and configured the Reporting and Dashboards service for Data Quality application.

Confidential,Memphis

Environment: Informatica 9.6.0/ Power Exchange, Greenplum, SQL Server 2012, JDE AS400, SSIS

Responsibilities:

• Prototyped Dimension Model & ETL process by matching the business requirements and core technical requirements from reporting team.
• Requirements gathering and discussion with the Clients to understand the Business Logic.
• Working with the Business Analysts and the QA team for validation and verification of the development.
• Implementation experience of CDC using stored procedures, triggers and using Informatica power exchange.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Handling System analysis, Estimations, design and development for enhancements and change requests.
• Review of SIT plan, Support to change requests implementation
• Involved in creating and management of global and local repositories and assigning permissions using Repository Manager. Also migrated repositories between development, testing and production systems.
• Provided administrative functions like creating repositories, backing up repositories, setting up users, assigning permissions and setting up folders in Repository manager.
• Created and Maintained users and User profiles.
• Hands on experience in creating Deployment Groups and Applying Labels.
• Involved in Installation & configuration of Informatica PowerCenter 9.6 (Client, Repository Service & Integration Service) on windows platform.
• Preparation of QA migration and PROD migration Documents after development and testing in development environment and executed Quality Assurance testing.

Confidential

Environment: Data Warehousing, Informatica 9.6/ Cloud, SQL Server 2012, Salesforce.COM, UNIX, Cygwin2.8

Responsibilities:

• Involved in Design Specifications and technical Sessions.
• Developed Detail Design and Mapping Document to present to client for the Informatica cloud process for the Salesforce objects.
• Created and edited custom objects and custom fields in Salesforce and checked the field level Securities.
• Enabled Bulk data load for loading into the Sales force and checked the jobs in sales force Administration setup
• Extracted data from Salesforce.com (SFDC), SQL Server DB and Data files using Informatica cloud tasks.
• Wrote UNIX shell scripts for file transfer/archiving.
• Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
• Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Analyzed requirements from the users and created, reviewed the specifications for the ETL.
• Used PMCMD, and UNIX shell scripts for workflow automation.

Confidential

Environment: Data Warehousing, Informatica 9.1/ Cloud, Oracle 11g, Sql Server 2008, Salesforce.COM

Responsibilities:

• Involved in Design Specifications and technical Sessions.
• Understood the Business point of view to implement coding using Informatica power center designer.
• Understanding High Level ETL Requirement specifications to develop LLD for type-I, SCD Type-II and Type III mappings and done rigorous testing for various test cases.
• Develop and perform tests on all ETL codes for system data and analyze all data and design all data mapping techniques for all data models in systems.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Developed Informatica cloud task to load data from various sources into Salesforce.

Confidential

Environment: Data Warehousing, Informatica 8.6.1, Oracle 9i, 10g, Unix, Tidal

Responsibilities:

• Involved in Design Specifications and technical Sessions.
• Worked Extensively on Informatica tools -Designer Workflow monitor and Workflow Manager.
• Creation of ETL components to propagate the Monthly data feeds.
• Evaluation and construction of methods to commandeer the effective run times of the ETL maps followed by the performance tuning.
• Exhaustive system study to gauge the developed system most efficiently and synergize the two flows to work together to summarize the report schedules.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing
• Have contributed in UNIX shell scripting and Oracle PL/SQL procedures.

Confidential

Environment: Data Warehousing, Informatica 8.6.1, Teradata

Responsibilities:

• Involved in Design Specifications and technical Sessions.
• Understood the Business point of view to implement coding using Informatica power center designer.
• Working with CR Implementation.
• Interfaces are built and automated with Informatica ETL tool, Unix Shell Scripting.
• Experienced using Informatica integrated with shell programming.
• Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks
• Involved in writing UNIX shell scripts to run and schedule batch jobs.

Confidential

Environment: Data Warehousing, Informatica 8.6.1, Oracle 9 i, 10g

Responsibilities:

• Requirements gathering and discussion with the Clients to understand the Business Logic
• Preparation of the following various technical and functional documents (applicable depending on the request types) Requirement Specification document, High Level Analysis and Approach document, High Level Design Document, Detailed Design Document and implementation plans.

Confidential

Environment: Data Warehousing, Informatica 8.6.1, Oracle 9 i, 10g, Unix

Responsibilities:

• I have worked in Data warehouse support and maintain project with a client from life science. In my entire work duration I have solving data and ETL issues along with functional and technical analysis development.
• Review Business requirements and Change request.
• Review of SIT plan, Support to change requests implementation
• Extracting data from Different sources and loading into the staging table.
• I extensively worked with source analyzer, target designer, transformation developer and mapping and mapplet designer
• Performed unit testing at various levels of the ETL.
• Involved in Creating sessions and workflows, and scheduling to load the data into the targets.
• Involved in coding UNIX shell scripting to execute pre/post session commands.

Confidential, Crawley

Environment: Data Warehousing, Informatica 7.1.1, Oracle 9 i, 10g

Responsibilities:

• Monitoring, troubleshooting & re/starting the application server, Informatica server for different clients in different instances like PRD, DEV & UAT.
• Uploading the client’s report file in to the server to the specified instances.
• Creating Transformations, Mapping designer, Mapplet designer, sessions, workflow manager in Informatica to carry out ETL.
• Creating the Technical design specifications based on Client functional specs.
• Database tuning and performance monitoring
• Studied Reject Files and Session Log files to correct errors in mappings and sessions.
• Used Debugger making use of Breakpoints to monitor data movement and troubleshoot the mappings.
• Supervising the technical team to restore the database in-case of system failure.

Confidential

Environment: Data Warehousing, Informatica 7.1.1 / 6.2, Oracle 9 i

Responsibilities:

• Responsible for monitoring the Production status, and ensure the ETL process works as expected; handle user communication around production issues.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Performed tasks of validating and executing the sessions in Informatica.
• Handled System analysis, Estimations, design and development for enhancements and change requests.

Confidential

Environment: Oracle 8i/9i, PL/SQL, SQL * PLUS, TOAD.

Responsibilities:

• Responsible for Creating New Tables and Alter the existing table as per the requirement.
• Wrote SQL queries to extract and validate data from database.
• Analysis and estimation of changes/new requirements.
• Database support.
• Developed routines using SQL Scripts.