PROFESSIONAL SUMMARY:

• 11+ years of progressing IT experience in Data Warehouse and Data Integration Solution using Informatica, Oracle and Hadoop.
• Extensively worked on Informatica Power Center Components - Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Workflow Designer and Repository Manager.
• Strong experience in Performance Tuning of Informatica components and troubleshooting on-going maintenance issues by analyzing session logs.
• Proficient in writing, tuning Complex SQL queries as well as effectively making use of Indexes, Table Partitioning and Materialized View.
• Thorough understanding of Hadoop 2.0 Architecture and working knowledge of Hive and Sqoop.
• Hands-on experience in writing UNIX shell scripts and Python scripts.
• Experience on columnar database Vertica and BI Reporting tools TABLEAU, Power BI.
• Solid understanding of software development life cycle (SDLC) processes including requirements gathering, analysis and design, application development, unit testing, deployment management, version control and release planning.
• Experience on working with Agile methodologies and participating in Scrum Meetings, Sprint Planning and Backlog sessions.
• Strong business understanding of verticals like Investment Banking, Manufacturing and Health care.

TECHNOLOGY USED:

OS: MS Windows, IBM AIX, Sun Solaris (10, 9), RHEL (6, 5, 4)

RDBMS/Tools: Informatica Power Center (9.1.0, 8.1.1, 7.1.1), Oracle DB(11g,10g, 9i), Vertica, Datastage 8.1, Sybase, Teradata, SQL server, Tableau 9.3, Hadoop, Hive, Sqoop, Tidal

Languages: SQL, Shell Programming, Java, Python, PL/SQL, XML

WORK EXPERIENCE:

Confidential, Mountain View, CA

Responsibilities:

• Worked on data loading from heterogeneous source system into Hadoop system, Vertica and Oracle.
• Developed script to automate the job and scheduled it for daily/weekly run.
• Created Hive scripts for end user requirements to perform ad hoc analysis.

Environment: Vertica, Hadoop, Hive, Python, Tidal, Informatica, Oracle

Confidential

Responsibilities:

• Developed data warehouse for in-house applications DAC to create a comprehensive view of Derivatives, Index and risk data.
• Developed Informatica transformations, mapplets, mappings, reusable sessions and workflows.
• Performance tuning at Informatica and Database level to increase data throughput.
• Followed Informatica best practices, such as creating shared objects for reusability and using standard naming convention of ETL objects.
• Worked on setting up Development and SIT environments.
• Worked on POC project to compare the performance of Hive query as compared to Oracle SQL.

Environment: Informatica Power Center 9.1.0, Solaris10, Oracle11g, Sybase, Hadoop, Hive, Sqoop

Confidential

Responsibilities:

• Developed data warehouse for in-house application Client MI to show a comparative view of client revenue, RWA, wallet share, deal pipeline etc.
• Evaluated business requirements to come up with Informatica mapping design that adhered to Informatica standards.
• Understood source system behavior and created logic to consume it into the data warehouse.
• Developed ETL components to load data into enterprise and presentation layer.
• Created SQL scripts and ETL workflows to load historical records in the data warehouse.
• Integrated ETL components into the daily batch process and scheduled it to run every day.

Environment: Informatica Power Center 9.1.0, 8.1.1, Solaris10, Oracle 11g, SQL server

Confidential

Responsibilities:

• Developed Data mart for risk management product to analyze risk in credit card, home, auto and personal loan.
• Created Low-Level and High-Level Design of data warehouse components.
• Created ETL components to clean data and populate it into fact and dimension tables.

Environment: Informatica Power Center 8.1.1, Datastage 8.1, Oracle 10g, Teradata

Confidential

Responsibilities:

• Worked in globalizing application and database by migrating data into the global system.
• Analyzed legacy system and created Data Migration tool to be implemented at different sites.
• Created Informatica components, PL/SQL and shell scripts considering critical factors like reusability, flexibility, effort and time.
• Created checklist for source code review based on delivery standards.
• Developed testing strategy, created test cases, test data and performed unit testing

Environment: Informatica Power Center 8.1.1, RHEL 3, Oracle database 10g

Confidential

Responsibilities:

• Developed an interface to load data from legacy system to reporting database.
• Analyzed several approaches (using Informatica, PL/SQL and Materialized View) to develop an interface based on performance, effort and maintainability.
• Developed and tested the code with features like scheduling workflow, success/failure mail.

Environment: Informatica Power Center 8.1.1, RHEL 3, Oracle database 10g

Confidential

Responsibilities:

• Worked on Integrating Factory Planner (I2 product) with Hitachi legacy system.
• Created Informatica components and Oracle PL/SQL Code for BOM, Inventory and Part master.
• Created test cases, test data and performed testing for SIT, UAT and Regression.
• Performed administrative tasks like taking backups of Informatica mappings, folder management of Informatica repository etc.
• Created operational manual, knowledge transfer document and supported application after Production go live.

Environment: Informatica Power Center 7.1.1, Oracle database 10g, IBM AIX

Confidential

Responsibilities:

• Created procedures, functions, cursors and triggers
• Performed administrative tasks like creating tablespaces, roles, users and granting privileges.
• Created database start up, shutdown and backup scripts.
• Developed a project tracking system to track projects and employee details using Java, HTML and DB2.

Environment: Solaris (8,9), Informatica 7.1.1, Oracle Database (9i, 10g), Java, HTML, DB2