SUMMARY:

• 9+ Years of Total rich software services industry experience that spans Data Warehousing, Managing client relations,Project delivery and hands on development gained by working with DB2,Oracle and SQL
• IT Experience in Data Loading, Analysis, Design, Development, and Coding by using Various Technologies like Informatica Power Center and Oracle in Data Warehousing.
• Development and Coding Experience on ETL processes by using Informatica Power Center 9x8.6.0 & Oracle 11g, Oracle 10g like PL/SQL Coding, Shell Scripting on UNIX Platform.
• Extensive experience with Data Warehouse and BI methodologies and strong understanding of Relational, Multi - Dimensional Database concepts and OLAP.
• Experience working with different Databases like Oracle 11, Oracle10g, Oracle 9i/8i, SQL Server 2000/2005, Netezza(NZSQL) and MS Access.
• Hands-on experience in designing, tuning, and leveraging large data warehouses using RDBMS databases like Oracle, SQL Server database applications and Data warehouse appliances like Netezza.
• Strong experience in designing/modeling and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Master Data Management (MDM), Metadata Management, Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using ETL tools, Informatica PowerCenter 8.x/7.x/6.x, PowerExchange 8.0,Data explorer, OLTP&OLAP.
• Experience in OBIEE and Administration tool RPD, Hyperion Interactive Reporting.
• Experience in production support and environment - environment migration .
• Experienced in Global Delivery Model and management of Onsite/Offshore teams.
• Developed PL/SQL stored procedures, functions, packages, SQL queries, indexes, triggers and materialized views. Worked on Informatica Power Center Client Tools like Designer, Workflow Manager, Workflow Monitor & Repository
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source and target systems like flat files, MS SQL, Oracle.
• Extensively worked on Informatica Designer Components - Source analyzer, Transformations Developer, Mapplet and Mapping Designer.
• Hands on experience with complex mappings using varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations
• Experienced in using Informatica Power Exchange CDC (Change Data Capture) for capturing the database inserts, updates, and deletes underlying these events as soon as they occur which makes the ETL process more flexible
• Developing ETL processes like Data Extraction, Transformation, and Loading using various Versions like Informatica Power Center 9.1.0/ 8.6.0 and 7.1.1.
• Strong knowledge in Informatica Architecture.
• Extensively worked on Informatica Power Center Designer, Workflow Manager and Workflow Monitor tools.
• Strong Knowledge on ETL tool like Informatica and Clear understanding of Software Development Life Cycle (SDLC) in Data Warehousing.
• Have clear understanding of Data warehousing Concepts like BI, Star Schema, Snowflake Schema, OLTP, OLAP, Staging Area and ODS.
• Extensively worked on third party tool like TOAD, SQL*PLUS and PL/SQL Developer.
• Good Knowledge on RDBMS Concepts in Oracle.
• Ability to work with any Environment based on client requirement and Ability to interaction with Client regularly.
• Ability to manage project issues and Risks, Deliver work on time with multiple, competing priorities.
• Ability to work in a team or individual and handling multiple tasks simultaneously and Ability To pickup new skills quickly
• Good Analytical and strong Interpersonal skills and Excellent Communication Skills.

TECHNICAL SKILLS:

ETL Tool: Informatica Power Center 9.1/8.x/7.x Informatica PowerExchange 8 for Oracle/VSAM, Informatica Data Stensil,Talend, Informatica Metadata Manager, Data explorer, Erwin, Data Analyser, Cognos, OBIEE,Business Objects XI

Databases & Tools: Oracle 8i,9i and 10g (SQL*Plus,PL/SQL with Stored Procedures) SQL Server 2005, DB2, Netezza(NZSQL), IMS/DB & TOAD.

FRAME WORK: Bright light frame work 3.2

Operating Systems: Windows 2000/ NT/ XP.Linux, Unix Shell Scripting.

Languages:: PL/SQL, advanced SQL, C, C++, COBOL, JCL, HTML, XML, Unix Shell Scripting, Java, MS OFFICE (MS Word, MS Excel, MS Access).

Packages: MS OFFICE (MS Word, MS Excel, MS Access).

