Prem Singh

Experience

• 

  Tata Consultancy Services

  Mar 2022 - now

  ETL/DWH Analyst

  • Collaborated with business and BI teams to understand and document requirements.• Analyse data to convert functional requirements into technical solutions and developed business solutionsfor commercial organizations.• Possess critical attention to detail and expertise in database development Teradata and SQL optimization.• Build scalable custom ETL solutions using Informatica Powercenter and re-engineer existing solutions to scalable solutions.• Design and build Data Warehouse and Data Mart solutions.• Worked with Dimensional Modelling and maintain dimensions using Slowly Changing Dimensions (SCD).• Identified and assessed errors using job monitor tool and helped in the resolution. Show less