SUMMARY

• Around 16 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Insurance, Financials, Pharmaceuticals, Parcel, Hotel and Manufacturing Sectors.
• Around 11 years of experience in Business Intelligence and Data Warehousing solutions with expertise on ETL life cycle development including Analysis, Design, Profiling, Build Data Quality Rules & ETL, Testing, Implementation, Administration and Production support.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post - implementation review.
• Extensive Experience in data analysis of Source Systems and Warehouse systems.
• Strong knowledge in Dimensional Data Modeling Techniques, E-R modeling, Multi-Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), Ralph Kimball Methodology, Normalization forms and handling Slowly Changing Dimensions.
• Pretty good experience in Informatica Power Center (versions 10.2.0/10.1.1/9.1/8.6/8.1.1/ 7.1 ) including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Experience in Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, VSAM, Mainframe Files, DB2, Oracle, SQL Server and Teradata.
• Hands on experience in understanding Legacy Systems like CRM, Oracle Applications, SAP Systems, Salesforce.com and XML files.
• Informatica Data Quality (IDQ 9.1) is the tool used for data quality measurement.
• Experience in ETL performance tuning of sources, transformations, targets, mappings, worklets, workflows and sessions.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Involved in migration/conversion of ETL processes from development to production environment.
• Expertise in implementing in Incremental data loading from relational sources using Mapping Parameters and Mapping Variables.
• Expert Knowledge in ETL and SQL query performance tuning to improve the session run times.
• Worked extensively with
• ETL-Informatica 10.2.0/10.1.1/9.1.0/8.1.6/7.1.2 ,AWS Glue
• Informatica Data Quality 9.1 (IDQ), MDM
• Amazon Redshift, AWS S3, DB2, Oracle Databases 8i/9i/10g & 11g SQL, PL/SQL
• Developer 6i & 10g (Mainly Forms & Reports)
• Oracle BI Publisher & Tableau
• UNIX Shell Scripts to automate load process
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Triggers, Stored Procedures, Functions, and Packages etc.
• Good exposure to SQL, PL/SQL Programming and UNIX.
• Expertise in developing and working on Pre-Session, Post-Session, UNIX shell scripts and automates the process by Autosys, Control-M, DAC and Cron Job Schedulers.
• Strong knowledge in using SQL*Loader, Materialized views, Export and Import Utilities.
• Knowledge in the Data Base Administration such as designing data-model, implementing relationships, handling security issues, importing, exporting and managing table-spaces.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and excellent presentation skills.
• Extensive experience in Data migration projects along with validating the Data by using scripts/Tools to perform Data Cleansing, Profiling, Metadata, and Partitioning.
• Involved in providing Extensive production support to various Applications along with server Maintenance projects 24x7.

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Informatica Onsite Lead/Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers
• Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level
• Solid Expertise in using both Connected and Un connected Lookup transformations
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache
• Developed Re usable Transformations, and Re- Usable Mapplets
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Session Logs, and Workflow Logs for Error handling and Troubleshooting in all environment
• Responsible for Unit Testing and Integration testing of mappings and workflows.

Environment: Informatica Power Center 10.2, Windows 7, AWS Redshift, AWS S3, AWS Cloud, Oracle Database 10g/11g, MF-VSAM, DB2, SQL, PL/SQL, SQL*Plus, PL/SQL Developer.

Confidential

ETL Technical Onsite Lead/Lead Developer

Responsibilities:

• Analyzed the requirements before starting the development process and providing estimation based on the complexity.
• Worked on High level and Low level Design, Data Flow diagram, Source to Target mapping documents.
• Worked as an Onsite lead and explained to ETL developers on the mapping and business rules.
• Extensively used ETL to load data from EBS R12 Financial applications to the Financial Data Warehouse.
• EBS is the source system, as we don’t have direct access to this system, we are provided with a copy of data from EBS in the form of Materialized views. These views are refreshed at a regular interval to get the delta data.
• General Ledger data (Balances, Transactions, Headers and Batches) are being moved from their source systems to FDW using Informatica ETLs designed as per the specifications mentioned in the requirement document.
• Due to the large volume of data, the table is partitioned into smaller chunks in the form of table partitions by specific columns and is sub partitioned on periods.
• Created complex ETL mappings that are designed to read the source from different materialized views that has data for Balances, Transactions, Headers and Batches. Each of these ETLs read the source data, look up on dimensions to get the dimension keys that need to be populated in the fact Table.
• Created Oracle Procedures to load the Dimensions from EBS like Ledger, Period and Currency Exchange which needs to be loaded before loading the Facts.
• Created materialized views & normal views where business requirements needed.
• Tuned the SQL queries and complex procedures to improve performance. Used EXPLAIN PLAN and Toad/SQL Navigator for tuning the queries.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level.
• Automated Scheduling of jobs through Informatica scheduler.
• Checking naming convention, Coding standards are followed or not in all the mappings.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica Power Center 10.2.0, Windows 10, Amazon Redshift, Oracle 11g, SQL, PL/SQL, PL/SQL Developer, JIRA & UNIX.