Business Areas:: Banking, Health Care, Insurance, Enterprise, Sales and Retail.

Reporting tools:: Cognos, OBIE RAD,OBIEE business intelligence publisher, BIP,Cognos, Hyperion interactive reporting - Explorer 6.3

Other Tools/Packages:: Jira, Mercury Test Director, Autosys, Toad, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead

Environment: Teradata,Informatica 9.6.1,Informatica 9.5.1 QC, Autosys, CA7, Unix, Hadoop, DMexpress, Mainframe(JCL),

• Participating in project discussions to gather the requirements and to monitor status / progress of the project.
• Through analysis of requirements to identify ambiguity, incompleteness or incorrectness.
• Checking whether the design is correct by logically analyzing the model and predicting its execution.
• Understanding the actual business that has created a need for the project. This helps in better design of the system.
• Preparation of a design / model for the system to be enhanced / developed, following standard models & artifacts.
• Preparing unit test plan and test scripts which could be used along with sample test data for validation.
• Following proper naming conventions and version control in the documents / datasets / components that are used in the project.
• Coding the system by following effective coding practices to meet the requirements
• Conducting Quality reviews of design documents, code, test plan and test scripts regularly to ensure defect free delivery.
• Gathering the data from the source (SOR).
• Aggregating the data as per requirement and loading the transformed data into ‘The W’.
• Testing and validating the code by executing test scripts to ensure that all the client requirements are satisfied and monitoring the performance of the system by collecting and analyzing the metrics.
• Conducting UAT (User Acceptance Testing) in case if it is required.
• Migrating the data
• Moving the data across databases whenever needed by using network data movement.
• Identify, assess, control and plan contingency measures.
• Arranging for a Final inspection of the developed and tested component to make sure that the component adheres to the quality standards.
• Implementation and post implementation support. Turnover to production support team.
• Worked on Space capacity management as per the Value add programs.
• Designing of new applications and performing data flow analysis for ensuring the data flow model is as per the requirement of the project.
• Projection of estimates for various types of projects which includes the below.
• ETE Project-Files received from various vendors, stored on edge node, performed ETL with control checks and generated reports for end user
• FTS & ACH: Regression only
• Safe connect: New Application onboading- File processing with validation data controls and transmit files to downstream
• FTS: Enhancement projects- Regression with data testing.
• Migration projects: Performed successful informatica Upgrade from 9.5.1 to 9.6.1.
• Decommission projects - Inprogress
• Handle resource recruitment processes by evaluating profiles for project requirements. Conduct interviews to assess resource suitability for customer requirements.
• Propose new business ideas and process improvement opportunities for the customer leveraging TCS expertise and capabilities in new areas for partnership with the client
• Lead a team of 5+ offshore resources from onshore as a Tech Lead from assigned projects .

Confidential, Charlotte, NC

SR.ETL Informatica Developer

Responsibilities:

• Involved in BAMD application for windows server to Linux and SQL server DB to Oracle DB conversion project.
• As part of this conversion work I modified about 180 work flows from sql server code to oracle and tested as-is functionality and data movement
• Involved in Designing the technical design specifications and program specification documents for ETL jobs
• Interacting with BA for changes in requirement to analyze how much impact on ETL development as it needed
• Attending Agile Stand up meetings with technical team and project manager
• Worked closely with technical lead, Business Analyst and Data Architect in designing E-Recepits project and developing application.
• Responsible for code deployment from Dev to SIT environment
• Preparing migration document for Prod migration
• On call Production support and Responsible for monitoring production jobs
• Developing mappings, sessions, worklets, reusable objects, reusable maplets and workflows in Informatica power center.
• Analyzing the problems and providing optimum solutions to customers
• Preparing unit test cases and documentation
• Tuning mappings and sessions to optimize the performance
• Creating Autosys jobs to automate the workflow scheduling
• Creating SQL’s and Oracle scripts to customize the ETL operations in Informatica
• Participating in Integration testing and User Acceptance testing
• Involved in implementation support

