Mohammad Anas Khan

About Mohammad Anas Khan

3.5 Years of Experience as AWS Data E•••••••@TCS.Skills: AWS, Python, SQL, Pyspark, ETL/ELT, Database Migrations.Tools Used: Databricks, GitHub, CI/CD, Terraform, SonarQube.

Experience

1. Aws Data Engineer

   Tata Consultancy Services

   Aug 2022 — Present

   I contributed to a Pricing Application by migrating Talend ETL interfaces to native AWS Python jobs. This involved designing ETL data pipelines that utilized the hdbcli Python module to extract data from SAP HANA Views, perform transformations, and load the data into AWS S3 buckets within a data lake in CSV format.• Subsequently, I utilized the boto3 Python module to download these CSV files and performed upsert operations into OracleDB Views. This process ensured seamless integration and synchronization of data across different platforms.• To streamline deployment and management, I orchestrated the deployment of these Python jobs to AWS Glue and AWS Lambda using Terraform scripts and CI/CD pipelines on both GitHub and GitLab, I primarily utilized GitLab for operational execution.• For scheduling and orchestration of these jobs, I utilized AWS Step Functions and configured EventBridge rules with cron expressions.• I met the deadline, allowing the customer to migrate their Talend ETL Interface to AWS Native before their million-dollar Talend Open Studio licenses were due for renewal.

Education

• New Era Academy

  Business/Commerce, General

• New Era Academy

  High School Diploma, Commerce

• CHANDIGARH UNIVERSITY

  Master of Computer Applications - MCA, Computer Science

• Maharaja Agrasen Institute of Management & Technology

  Bachelor of Computer Applications, Computer Science