Saikat Das

Experience

• 

  Infosys

  Nov 2018 - Feb 2022

  > PROVIDING SOLUTIONS AND DESIGNS FOR ETL DATA MIGRATION &INTEGRATION BASED ON CLIENT'S NEEDS AND REQUIREMENTS. >STRONG HOLD AND EXPERTISE IN DESIGNING & DEVELOPING SOLUTIONS FOR CLIENTS Like Apple , CISCO, BANK OF AMERICA etc> PROVIDE CONSULTANCY ON ETL DATA MIGRATION AND DATA INTEGRATION SCHEMAS AND DESIGN SPECIFICATIONS. > DRIVE DAILY CALLS AND IN-TAKE CLIENT REQUIREMENTS AS FOLLOWING AGILE METHODOLOGY> USING MAINLY INFORMATICA POWERCENTER, IICS AND SNAPLOGIC TO PERFORM AND DESIGN ETL DATA MIGRATION/INTEGRATION SYSTEMS Show less >Carrying ETL analysis and designing Data Quality Transformations as per business requirements,that help in providing best solutions to the clients demands and needs,using INFORMATICA POWERCENTER and INFORMATICA DATA QUALITY APPLICATION MODELS>Implement design , Development and Validation in line with architecture requirements;>Participate in Knowledge Management activities with the Objective of ensuring highest quality of service offerings to the clients in own TECH DOMAIN within the Guidelines and their business policies Show less

  • Data Engineer/Analyst - TECHNOLOGY ANALYST

    Apr 2021 - Feb 2022

  • DATABASE & ETL Developer - SR. SYSTEMS ENGINEER

    Nov 2018 - Mar 2021
• 

  Apple

  Nov 2018 - Dec 2020

  ORACLE & ETL DEVELOPER - Contingent Worker (Infosys)

  Roles and Responsibilities :➢ Carrying ETL analysis and designing Data Quality Transformations as per business requirements, that help in providing best solutions to the clients demands and needs, using INFORMATICA POWERCENTER and INFORMATICA DATA QUALITY APPLICATION MODELS.➢ Designed Data Models using snowflake schemas in ER STUDIO➢ Spearheaded weekly calls with clients On-site➢ Analysis of Business stories on JIRA and confluence.➢ Building ETL/ELT Scripts using NumPy /Pandas using Python Show less

• 

  Bank of America

  Jan 2021 - Jan 2022

  CLOUD ETL TECHNOLOGY ANALYST - Contigent Worker (Infosys)

  Roles and Responsibilities :➢ Carrying ETL analysis and designing Data Quality Transformations as per business requirements, that help in providing best solutions to the clients demands and needs, using SNAPLOGIC (Renowned Cloud Based ETL TOOL➢ Building POWER BI Reports/Dashboard using DAX Queries via DAX STUDIO, DATA MODELLING, AWS/AZURE LIVE STREAMING SOURCES, XML etc.➢ Worked with AWS S3 Platform as Source using Parquet Files, Buckets etc. and SALESFORCE LIGHTNING as Downstream Target Platform to Verify ETL DATA /PIPE FLOW➢ Analysis of Business stories on JIRA and confluence.➢ Data Validation/Enrichment on SNOWFLAKE DB Show less

• 

  UBS

  Feb 2022 - now

  Data Analyst

  > Design, develop, and implement ETL solutions as well as Dashboards/Dossiers using Python, NumPy, Pandas, Subprocess, SQL Alchemy, Matplotlib, Oracle, Power BI, and MicroStrategy. This includes working with business stakeholders to understand their data needs, designing and developing ETL processes, and testing and deploying ETL solutions.> Maintain and optimize existing ETL solutions. This includes troubleshooting ETL issues, identifying and implementing performance improvements, and updating ETL solutions to accommodate changes in data sources or business requirements.> Document and maintain ETL processes, Bugs, enhancements, backlogs etc and documentation on GitLab. This includes creating and maintaining process documentation, unit tests, and other artifacts.>Developed Generic Python framework to Load files with any delimiter as well as XML files to the Tables in Database, also load UNIX Cmd Outputs to the Database Tables.>Communicating with business stakeholders. This includes explaining complex technical concepts in a clear and concise way, and working with stakeholders to ensure that their needs are met.>Mitigated the business data loss risk by adding checks for the critical batches before delivering data to downstream systems.> Demonstrated strong ability in root cause analysis for data discrepancies and other critical technical issues using SQL analysis and provided solutions with minimum turnaround time.> Owned end-to-end scoping and roll-out of new regulatory reporting framework.> Improved productivity by 30% by introducing agile methodology with scrum Show less