Environment: Informatica Power Center 9.5.1, Oracle 11g (SQL, PL/SQL), Sql server 2012, TOAD, Autosys and UNIX, tectia,SSH, Perforce, Windows Server, JIRA tool for managing tasks

Confidential, CA

SR.ETL Informatica Developer

Responsibilities:

• Designing the technical design specifications and program specification documents for ETL jobs
• Interacting with Business team for changes in requirement to analyze how much impact on ETL development as it needed.
• Attending Agile Stand up meetings with Business, technical team and project manager
• Working closely with Data Architect and Business Analyst
• Responsible for code deployment from Dev environment to SIT to PROD
• Responsible for ETL development delivery for internal release
• Preparing migration document for Prod migration
• On call Production support and Responsible for monitoring jobs
• Worked on ITSM tickets for Change request and service request tickets.
• Creating source to target mappings and developing the ETL mappings using Informatica Power center worked with Power Exchange for CDC process
• Developing mappings, sessions, worklets, reusable objects and workflows in Informatica.
• Analyzing the problems and providing optimum solutions to customers.
• Involved in production support to resolve production tickets and data clean up operations
• Creating SQL,PL/SQL scripts to fix the data in production and development environments
• Preparing unit test cases and documentation.
• Migrated objects from source to target.
• Worked closely with Micro strategy team to support reports
• Tuning mappings and sessions to optimize the performance.
• Creating shell scripts to automate the workflow scheduling.
• Creating SQL’s and Oracle scripts to customize the ETL operations in Informatica.
• Preparing unit test cases and documentation.
• Participating in Integration testing and User Acceptance testing
• Involved in implementation support
• Playing an effective team member’s role in the team of 6.
• Environment: Informatica Power Center 9.1.0, Power exchange, Oracle 11g (SQL, PL/SQL), AS400,SAP, TOAD, Oracle, Micro Strategy and UNIX.

Confidential

Sr.ETL Developer

Responsibilities:

• Involved in Designing the Ambulatory technical design specifications and program specification documents for ELT jobs
• Created Frame work Transformations with NZSQL to load data from temp data bases to REP and Reporting databases.
• Responsible to understand bright light frame work standard code and generate code in netezza accordingly.
• Created stored procedures in Postgres database .
• Performed Unit testing for all transformations created in different environments.
• Migrated code/objects from the development environment to SIT QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Participated in Daily scrum meeting and weekly tech meetings and end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.,
• Extracted and transformed data from oracle environment as the source into Dimensional warehouse model in Netezza(NZSQL) database as the target
• Created Netezza database, users, base table and views using proper distribution key structure.
• Created shell scripts to extract data from Mainframe and load into Netezza.
• Responsible to monitor Autosys jobs to make sure everything up and running.
• Involved in planning meetings
• Created and updated stories in Jira .
• Expertise in data validation operations in middle of ETL processes.
• Created END to END documentation for postgres to Ambulatory NETEZZA}
• Analyzing the issues and providing optimum solutions to business
• Worked closely with Business Analysts and Java Architects for business requirements and design application
• Documented production RUN BOOK for production releases.
• Prepared the necessary reports and the release documents from time to time that is required for the project migration.s
• Co-ordinate with BAU team and UI team for issues resolve.
• Creating advance SQL,PL/SQL scripts to create config files and sql files which are used to for file extractions and load in development environment.
• Preparing unit test cases and documentation

Environment: Oracle 11g (SQL, PL/SQL), Postgres database, Netezza(NZSQL), SQL server,Bright light Frame work 3.2, Talend,Advance SQL,Flat files, Cognos, FTP, AutoSys, Jira, TOAD, UNIX and VISIO.

Confidential, NC

Sr.ETL Developer