Confidential

Sr. Data Warehouse/ETL Informatica Lead Developer

Responsibilities:

• Responsible for Requirement Gathering Analysis and End user Meetings
• Responsible for Business Requirement Documents BRD's and converting Functional Requirements into Technical Specifications
• Responsible for mentoring Developers and Code Review of Mappings developed by other developers
• Extracted data from various heterogeneous sources like Oracle, SQL Server, and Flat Files.
• Responsible for Production Support and Issue Resolutions using Session Logs, and Workflow Logs
• Responsible for best practices like naming conventions, Performance tuning, and Error Handling
• Worked with Shortcuts across Shared and Non Shared Folders
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Have taken care of all the tasks from the creation of project in DEV to production migration and validation
• Developed job sequences with restart ability, check points and implemented proper failure actions.
• Built reusable sequencers and parallel jobs and used the appropriate partitioning techniques for the robust performance of the jobs.
• Used Update Strategy DD INSERT, DD DELETE, DD UPDATE, AND DD REJECT to insert, delete, update and reject the items based on the requirement
• Worked with Session Logs and Workflow Logs for Error handling and Troubleshooting in all environment.
• Built reusable UNIX scripts to FTP the multiple files from source system to ETL Server and archive the files in UNIX server.
• Responsible for Unit Testing and Integration testing of mappings and workflows.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Lead the Data Integration team of offshore (10).

Environment: Informatica Power Center 9.1.0/10.1.1 Hotfix1, AWS Glue, Windows 7, AWS, SQL Server2012, SQL, PL/SQL, PL/SQL Developer, HPQC & UNIX.

Confidential

Sr. Lead ETL Informatica Developer

Responsibilities:

• Responsible for interacting with Business users for requirements gathering.
• Extensively used ETL to load data from Flat Files, XML, Mainframe VSAM files, DB2, Sales force and Oracle to Oracle 11g.
• Designed and developed end-to-end ETL process from various source systems like MF-VSAM and DB2 to Staging area, from staging to OLTP.
• Created Mapplets, reusable transformations and used them in different mappings.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Created Workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
• Made use of Post-Session success and Post-Session failure commands in the Session task to execute scripts needed for cleanup and update purposes.
• Implemented CDC by tracking the changes in critical fields required by the user.
• Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
• Created Web services mappings for consumer and Provider, used Web services consumer transformation, XML parser to parse the incoming data.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Involved in Migrating the Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• Extensive experience in troubleshooting and solving migration issues and production issues.
• Write Shell script running workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Environment: Informatica Power Center 9.1.0 Hotfix6, Power Exchange, Windows 7, Database 11g, DB2, MF-VSAM, Sales force, Web services, AWS, SQL, PL/SQL, PL/SQL Developer, HPQC & UNIX.

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Model.
• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from various sources like Oracle, sql server and Delimited Flat files.
• Converting employee data from all across the globe (J & J numerous HR systems) to load into Workday Cloud application.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow manager.
• Proficiency in building scorecards and applying metrics and group the dimensions.
• Worked with cleanse, parse, standardization, validation, scorecard transformations.
• IDQ is used for data cleansing, Tuning and profiling and Implemented reports, dashboards to display DQ results.
• Worked on identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Prepared various mappings to load the data into different stages like Landing, Staging, Work and Core tables.
• Applied slowly changing dimensions like SCD Type 1 and 2 effectively to handle delta Loads.
• Created various tasks like Session, Command, Timer and Event wait.
• Lead the development team during the development process, this include provide help with the tasks and transfer knowledge of Informatica.
• Automated the Informatica jobs using UNIX shell scripting.
• Coordinated the migrations to QA, UAT and production environments.
• Defining and implementing the standards, shared components and approaches as per the J & J Standards.
• Created post-session and pre-session shell scripts and e-mail-notifications for successful and failure scenarios.

Environment: Informatica - Power Center 9.1.0, Data Quality(IDQ) 9.1, Power Exchange 8.1.2, Oracle11g,DB2, Erwin 7.1, SQL, UNIX Shell Script, SQL Server, Windows 7.

Confidential

Sr. ETL Informatica Developer

Responsibilities:

• Analyzed the requirements before starting the development process
• Interacted with business users, reporting analysts in gathering information about the business logic to populate the target tables.
• Created mappings to load identified master records into Central Repository for DW load process.
• Prototyped Dimension Model & ETL process by matching the business requirements and core technical requirements from reporting team.
• Load operational data from Oracle, SQL Server, flat files, Excel Worksheets into various data marts like AP and GL.
• Worked as part of the architect team to develop complete schema (Snow Flake) for the Phase I of the Data Warehouse.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created complex mappings for Data Marts with fact less facts.
• Suggested changes in ETL development process which improved productivity and ability to hit the target plans with less overhead
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Debugged existing code for business logic issues.

Environment: Informatica Power Center 8.6.1 Hot fix 12, Windows 7, Oracle Database 10g/11g, DB2, SQL, PL/SQL, SQL*Plus, TOAD, Team Tracker, PVCSVM, UNIX.