Nikita Kapoor

Experience

• 

  Wipro

  Jun 2013 - Jun 2016

  Project Engineer

  •Requirement Analysis and preparing technical specification documents and data flow diagrams.•Responsible for ETL development , maintenance and scheduling ETL processes using Informatica Power Center, Oracle SQL, PL/SQL.• Responsible for tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets and mappings•Coordinating with client for support and providing Weekly Status Reports for enhancing customer relations•Effective Unit testing to ensure successful execution of data.• Developing complex SQL queries, unions and multiple table joins.•Experience in database programming in PL/SQL and knowledge of UNIX.•Providing support and perform root cause analysis during the User Acceptance phase and quickly resolving production issues. Show less

• 

  Deloitte

  Jun 2016 - Aug 2017

  Business Analyst

   Extensive experience in Data Warehousing, ETL design, development and maintenance using Informatica Power Center, Pentaho ETL (Kettle), Greenplum, Oracle SQL and UNIX. Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views and also having knowledge of database programming in PL/SQL. Exposure to work with Analytics & reporting tool like Pentaho. Efficient at mapping the requirements, analyzing data and resolving performance bottlenecks for ETL processes. Proficient communication skills and ability to adapt to build strong working relationships with coworkers and management. Show less

• 

  S&P Global

  Aug 2017 - now

  Senior Software Engineer