SUMMARY:

• Over 8 years of IT experience in Analysis, Design, Testing, Development and Implementation of client/server applications
• Strong experience in performing ETL operations like Data Extraction, Data Transformation and Data Loading with Informatica Power Center 10.2/9.6.0/9.1.0/8.6.
• Strong experience in developing ETL code with Informatica Intelligent Cloud Services.
• Worked intensively with Informatica PowerCenter Designer. Strong knowledge on Source Analyzer, Warehouse designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively used Informatica Workflow manager and Workflow monitor for creating workflows, worklets, sessions and monitoring workflows,
• Extensively worked on Informatica PowerCenter Transformations such as Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and Source Qualifier Extensively.
• Strong in database concepts with SQL, PL/SQL and Oracle.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, packages, procedures and complex queries for data analysis and extraction.
• Experience in UNIX Shell Scripting and Autosys for scheduling the jobs.
• Experience in testing/validating the Source, Stage and Target (End - to-End).
• Extensive experience in Informatica Power Center which involved creating debugging and executing Informatica Mappings, Sessions, Tasks and Workflow.
• Experience in databases like Oracle 12c/10g/9i/8i, my SQL, MS SQL Server 2008.
• Strong problem-solving skills, ability to develop strategies for clients and provide detailed documents to clients.
• Excellent analytical and SQL writing skills to address different business scenarios.
• Experience of using different databases like Oracle/SQL Server.
• Experience in Developing jobs in SAP BODS jobs.
• Experience in Loading data in AWS.
• Extensively involved in Business requirements meetings to gather and understand the requirements.
• Experience in Onsite-Offshore model.
• Exposure to full project life cycle development for implementation and integration.
• Hands on experience in Production Support and Maintenance by resolving issues to meet all Data Warehouse service Level agreements (SLAs).
• Experience in Data loads and monitoring the loads and performing required steps if the job fails.
• Extensively involved in creating Run books, code deployment in various environments.
• Experience in Performance testing and Performance tuning.
• Experience of using different Defect trackers like QTP, JIRA.
• Extensively involved in defect fixes.
• Experience on Production Support.
• Experience in working with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

TECHNICAL SKILLS:

Informatica PowerCenter, Informatica Intelligent Cloud Services SAP BODS 4.2/3.0:

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables

Database and related tools: Oracle 12c/10g/9i/8i, MS SQL Server 2008, PL/SQL, TOAD 12.10/8.5.1/7.5, AWS Redshift, Aginity

BI & Reporting Tools: Business Objects, Tableau

Languages: C, SQL, PL/SQL, SQL*Plus, Working knowledge of Unix Shell Scripting

Operating Systems: Microsoft XP/NT/2000/98/95, UNIX.

PROFESSIONAL EXPERIENCE:

ETL Developer,

Confidential, Houston, TX

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures to convert and load the data from various legacy source systems to target Business Data Warehouse.
• Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
• Developed Design documents and ETL mapping documents.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
• Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
• Loading of data from different source systems into Oracle Target database.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Extensively involved in code review and code migration and in code deployment in different environments.
• Worked with ATLASSIAN for defects and Enhancements status tracking.
• Extensively involved in defect fixes and defect triage meetings with stakeholders and managers. Experience in working with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: Informatica PowerCenter 10.1,SQL Developer Management Studio, Oracle,SQL Developer,Atlassian.

Confidential, Houston, TX

Responsibilities:

• Extensively involved in design and Development of data model for creating the Reporting layer
• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures to convert and load the data from various legacy source systems to target.
• Developed Design documents and ETL mapping documents.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
• Loading of data from different source systems into AWS Redshift.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Extensively involved in defect fixes and defect triage meetings with stakeholders and managers. Experience in working with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: Informatica Power Center 10.2, Amazon Cloud Services, Redwood, Aginity

Confidential, Austin, TX

Responsibilities:

• Extensively involved in design and Development of data model for creating the Reporting layer
• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures to convert and load the data from various legacy source systems to target.
• Developed Design documents and ETL mapping documents.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
• Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
• Loading of data from different source systems into Oracle Target database.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Extensively involved in code review and code migration and in code deployment in different environments.
• Extensively involved in defect fixes and defect triage meetings with stakeholders and managers. Experience in working with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: Informatica Power Center 10.2, Informatica Power Center 9.6, Informatica Power Center 9.1, Informatica intelligent Cloud Services, Oracle 12c, Toad 12.10, SQL Developer

Confidential, San Antonio, TX

Responsibilities:

