Project roles/responsibilities:

• • Coordinating with client for requirement gathering.
  • Development of ETL interfaces, SQL blocks and unix scripts for data movement.
  • Enhancement of existing ETL jobs.
  • Creating test case for ETL scripts and SQL queries.
  • Deploying the code in production and scheduling as per requirements.
  • Creating SQL queries for data validation and tuning SQL performance.
  • Code migration from environment to other following best practices.
  • Providing L2 support for the datawarehouse and fixing issue passed by L1 support team.
  • Following Etl best practices, methodologies and other recommendations.
  • Creating Design document, Test case document as per standard followed in the project.
  • Technologies used is Talend, Informatica, Unix, Oracle 12c, TAC.

• • Meeting with client to understand the requirements.
  • Creating project plan, roadmaps, performing feasibility analysis for new interface, providing the estimates to client.
  • Leading team of 10 associates.
  • Responsible for project progress tracking and involved in migration tasks for proper delivery.
  • Coordinating with onshore team business team for requirement gathering.
  • Development of informatica interfaces, SQL code blocks and unix scripts for data movement.
  • Modified existing ETL scripts to fix defects at root cause as enhancement part of project.
  • Performing unit testing, end to end integration testing for ETL scripts.
  • Analyzing the existing workflow and tuning their performance.
  • Providing suggestions for existing bugs and fixing them.

Technology used is Informatica, Oracle 12c, Unix, HP-ALM

Banking reconciliation – Data store created for American multinational conglomerate company by integrating banks and third parties for reconciling financial transactions.

Project roles/responsibilities:

• Coordination with client for requirements specifications.
• Enhancing and developing Talend interfaces, PLSQL code for data movement.
• Providing L2 support for the project by resolving talend issue and reported data issues.
• Ensuring the daily data ingestion is completed without any issues.
• Managing team of 4 members.
• Technologies used is Talend Studio for Big Data , MS-SQL server, VBA, TAC, Unix.