Adhyayan Srijan

Experience

• 

  DMI Finance Private Limited

  Jun 2021 - Oct 2022

  1.Data Warehousing -->(complete development,testing,deployment and maintenance of AWS Redshift data warehouse implementing SCD2 and SCD1 architecture taking MySQL,MongoDB,Oracle Db,Salesforce as OLTP source using languages python/pySpark and using AWS services glue,lambda,S3,EC2 to deploy the pipelines used to ETL data from databases to data-warehouse ,that helped in making Redshift as the core OLAP environment of the organization on which various dashboards,reports,ML-Models are dependent.)2.Data Pipelines --> (complete development,testing,deployment and maintenance of various ETL and ELT data pipelines integrating 3rd party APIs with production databases and data-warehouse or integrating OLTP to OLAP systems using languages python/pyspark/sql/pgsql deployed on AWS services Glue,lambda,EMR,EC2,S3 to cater business requirements)3.Development of serverless database-->(development and deployment of fully automated datapipelines to create a serverless database on AWS Athena using Salesforce as the data extraction source to upload the file in AWS S3 in parquet format and to further use it to insert/upsert/update data into the tables. Show less

  • Senior Software Engineer

    Mar 2022 - Oct 2022

  • Software Engineer

    Jun 2021 - Mar 2022
• 

  Thoughtworks

  Oct 2022 - now

  Data Engineer