Mohammad Anas Khan Email & Phone Number

AWS Data Engineer at Tata Consultancy Services, I work with a variety of technologies to help clients manage their data effectively. In addition, I have experience working with Snowflake DB, Oracle DB, SFTP, WinSCP, MS SQL Server, and MySQL. I also have experience using Talend ETL tool to create efficient and effective ETL solutions for clients. By leveraging these technologies, I am able to help clients optimize their data management processes and improve their overall business operations.

• 

  Aws Data Engineer

  Tata Consultancy Services

  Aug 2022 - Present - Lucerna

  • 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.