• Involved in Designing the technical design specifications and program specification documents for ETL jobs
• Created and ran Talend jobs to extract files from Oracle data source
• Created context file to provide source and target connections.
• Prepared the necessary reports and the release documents from time to time that is required for the project migration.
• Migrated code/objects from the development environment to SIT QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Responsible for Develop Mappings and Redesigning of scripts
• Took existing shell scripts and made them generic
• Created work and staging tables in Netezza in Development environment and SIT environment
• Performed Unit Testing and Integration Testing for both Full and CDC loads.
• Participated in Daily scrum meeting and weekly tech meetings and end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.,
• Extracted and transformed data from oracle environment as the source into Dimensional warehouse model in Netezza(NZSQL) database as the target
• Created Netezza database, users, base table and views using proper distribution key structure.
• Created shell scripts to extract data from Mainframe and load into Netezza.
• Created jil files for autosys jobs for RDR full extracts and CDC extracts. Manually loaded data by using shell scripts into netezza table by using nzsql load.
• Created reusable transformations and mapplets and used them in mappings
• Expertise in data validation operations in middle of ETL processes.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them
• Responsible for monitoring all the sessions that are scheduled, running completed and failed using Workflow Monitor
• Creating transformations like Normalizer,Router,Lookup,Expression, Sequence generator and Update strategy
• Creating source to target mappings and developing the ETL mappings using Informatica Power center
• Created END to END documentation for one time load from portsum TERADATA} to aspen NETEZZA}
• Implemented process to load one time loads from Portsum database Teradata into BT tables so that business can analyze the data.
• Analyzing the issues and providing optimum solutions to business
• Documented production RUN BOOK for production releases.
• Tuning the mappings to achieve better performance
• Co-ordinate with BAU team and UI team for issues resolve.
• Creating advance SQL,PL/SQL scripts to create config files and sql files which are used to for file extractions and load in development environment.
• Preparing unit test cases and documentation
• It’s an agile methodology.

Environment: Oracle 11g (SQL, PL/SQL),Teradata, Netezza(NZSQL), Informatica power center 9.1.0.Talend,Advance SQL,Flat files, Mainframe, FTP, AutoSys, Jira, Cogno,TOAD, UNIX and VISIO.

Confidential, MI

Sr.ETL Developer

• Designing the technical design specifications and program specification documents for ETL jobs
• Crating and running sessions and workflows required to load the data into oracle application from flat files and staging tables
• Prepared the necessary reports and the release documents from time to time that is required for the project
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Performed Unit Testing and Integration Testing for both Full and Incremental Loads.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.,
• Extracted and transformed data from oracle environment as the source into Dimensional warehouse model in Netezza(NZSQL) database as the target
• Migration of data from Oracle to Netezza
• Created Netezza database, users, base table and views using proper distribution key structure.
• Used Informatica Power Connect for Netezza to pull data from Netezza data warehouse.
• Developed mapping parameters and variables to support connection for the target database as Netezza and source database as Oracle OLTP database.
• Created reusable transformations and mapplets and used them in mappings
• Expertise in data validation operations in middle of ETL processes.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them
• Responsible for monitoring all the sessions that are scheduled, running completed and failed using Workflow Monitor
• Creating transformations like Normalizer,Router,Lookup,Expression, Sequence generator and Update strategy
• Creating source to target mappings and developing the ETL mappings using Informatica Power center
• Analyzing the problems and providing optimum solutions to customers
• Tuning the mappings to achieve better performance
• Involved in production support to resolve production tickets and data clean up operations
• Creating advance SQL,PL/SQL scripts to fix the data in production and development environments
• Expertise in unit test, integration test of Informatica components
• Involved in performance tuning the SQLs to optimize the run time in mappings
• Preparing unit test cases and documentation
• Involved in implementation support
• Lead the team and conducted knowledge sessions with the team of 6.
• Responsible for automating all ETL process that can be automated.

Environment: Oracle 11g (SQL, PL/SQL), Tera data, Netezza(NZSQL), SQL Server, Advance SQL,Flat files, Auto Sys, Erwin Data Modeler, Autosys,Talend, TOAD, and UNIX.

Confidential, CA

ETL Consultant

