Working on EDW transformation project It is purely migration project from Teradata to GCP BigQuery.Responsibilities:• Contributed to developing queries, transferring and transforming data from Teradata to BigQuery. • Developed data pipelines, ensuring data quality and implementing ETL processes for smooth data migration and deployment across systems.• Optimized SQL queries and data warehouse databases and documented data pipelines and Data Transfer processes, and conducted performance testing which increased database efficiency by 38%.• Communicated effectively with developers and business stakeholders to translate business needs into actionable data solutions resulting in 90% increase.• Reviewed and fixed 35% critical bugs to enhance existing data pipelines, stored procedures resulting the increase of accuracy and query performance.