Domain:Banking• ETL Tools: Informatica PowerCenter• Big Data: Hadoop, Hive, Spark with Scala• Languages: Unix/Linux Shell Script, SQL• DB: Oracle

Domain: Banking with FSLDM• ETL Tools: Informatica PowerCenter• Big Data: Hadoop, Hive, Impala, Sqoop• Languages: Unix/Linux Shell Script, SQL• DB: Teradata, Oracle

● Domain : Travel and Hospitality ● Client : Inter Continental Hotel Groups● Analyze and design functionality changes and scheduling changes of the existing systems and process according to major releases.● Understand Business requirements and impact analysis ● Develop Teradata BTEQ, M-Load, T-pump, Fast Load, TPT, Informatica Power Center mappings, sessions, workflows, UNIX scripts, Oracle PL/SQL stored procedures, CA7 jobs● SQL/Informatica performance optimization.● Deployment of ETL components in Production & initial workload monitoring● Preparation of Detailed Design document, CMR document and UTC and UTL

● Domain: Banking ● Client : PNC Financial Services● Design and develop of ETL components & workload monitoring● Source to Staging Data migration.● Power Exchange data map Creation to read the mainframe files directly from the mainframe server.● SQL/Informatica performance optimization.● Preparation of unit test case scenarios & Unit testing.● Post Development Activities such as code check in to Harvest and from there migrate to TEST/QA repositories.● Production Turnover Management.● Downstream Issue analysis & resolution.● Prepare Project Estimates● Identifying scope of performance improvements in existing code.● Assignment & coordination of work among onshore & offshore team.

● Performing high quality research and effective implementation and rectification of engineering problems which can be useful for professional life in future