• Analyzed and understand the Table metadata, Source systems, File Formats, Data Types, Column Names, Field Lengths and schedule
• Responsible to write SQL statements to create table DDL in staging area, also for Dimension and Fact tables
• Created the Multiple Jobs in SAP BODS 4.2
• Added SQL Statements, functions and Variables in Initialization and End-job Scripts, created Workflows, Data Flows, IfThenElse Statements and Where Clauses
• Used Formats and Transforms including Query,Key Generation and Map Operation.
• Utilized Lookups, Lookup ext, table Joins, Match, Merge transforms and custom functions
• Performed Job Validation and Syntax checks and Dry Run to evaluate for errors, execution time and bottlenecks. Utilized Try and Catch block
• Loaded the test data to estimate job run time and Performance Statistics and optimized and fine-tuned the job. Used Push Down where applicable.

Environment: SAP BODS 4.2, Oracle 12c, SQL Developer

Confidential, San Francisco, CA

Responsibilities:

• Completed the configuration of Data Stores, Local Repository & its Connections
• Responsible for “Right Object names” FMD’s, developed the transformation logic using BODS
• Gathered the requirement from Business analyst for converting the data from source to target
• Analyzed and understand the Table metadata, Source systems, File Formats, Data Types, Column Names, Field Lengths and schedule
• Responsible to write SQL statements to create table DDL in staging area, also for Dimension and Fact tables
• Created the Multiple Jobs in SAP BODS 4.2
• Added SQL Statements, functions and Variables in Initialization and End-job Scripts, created Workflows, Data Flows, IfThenElse Statements and Where Clauses
• Used Formats and Transforms including Query,Key Generation and Map Operation.
• Utilized Lookups, Lookup ext, table Joins, Match, Merge transforms and custom functions
• Performed Job Validation and Syntax checks and Dry Run to evaluate for errors, execution time and bottlenecks. Utilized Try and Catch block
• Loaded the test data to estimate job run time and Performance Statistics and optimized and fine-tuned the job. Used Push Down where applicable.

Environment: SAP BODS 4.2, Oracle 11g, SQL Developer

Confidential, Glendale, AZ

Responsibilities:

• Extensively involved in design and Development of data model for creating the Data analytics layer
• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures to convert and load the data from various legacy source systems to target Business Data Warehouse.
• Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
• Developed Design documents and ETL mapping documents.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
• Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
• Loading of data from different source systems into Oracle Target database.
• Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Extensively involved in code review and code migration and in code deployment in different environments.
• Extensively involved in defect fixes and defect triage meetings with stakeholders and managers. Experience in working with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: Informatica Power Center 9.6, Informatica Power Center 9.1, SQL Developer Management Studio, Oracle 10g, Toad, SQL Developer

Confidential, Glendale, AZ

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures to convert and load the data from various legacy source systems to target Business Data Warehouse.
• Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.
• Developed Design documents and ETL mapping documents.
• Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
• Generated PL/SQL scripts and UNIX Shell scripts for automated daily load processes.
• Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
• Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
• Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
• Loading of data from different source systems into Oracle Target database.
• Wrote shell scripts to work with flat files, to define parameter files and to create pre and post session commands.
• Unit testing and System Testing of Informatica mappings and Workflows.
• Extensively involved in performance tuning at source, target, mapping, session and system levels by analyzing the reject data.
• Maintained Development, Test and Production mapping migration using Repository Manager.
• Extensively performed unit testing and system or integration testing.
• Extensively involved in code review and code migration and in code deployment in different environments.
• Extensively involved in defect fixes and defect triage meetings with stakeholders and managers. Experience in working with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Extensively involved in Production deployment and production support.

Environment: Informatica Power Center 8.6, SQL Developer Management Studio, Oracle 10g, Toad

Confidential, Walnut Creek, CA

Responsibilities:

• Analysis of the Source system from where the data need to be extracted.
• Interacting with the Client to understand the Source system.
• Involved in the Data model design where the data need to load.
• Development of the mapping Documents.
• Development of the ETL Mappings to extract the data from Source and Load in to the Target.
• Involved Extensively in Defects Fixes.
• Involved in the Code review.
• Coordinating with the offshore team to develop the ETL Code.

Environment: Informatica Power Center 8.6, SQL Developer Management Studio, Oracle 10g, Toad.

Confidential, Milpitas, CA

Responsibilities:

• Development of Dashboards and Reports using SAP Business Objects 4.0
• Unit Test/Integration testing of Finance, PSO and Field Ops Dashboards
• Profile Creation and Publishing in Central Management Console
• Worked with Business Users to fix defects identified during User Acceptance Testing
• Creating necessary transition documents and conducting Knowledge Transfer sessions to ensure smooth transition to support and maintenance team after go live

Environment: Business Objects XI Desktop Intelligence, Business Objects XI Web Intelligence

Confidential, San Jose, CA

Responsibilities:

• Ensure all the active services on Production, Dev and UAT environments are up and running.
• Monitoring the footprints application regularly for any work orders pending.
• Maintaining Development and Production Servers for the Company.

Environment: Informatica 9.1, Oracle 10g