SUMMARY

• Having 13+ Years of strong IT experience with Data Warehousing in various areas like Application Development, Enhancement, Maintenance & Support, Application Management and Implementation.
• Having good experience in Informatica cloud (IICS,ICRT)integration with Salesforce, AWS(Redshift,S3) and other third party applications.
• Configure Vendor web services with services and processes through ICRT to SOAP and REST best solution
• Strong data warehousing ETL experience using Informatica Cloud/10.2/9.x/8.x Power Center client tool.
• Worked with different data bases such asOracle,SQL Server,Teradata,DB2,SAP,Flat files, HDFS etc..
• Having good experience in writing UNIX Shell scripting, 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 the application.
• 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.
• Exposure on Hadoop ecosystems like HDFS, HIVE,PIG,Impala, MR, SQOOP and RDBMS.
• Good exposure in project estimation, preparing BRD, FRD, Technical specs, project documentation.
• Strong domain experience in Banking Domain ( AML,RISK,CCAR) applications, Healthcare
• Good experience in handling AML/FRAUD applications like ACTIMIZE, CASE MANAGEMENT tools,
• 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 CLOUD (IICS,ICRT), Power Centre 8x,9x, 10.2, OBIEEBigdata Hadoop-HIVE,Impala,Sqoop,HUE,HDFS

Data Modeling Tools: ERWin, TOAD Data Modeler

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, XMLServer WAS, IIS, MOSS

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

ETL Technical Lead

Environment: Informatica-Cloud(IICS/ICRT),Powercenter -10.2, salesforce, AWS(Redshift,S3), Hadoop-Hive, OFSAAI,UNIX,CA-7,NDM,ORACLE,OFSAAI

Responsibilities:

• Worked with Assignment step, create step, jump step and data decision step, Service call step, sub process… in ICRT.
• Integrating AWS - Redshift data base with on-premise databases
• Integrating AWS- S3 unstructured data with RDBS database
• Created service connectors in ICRT to run the ICRT process through REST API.
• Worked with process objects to process multiple records in a Realtime process
• Implemented salesforce Out Bounding Messaging concepts in both ICS and ICRT to process the data in real time.
• Created Custom Profiles, Public Groups and Roles to distribute user rights and functionality.
• Created and customized Record types, page layouts, list views managed Role hierarchies and Profiles
• Developed UNIX scripts to handle source files.
• Involved in low-level design and developed various jobs and performed data loads and transformations using different transformation of INFORMATICA.
• Project estimation and project design as per business requirements
• Managing the team and providing technical solution.
• Managing migration projects from lower informatica version to latest version
• Worked with theSalesforce, People Soft, Service Now, flat files, xml files.
• Developed incremental load logic in Informactica Cloud based on CDC.
• Used most of the transformations such as Source Qualifier, Java Transformation, Trancation Commit,Filter, Joiner, Sequence Generator, Expression, Aggregator, Lookup, Rank, Router, and Update Strategy, SQL Transformation, etc.
• 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 Workflow, Mapping deployment by using deployment group from Dev to UAT and UAT to Quality and production Repositories.

Confidential, McLean, VA

ETL Tech Lead

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

Responsibilities:

• Creating inforamatica mappings as per business requirements. developing SCD type 2, type 1 mappings using informatica.
• Loading DB2 Dimension data into ParAccel Database as per BRS
• 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.

Confidential

ETL Technical Lead

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

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.
• Developed AUTOSYS JIL scripts to manage informatica workflow jobs
• 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

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.