SUMMARY

• 11+ years of experience IT Industry in various areas like Application Development, Enhancement, Maintenance and Support, Application Management & Implementation
• Strong data warehousing ETL experience using Informatica 9.6/9.1/8.6 Power Center client tool.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, XML Transformations.
• Worked with different data sources such asOracle,SQL Server,DB2,SAP,Flat files,HDFS.
• Having good experience in writing UNIX script, AUTOSYS JILs.
• Experience in project estimation and onsite, offshore team management.
• Strong experience in the analysis, design, development, testing and implementation of Business Intelligence solutions using Data Warehouse.
• Experienced in performance tuning of mappings, sessions and workflows including partitioning.
• Involved in full life cycle development of Data Warehousing.
• Excellent understanding of Star Schema, Snowflake modeling. Fact, Lookup and Dimensions Tables.
• Excellent skills in understanding business needs and converting them into technical solutions.
• Good exposure in Informatica MDM.
• Exposure on Hadoop ecosystems, HDFS, Big Data, HIVE, MR, SQOOP and RDBMS.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.
• Good exposure in project estimation, preparing BRD, FRD, Technical specs, project documentation.
• Very good domain experience in Banking AML applications, Healthcare and Aviation Domains.
• Good experience in handling AML/FRAUD applications like ACTIMIZE, CASE MANAGEMENT tools, etc.
• Good exposure in handling vendors in multiple projects with cross platform technologies like Informatica, MS.NET, OBIEE, UNIX, Mainframe - DB2 etc.
• Good experience in Job scheduling tools like CA7, Autosys, Tivoli.
• Good experience in ITIL Process.
• Good experience in change management, incident management and problem management methodologies and also part of CAB team defining the process as per ITIL methodologies.
• Good experience in defining the new process as per business requirement to support the applications.

TECHNICAL SKILLS

DW Tools: Informatica Power Centre 7x and 8x, 9x, OBIEE

DataModeling Tools: ERWin, TOAD Data Modler

BigData: Hadoop, HIVE, SQOOP, MR

RDBMS: Oracle, DB2, SQL Server, Ms-Access

Programming Languages: C#.NET, UNIX Shell Script, Batch Script

Scheduling Tools: CA7, AUTOSYS, TIVOLI

Operating Systems: Windows NT/2000/XP, MS-DOS, UNIX

Tools: & Utilities: PUTTY, VSS, Service Center 6.2, SM9, HPSA, Service Now

Web Related: ASP.Net, HTML, XML

Server: WAS, IIS, MOSS

PROFESSIONAL EXPERIENCE

Confidential, McLean, VA

ETL Sr - Developer

Environment: Informatica-9.6, UNIX,AUTOSY,ORACLE,SQL SERVER-2008,FlatFiles,DB2

Responsibilities:

• Involved in analysis, LLD, HLD and documentation of mapping specs as per business rules.
• Creating inforamatica mappings as per business requirements. developing SCD type 2, type 1 mappings using informatica.
• Prepare test strategy and Test Directories
• Developed UNIX scripts to handle source files.
• Developed AUTOSYS JIL scripts to manage informatica workflow jobs
• Performed UNIT Testing on developed mappings
• Extensively used CDC on real time data.
• Extensively used Sql server Database from source and target.
• Participate in review of test document for the end-to-end testing
• Prepare project status reports for the work carried out
• Collect and reporting metrics on end-to-end testing.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of INFORMATICA.
• Experienced in ETL auditing process.
• Used most of the transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression, Aggregator, Connected & Dynamic Lookup, Rank, Router, and Update Strategy, SQL Transformation, etc.
• Scheduled the Informatica Workflows as per user requirement by using AUTOSYS scheduling tool.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
• Involved in unit testing to test the processed data and user acceptance testing.
• Experienced in troubleshooting and fix the different Development/Production environment issues.
• Involved in environment creation of metadata manager.
• Involved in recycle Repository, integration services and creation of automated scripts for deployment using pmrep command.
• Involved in Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories.
• Experienced in writing Uniting Test Cases with multiple scenarios.

ETL Technical Lead

Environment: Informatica-9.6, OBIEE, Oracle11g,ERWin, TOAD Data Modeler, UNIX, Mainframe-DB2, MS.Net, WAS, HDFS

Responsibilities:

• Involved in analysis, LLD, HLD and documentation of mapping specs as per business rules.
• Involve in understanding test requirements
• Prepare test strategy and Test Directories
• Participate in test case development and execution
• Participate in test results document preparation for the project
• Participate in bug reporting and tracking for the project
• Performed ETL data loading into OBIEE Environment.
• Loading the data into HIVE
• Extensively used CDC on real time data.
• Extensively used Sql server Database from source and target.
• Participate in review of test document for the end-to-end testing
• Prepare project status reports for the work carried out
• Collect and reporting metrics on end-to-end testing.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of INFORMATICA.
• Experienced in ETL auditing process.
• Used most of the transformations such as Source Qualifier, Filter, Joiner, Sequence Generator, Expression, Aggregator, Connected & Dynamic Lookup, Rank, Router, and Update Strategy, SQL Transformation, etc.
• Scheduled the Informatica Workflows as per user requirement by using AUTOSYS scheduling tool.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.
• Involved in unit testing to test the processed data and user acceptance testing.
• Experienced in troubleshooting and fix the different Development/Production environment issues.
• Involved in environment creation of metadata manager.
• Involved in recycle Repository, integration services and creation of automated scripts for deployment using pmrep command.
• Involved in Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories.
• Experienced in writing Uniting Test Cases with multiple scenarios.

