Ambar Chatterjee

Ambar Chatterjee Email and Phone Number

Data Engineer @ EY | GCP & AWS & Azure & Snowflake Certified Data Engineer | Ex-TCS @ EY
london, greater london, united kingdom
Ambar Chatterjee's Location
Greater Kolkata Area, India
About Ambar Chatterjee

With a robust background in data engineering and a specialization in designing and developing data pipelines, I bring three years of experience from Tata Consultancy Services (TCS) and my current role as a Data Engineer at EY to the forefront of technology and data solutions.I am a Google Cloud Certified Professional Data Engineer, an AWS Certified Data Engineer – Associate, a Microsoft Certified: Azure Data Engineer Associate, and a Snowflake SnowPro Core Certified Professional. These certifications underscore my ability to create, manage, and optimize data processing systems and pipelines, ensuring data is accessible and actionable for business intelligence and decision-making processes. My expertise includes the design, deployment, and maintenance of scalable data architectures, as well as monitoring and securing data workflows to meet stringent compliance and business requirements.Additionally, I hold an IBM Data Science Professional Certificate, equipping me with the skills to tackle real-world data science problems using advanced analytical tools and methodologies. This certification has enhanced my ability to apply machine learning models and data science techniques to analyze and interpret complex datasets, providing actionable insights and supporting strategic decision-making processes.My skill set includes:- Database & Data Warehouse: Teradata- Big Data Frameworks: Apache Airflow, Apache Kafka, Apache Spark- Programming & Scripting: Python, SQL, R, Bash Shell scripting, JCL, COBOL, Java- Business Analytics & Tools: IBM Cognos Analytics, Power BI, Power Query, MicroStrategy- Big Data & ETL: Expertise in managing big data solutions and ETL processes- Cloud Platforms & Native Services: - AWS: S3, Redshift, Lambda, Glue, EMR, Kinesis, Athena, DynamoDB - GCP: BigQuery, Dataflow, Dataproc, Cloud Storage, Pub/Sub, Dataprep, Composer - Azure: Azure Data Factory, Synapse Analytics, Blob Storage, Event Hubs, Data Lake Storage, Stream Analytics, Databricks - IBM Cloud: Db2 Warehouse, Watson Studio - Snowflake- Generative AI & Machine Learning: Deep learning, Large Language Models (LLMs), Prompt Engineering- Version Control & Testing: GitHub, Selenium, Postman API- Service Management: ServiceNowI am passionate about leveraging my technical skills and industry certifications to help organizations transform their data into a valuable asset that not only supports but also accelerates their strategic objectives. Let's connect to explore how we can drive your organization's data strategy forward.

Ambar Chatterjee's Current Company Details
EY
Data Engineer @ EY | GCP & AWS & Azure & Snowflake Certified Data Engineer | Ex-TCS
london, greater london, united kingdom
Website:
ey.com
Employees:
296502
Ambar Chatterjee Work Experience Details
  • Ey
    Senior Analyst: Data Engineer
    Ey Aug 2024 - Present
    Kolkata, West Bengal, India
    Worked on data engineering and governance projects to streamline workflows and improve data accessibility.- AI-Driven Automation: Automated Pentaho (.ktr & .kjb) logic documentation using OpenAI GPT-4, generating PySpark code and Cloud Composer workflows for deployment.- Data Governance Implementation: Designed and implemented a centralized data governance platform using Alation, enabling end-to-end data lineage, metadata management, and improved collaboration.
  • Tata Consultancy Services
    Data Engineer
    Tata Consultancy Services Jan 2021 - Aug 2023
    Kolkata, West Bengal, India
    ETL Design and Development:- ETL Components: Designed ETL components across Teradata, Mainframe, GCP, AWS, and Azure, enhancing data warehousing.- Data Pipelines: Managed scalable data pipelines with Apache Airflow and Kafka for reliable integration. Data Engineering and Science Expertise:- Scalable Architectures: Developed scalable data architectures using Apache Spark, ensuring compliance and efficiency.- Workflow Monitoring: Implemented monitoring and security with AWS CloudWatch and Azure Monitor to protect data integrity.- Machine Learning: Used Python and R for machine learning and data science to provide strategic insights. State Analysis and PoC Testing:- Current State Analysis: Analyzed data processes with Power BI and MicroStrategy to optimize performance.- PoC Testing: Conducted PoC testing on GCP and Azure to demonstrate solution feasibility. Production Support and Issue Resolution:- EDW and MicroStrategy: Supported EDW and MicroStrategy issues, ensuring operational efficiency.- Mainframe, Teradata, DB2: Resolved issues in Mainframe, Teradata, and DB2 to maintain stability.- Report Analysis: Fixed report discrepancies in Teradata with advanced SQL for accuracy. Additional Skills:- Programming: Proficient in Python, SQL, Bash, JCL, COBOL, and Java.- Cloud Services: Skilled in AWS S3, Redshift, Lambda; GCP BigQuery, Dataflow; Azure Synapse, Data Lake.- Version Control & Testing: Used GitHub, Selenium, and Postman for testing.- Service Management: Managed support with ServiceNow for efficient issue resolution.
  • Sarangsoft
    Data Science Intern
    Sarangsoft May 2019 - Jun 2019
    Kolkata, West Bengal, India
    - Data Cleaning and Exploration: Utilized Pandas and NumPy to clean and explore Indian state-wise election results data, ensuring high data quality and reliability.- Data Visualization: Created insightful visualizations using Matplotlib and Seaborn to highlight trends and patterns.- Final Report: Submitted a comprehensive report with actionable insights, supporting strategic decision-making.- Additional Skills: Applied machine learning models with Python, and managed version control with GitHub.

Ambar Chatterjee Education Details

Frequently Asked Questions about Ambar Chatterjee

What company does Ambar Chatterjee work for?

Ambar Chatterjee works for Ey

What is Ambar Chatterjee's role at the current company?

Ambar Chatterjee's current role is Data Engineer @ EY | GCP & AWS & Azure & Snowflake Certified Data Engineer | Ex-TCS.

What schools did Ambar Chatterjee attend?

Ambar Chatterjee attended Sapienza Università Di Roma, University Of Engineering & Management (Uem), Dolna Day School, Dolna Day School.

Who are Ambar Chatterjee's colleagues?

Ambar Chatterjee's colleagues are Vicky O., Maggy Anastasia Suryanto, Yuejia Sun, Julia Meindl, Sandra Shajan, Prerana Bisht, Yin Ki Ho.

Not the Ambar Chatterjee you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.