Soumodeep Dey

Experience

• 

  Datametica Solutions Private Limited

  Oct 2021 - Aug 2023

  - Created end-to-end lineage for Informatica jobs/tables/Views/Procs/Scripts which were part of the Migration.- Expert in implementing complex Informatica transformations into Bigquery.- Good hands-on in handling code through composer DAG and Airflow.- Handled all the different changes through Jira and documented the design in confluence.- Closely collaborated with project members and clients to identify bugs and quickly address problems.- Hands-on experience with Scheduling tools like Control M, Composer, Crontab, etc.; we used these tools to schedule jobs and scripts during our testing and Prod deployment.- Scheduling and monitoring end-to-end daily load Informatica jobs in GCP composer. Show less - Involved in End-to-End testing for Dags in Airflow.- Experience in ETL Methodology for Supporting data extraction and testing in BI applications.- Experience in Software Development Life cycles like debugging, testing, maintenance, and designing.- Optimizing SQL queries for Tableau dashboards to improve performance – Performance tuning.- Involved in resolving post-production incidents and explained the technical/functional things related to the project.- Taking ownership of different modules and deploying them to PROD before ETA. Show less

  • Engineer 1

    Apr 2023 - Aug 2023

  • Associate Engineer

    Oct 2021 - Apr 2023
• 

  Smartavya Analytica Private Limited

  Aug 2023 - Sept 2024

  Engineer 1

  - Involved in the initial assessment and requirement gathering for different modules that need to be migrated from Greenplum to Hadoop.- Done the ODBC driver set-up in the Informatica server to connect to Hadoop.- Closely collaborated with project members and clients to plan the DWH migration activity.- Done the history sync-up activity for whole GP tables.- Scheduling and monitoring end-to-end daily load tables through crontab.

• 

  Onix

  Sept 2024 - now

  Cloud Engineer