Ambar Chatterjee Email and Phone Number
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.
-
Senior Analyst: Data EngineerEy Aug 2024 - PresentKolkata, West Bengal, IndiaWorked 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. -
Data EngineerTata Consultancy Services Jan 2021 - Aug 2023Kolkata, West Bengal, IndiaETL 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. -
Data Science InternSarangsoft May 2019 - Jun 2019Kolkata, 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
-
Data Science -
Dolna Day School90.5% -
Dolna Day School91.6%
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?
-
-
-
-
4opentext.com, emcpower.com, yahoo.com, microsoft.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial