In this pivotal role, I spearheaded the development and operationalisation of sophisticated ETL pipelines leveraging a cutting-edge tech stack comprising AWS Elastic Container Registry (ECR) for Docker container management, AWS Batch for efficient job scheduling and execution, PySpark for big data processing running inside Docker , AWS S3 for scalable storage, AWS Redshift for data warehousing, and Apache Airflow for orchestrating complex workflows also running inside Docker by consuming the data from Workday SOAP API and Salesforce REST API.