Samapika Tripathy

About Samapika Tripathy

Results-oriented IT professional with over 9 years of experience, including 4 years in Data Warehousing and 4+ years in Spark, Hive, Scala, AWS, spring-boot, Java. Proven expertise in developing and implementing data pipelines, designing and developing metric platform solutions with headless BI architecture following microservice architecture, and optimizing data processing workflows. Skilled in Spark architecture, Hadoop ecosystem, Teradata, and SQL, NO SQL(MongoDb, Neo4j), Trino, StarRocks.Key Skills:• Extensive experience in designing data pipelines, application and backend design, business analysis, and requirement gathering.• Accomplished data modelling professional with expertise in GraphDBs( like Neo4j), RDBMS, other NO SQL(Mongodb).• Proficient in designing, building, and deploying microservices.• Proven track record in developing platform solutions including automated data pipeline building, backfill utility services, automated data correction, and providing API endpoints for organization-wide usage.• Successfully developed a robust SQL Generator and SQL parser using Apache Calcite for metric platforms.• Created a SQL adapter library capable of converting queries from one SQL dialect to another using java.• Proficient in Business Intelligence, data warehouse management, data analysis, SDLC, and business process/data flow modelling.• Strong understanding of dimensional star schema and snowflake schema methodologies, implementing SCD type 1 and type 2 dimensions, as well as familiarity with data lake, data mesh, and data swamp concepts.• Well-versed in Agile methodologies, including project management, error handling, troubleshooting, and utilizing log files.• Experienced in importing and exporting data using Sqoop from HDFS/Hive to Relational Database Systems and data pull operations.• Skilled in SQL, HQL, SQL scripting, UNIX shell scripting, Python, Scala, Java, and Spring Boot.• Familiar with Big Data tools such as the Hadoop ecosystem, HDFS, Hive, PySpark, Sqoop, Scala, and Spark.• Proficiency in Teradata 15.

Experience

1. Senior Software Engineer

   Microsoft

   Nov 2023 — Present · Bengaluru, IN

Education

• Indira gandhi institute of technology, sarang, Odisha

  Bachelor of Technology (B.Tech.), Electronics and Telecommunications Engineering

  2009 — 2013

• Govt girls High School Kuchinda

  Matriculation

  2005 — 2007

Skills

• Teradata
• Microsoft Excel
• Teradata Data Warehouse
• Mac Os
• Shell Scripting
• Windows
• Bash
• Teradata Sql
• Tableau
• Unix
• Secure Shell (Ssh)