Confidential

Sr. Analyst

Environment: Informatica-9.1,Hadoop-hiave,sqoop,Oracle11g,UNIX,DB2,OBIEE 11g, ERWin

Responsibilities:

• Involved in gathering and analyzing requirements, prepared Technical Design document and Source - Target Mapping docs and presented to BU team to finalize and get sign off
• Worked on project plan to define the efforts and estimations tasks.
• Designed and Developed the Batch and Incremental ETL process i.e., Mappings &Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Worked as a Senior ETL Lead for onsite/offshore model and leading a team
• Participate in test results document preparation for the project
• Participate in bug reporting and tracking for the project
• Technical consultant for the team to provide optimal solutions, design reviews, code reviews and for any issues
• Provided inputs to Project Stakeholders and Data Architects to accomplish the design of the project
• Conducted design and review meetings to get design approval from different stake holders in the project
• Involved in planning, effort tracking and estimations for the project
• Extensively used Sql server Database from source and target.
• Participate in review of test document for the end-to-end testing
• Prepare project status reports for the work carried out
• Collect and reporting metrics on end-to-end testing.
• Scheduled the Informatica Workflows using CA7 scheduler tool
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Experienced in deploying the code into releasing folder and placing it into Build and troubleshooting the build issues.

Confidential

Environment: Informatica8.6,OBIEE,MS.NET, DB2, Oracle10g, UNIX, Detica Front end

Responsibilities:

• Requirement gathering for enhancements.
• Review HLD & LLD documents based on business requirements.
• Supported AML investigation requirements.
• Conducted monitoring of AML exception reports.
• Developing mappings, workflows as per the requirement.
• Handling High priority and criticality incidents.
• Handling work requests and project requests.
• Provided backup liaison with business and IT.
• Understanding the functionality of the application from the business prospective.
• Monitoring and maintaining the scheduled jobs.
• Providing 24x7 support.
• Resolving the issues within the SLA time to avoid business loss.
• Managing critical recovery call.

Confidential

Informatica - Team member

Environment: Informatica Power Center 8.6, SAP-ABAP, SQL, Oracle9i, UNIX, TOAD, PUTTY, EDIT PLUS, HPSD 4.5

Responsibilities:

• Understanding the Business rules completely and implemented data transformation methodologies, Involved in designing the E.T.L mapping documents.
• Involved in the mapping with a slowly changing dimension Type2 to keep track of historical data.
• Involved in developing Mapplets, Mappings and Transformations as per the requirements.
• Extracting data from different relational databases, Flat files using Informatica Power Center.
• Analyzing the issues and resolve with the scheduled time to avoid SLC.
• Creating Various Transformations like Interpreter, Preparer, Expression, Aggregator, Rank, Joiner, Sequence Generator, Lookup, and Update Strategy etc.

Confidential

Informatica-Developer

Environment: Informatica Power center 8.1, SQL Server 2005, UNIX, PUTTY, Service Center 6.5

Responsibilities:

• Understanding the Business rules completely and implementing data transformation methodologies Involved in designing the E.T.L mapping documents.
• Involved developing Mapplets, Mappings and
• Extracting data from different relational databases, Flat files using Informatica Power Center.
• Creating Various Transformations like Expression, Aggregator, Rank, Joiner, Sequence Generator, Lookup, and Update Strategy, etc.

Confidential

Team Member

Environment: Informatica Power Center 8.1, Oracle 8i, Unix, Putty, Toad

Responsibilities:

• Analyzed the existing OLTP system.
• Transforming existing data from Source database to Target database (Oracle).
• Performed data cleansing and transformation using Informatica.
• Developed Mapplets, Mappings and Transformations.
• Scheduled sessions to update the target data using Informatica Workflow Manager.

Confidential

Team Member

Environment: ASP.Net, C#.Net, Server-2000, Tools: SQL Profiler; O/s: Windows-2000

Responsibilities:

• Involved in developing the business logic layer and design the presentation layer.
• Involved in Application maintenance and enhancement.
• Involved in preparing the test cases and test scripts.
• Testing - unit testing
• Representing Weekly & Monthly Client meetings from Offshore.

Confidential

Team Member

Environment: Asp.Net 2.0, C#.Net, Sql Server - 2000, VSS, HTML

Responsibilities:

• Involved in requirement gathering and preparing the document
• Developing the Application Layer and Business logic layer.
• Interaction with the client
• Testing - unit testing