Ashish Tare

Experience

• 

  Rolta India Limited

  Feb 2001 - Feb 2004

  Sr. Production engineer

  Involved in study the project specifications & provide training to project execution staff, communicate with the client for technical problems regarding specifications, Develop PRO*C applications, PL/SQL packages for QA/QC validations/Global updations ,Tuning of application using SQL optimizer.

• 

  Siemens Technology India

  Feb 2004 - Aug 2006

  Sr. System Engineer

  Involved in Business Process Analysis, Design and development database objects, Design and development in Informatica. Involved in all developments in Oracle SQL, PLSQL, stored procedures , views and synonym. Responsible for estimation in Change Management. Develop the data transformation using Informatica powercenter (5.0). Provide operational support in production system.

• 

  Tech Mahindra

  Jan 2007 - Sept 2010

  Tech Lead

  Lead two major areas, support and Enhancement. Involved in Operational Support, Design, Development , Requirement gathering and customer relationship. I was Involved in writing huge Database queries, performance tuning and writing procedure and views in Oracle, Partitions and sub partition creation. Responsible for management activities, handling releases. Responsible for production support and SLA.

• 

  Cognizant

  Sept 2010 - Apr 2018

  Tech Lead / Manager

  Solid experience in developing and design the database object in Oracle and SQL Server 2008 database. Having support & data validation experience in HIVE. Good knowledge in Big Data ecosystem (Apache PIG scripting/Hive/Yarn/HBase/HDFS/Sqoop). Having experience in Design/Develop ETL (Informatica).Involved in writing huge Database queries, performance tuning and writing procedure and views in Oracle. Worked in Materiallized views to provide data to other interfaces. Involved in Development in Informatica and database objects, support, year end activities. Responsible for management activities, handling releases, close coordination in test execution. Show less

• 

  Autodesk

  May 2018 - Oct 2021

  Developed the framework which pulled orders from EDW and Data mart using Informatica powercenter ETL into SQL Server database. Developed the framework for Dimension and Fact tables. Developed the framework to denormalize the Fact tables and modify data as per business requirement.helped in production support and involved in scrum ceremonies like Backlog Refinement, Daily Scrum, Sprint Review, Sprint Retrospective, Sprint Planning. Developed the workflows for pulling data from SalesForce, Anaplan and send to SQL Server database and RedShift database. I also worked on AWS component and data ingestion using Matilion ELT. Show less

  • Principal Engineer

    Sept 2020 - Oct 2021

  • Sr. software developer

    May 2018 - Sept 2020
• 

  HCLTech

  Nov 2021 - Jan 2024

  Tech Lead

  Involved in Data engineering and data quality role. Pulling data from Hive and apply data quality rules in Informatica Data Quality. Gather the requirements from business user and develop the framework for data quality. Deploy the framework in production system.

• 

  Olisipo

  Feb 2024 - now

  Data SQL