• Designing the technical design specifications and program specification documents for ETL jobs
• Creating source to target mappings and developing the ETL mappings using Informatica Power center
• Developing mappings, sessions and workflows using Informatica.
• Analyzing the problems and providing optimum solutions to customers.
• Involved in production support to resolve production tickets and data clean up operations
• Creating SQL,PL/SQL scripts to fix the data in production and development environments
• Preparing unit test cases and documentation.
• Migrated objects from source to target.
• Created OBIEE answers reports and Migrated RPD and reports to production
• Created automated data profiling for source using informatica data explorer.
• Tuning mappings and sessions to optimize the performance.
• Creating shell scripts to automate the workflow scheduling.
• Creating SQL’s and Oracle scripts to customize the ETL operations in Informatica.
• Preparing unit test cases and documentation.
• Participating in Integration testing and User Acceptance testing
• Involved in implementation support
• Playing an effective team member’s role in the team of 8.

Environment: Informatica Power Center 9.1.0, Data explorer IDE, Informatica data qualifier IDQ Oracle 11g (SQL, PL/SQL), TOAD, Oracle Business intelligence enterprise edition,OBIEE 10.1.3,BIP, Hyperion and UNIX.

Confidential, MN

ETL Consultant

Responsibilities:

• Understanding the Customer Requirements and the Technical Specifications Documents.
• Extraction of data from Different Sources like Oracle, SQL server, Cobal and Flat files.
• Designed Harvest Packages to make changes to UNIX/Perl/ Netezza(NZSQL)SQL Scripts.
• Worked extensively on Netezza Framework to create and execute the scripts which performs the various ELT Operations from source to target database
• Integration of Different Source data in Staging Area by using ETL process like Data Merging, Data Cleansing and Data Aggregation.
• The load ready files are loaded into Teradata Tables using Teradata’s ODBC/Fast, Multi load connection. The Load Date and Time are also captured in the Teradata table.
• Developed Teradata BTEQ’s (Batch Teradata Queries) to populate data into Teradata target tables.
• Designed Complex Teradata SQL’s to pull the data from source systems and to populate data into target tables.
• Developed UNIX Shell scripts and used them in Informatica Pre- & Post- Session command tasks and Standalone Command tasks.
• Design, Develop and Implementation of Informatica Mappings and Workflows.
• Creation of Mappings using Different Transformations like Source Qualifier, Joiner, Expression, Aggregator, Router, Sorter, Lookup and Update Strategy Transformation.
• Used SQL Queries, different properties in Transformations.
• Involved in performance tuning on Informatica like Session level and Mapping level.
• Creating the Workflow and Running the Workflow by using Workflow Manager.
• Involved in Unit test plans and Performing Unit Testing on ETL Mappings and Workflows.
• Preparation of Design Documents, Test Cases and Test Scripts.
• Validating the Required data at the database level by using 3rd party tool like TOAD.
• Files data move to another Server by using FTP on UNIX Platform.
• Open to play the role of independent contributor in handling a complex task.
• Playing an effective team member’s role in the team of 6.

Environment: Informatica Power Center 8.6.0, SVN,Oracle 10g (SQL, PL/SQL),DB2, Erwin Data Modeler, ARIS, Netezza(NZSQL) 3.0, Teradata V2R5,MDM,TOAD, and UNIX. HP Quality Center 9.2

Confidential, MA

ETL Developer

Responsibilities:

• Understanding the Technical Specifications Documents and providing KT.
• Extraction of data from Different Sources like Oracle and Flat files.
• Integration of Different Source data in Staging Area by using ETL process like Data
• Merging, Data Cleansing and Data Aggregation.
• Creating Mappings using Different Transformations like Source Qualifier, Joiner, Expression, Aggregator and Lookup Transformations.
• Used SQL Queries, different properties in Transformations.
• Creating of Sessions according Business logics by using Task Developer.
• Creating the Workflow and Running the Workflow by using Workflow Manager.
• Involved in performance tuning on Informatica like Session level and Mapping level
• Involved in Unit test plans and Performing Unit Testing like Quantitative Testing and Qualitative Testing.
• Validating the Required data at the database level by using 3rd party tool like TOAD.
• All Mappings & workflows succeeded in Testing Environment move from Development to Production Environment.
• Open to play the role of independent contributor in handling a complex task.
• Played an effective team member’s role in the team of 8.

Environment: Informatica Power Center 8.1.1, Oracle 9i (SQL, PL/SQL), TOAD, and UNIX.