Neha Sharma

Neha Sharma

Etl Developer

Followers of Neha Sharma748 followers
location of Neha SharmaPune, Maharashtra, India

Connect with Neha Sharma to Send Message

Connect

Connect with Neha Sharma to Send Message

Connect
  • Timeline

  • About me

    Tech Lead Data Architect | Informatica | ETL | SSIS | DB2 | SQL | Oracle 11g | Unix | Snowflake

  • Education

    • RGTU BHOPAL

      2008 - 2012
      Bachelor's degree Electrical, Electronic and Communications Engineering Technology/Technician

      Activities and Societies: Debate Team, Robotics, Sanrakshna. BE-2012Electronic & Communication73%

    • Ideal School Bhopal

      2007 - 2008
      HSC Mathmatics 72%

      Activities and Societies: Debate Team, Dancing, quiz, Singing

    • Ideal School Bhopal

      2005 - 2006
      SSC All 74%

      Activities and Societies: Debate Team, Dancing, quiz, Singing.

  • Experience

    • Tata Consultancy Services

      Mar 2013 - Apr 2017
      Etl Developer

      Understanding the complete Process of ICRS data model• Understand upstream and downstream applications of ETL to determine and automate dependencies.• Involved in requirement gathering.• Involved in Creation of Understanding document.• Responsible for Creation of Design and Mapping specification Document• Responsible for ETL Development to extract, transform, and distribute data across one or more data stores from a wide variety of sources and Database Script• Involved in Unit Testing, Integration Testing and Application Testing• Involved in Data Loading• Run the loads during SIT and UAT time.• Monitor the loads and send the weekly status report with the time taken by each session.• Writing unit tests and log defects during development.• Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs.• Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment. • Expertise in debugging the mappings.• Maintain the code versioning in SVN and update CM instructions accordingly and supporting the deployments.• Participated in Daily Client meetings and status updates.• Responsible for Pre/Post Implementation and Support activity Show less

    • Fiserv

      Apr 2017 - Dec 2022

      Understand the complete Process of Assurant (TWG) data model.• Understand multiple data source system and destination system• Understand upstream and downstream applications of ETL to determine and automate dependencies.• Participating in the design calls.• Involved in requirement gathering.• Involved in Creation of Understanding document.• Responsible for Creation of Design and Mapping specification Document• Responsible for ETL Development to extract, transform, and distribute data across one or more data stores from a wide variety of sources and Database Script• Involved in Unit Testing, Integration Testing and Application Testing• Involved in Data Loading• Run the loads during SIT and UAT, so that the data available for testers.• Monitor the loads and send the weekly status report with the time taken by each session.• Writing unit tests and test result and log defects during development.• Coordinate with the source and target systems to make sure the data flowing accurately.• Provide problem-solving expertise and complex analysis of data to develop business intelligence integration designs.• Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment. • Performance tuning of mappings, SQL queries and sessions (session partitioning) to optimize session performance.• Worked on variable assignment concept to pass the mapping parameters/variables to worklets and workflows.• Mapping data, establishing interfaces, developing and modifying functions, programs, routines, and stored procedures to export, transform and load data and meeting performance parameters, resolving and escalating integration issues.• Expertise in debugging the mappings.• Maintain the code versioning in SVN and update CM instructions accordingly and supporting the deployments.• Participated in Daily Client meetings and status updates.• Responsible for Pre/Post Implementation and Support activity Show less

      • ETL Developer

        Apr 2017 - Dec 2022
      • Tech Lead Data Architect

        Apr 2017 - Dec 2022
    • Infinite Computer Solutions

      Dec 2022 - now
      Senior Technical Lead

      Understand the complete Process of Assurant Rating Engine.• Understand multiple data source system and destination system• Involved in requirement gathering and in impact analysis.• Involved in SQL programming• Responsible for creating complex T- SQL queries, views and stored procedure• Responsible for writing code with various logic like upsert/merge, dynamic SQL, CTE, temp table, table variables etc.• Debugging and error handling in SP’s• Involved in Unit Testing, Integration Testing and Application Testing• Coordinate with the source and target systems to make sure the rates are showing accurately.• Provide problem-solving expertise and complex analysis of data for any production issues.• Performance tuning of SQL queries to optimize the performance.• Using Azure DevOps for maintaining for work items, user stories for every release.• Participated in Daily Client meetings and status updates.• Responsible for Pre/Post Implementation and Support activity Show less

  • Licenses & Certifications

    • Oracle data expert

      Apr 2015
    • Snowflake

      Udemy
    • Data integration guide

      Udemy