Summary
Overview
Work History
Education
Skills
Certification
Disclaimer
Timeline
Generic

Sruthi Swarna

Bangalore

Summary

  • Experienced professional with 10 years in development projects, specializing in DBT, Snowflake, IICS, Informatica Power Center, Oracle SQL, Postgres, Teradata, and DWH concepts (OLAP, OLTP, Snowflake schema, Star schema).
  • Proficient in DBT functionalities, including creating YML files, models, macros, and implementing advanced materializations.
  • Well-versed in Snowflake architecture, tables, stages, external tables, tasks, views, and streams.
  • Extensively used ETL methodology for data extraction, transformation, and loading in corporate-wide ETL solutions using Informatica.
  • Strong understanding of business applications, data flow, and data relationships.
  • Skilled in designing and developing mappings using various transformation logic, such as unconnected and connected lookups, router, filter, expression, aggregator, joiner, and update strategy.
  • Experienced in developing test plans, test strategies, and test cases for data warehousing projects to ensure data meets business requirements.
  • Involved in knowledge sharing and transfer to new project members and preparation of knowledge transfer documents.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Specialist- Data Engineering

LTIMindtree
Bangalore
02.2022 - Current
  • Project Overview: Schneider, a leading provider of transportation and logistics services.
  • This project is focused on managing logistics-related data, including orders, shipments, pricing, and offers.
  • The data is gathered from multiple sources, such as on-premise systems (Oracle) and cloud storage (AWS S3), and loaded into Snowflake using the DBT tool.
  • The transformed and migrated data is then utilized for reporting purposes in Tableau.
  • Created an integration object, file formats, stages, and used COPY INTO/Snowpipe to ingest data from the AWS S3 bucket.
  • Migrated the data from the on-premise system (Oracle) to Snowflake using the DBT tool.
  • Created data pipelines and scheduled the DBT process, which pulls files from AWS S3 and incrementally loads the data into Snowflake by transforming semi-structured data.
  • Scheduled DBT jobs using the CAWA application.
  • Expertise in data modeling, optimization, and execution of complex SQL queries.
  • Deploying code into the QA, UAT, and PRD environments through Git version control in DBT.
  • Developed, maintained, and implemented strategic plans for projects.

Application Development Senior Analyst

Accenture Solutions
Bangalore
01.2021 - 01.2022
  • Project Overview: The MVW project aims to move data from disparate systems and applications across the business towers to an integrated solution to support the Marketing, Sales, and Owner Services businesses.
  • Understanding the existing business model and client requirements.
  • As a developer, I developed various Informatica mappings, mapping tasks, and task flows for the migration of data from various existing systems to Postgres to integrate the data into Salesforce using IICS data integration.
  • Migrated the multiple components of Salesforce data from one org (Adapt) to another Salesforce org (MVWVO) using IICS data integration and Postgres.
  • Tested the Informatica mappings built on all scenarios, ensuring the delivery quality to be 100% correct.
  • Prepared all the required design documents, and other pre-deployment documents for deployment.

Associate

Cognizant Technology Solutions
Bangalore
09.2019 - 01.2021
  • Project Overview: The IHG project aims to handle all booking-related information.
  • All the bookings from different sources, such as CRO, PMs, and Agents, are being loaded into the TD tables in a very organized manner, into different table structures under different databases.
  • Involved in communicating with the client to understand business requirements received in the form of STMs.
  • Worked on enhancing and creating new mappings and workflows.
  • Created new BTEQ scripts and shell scripts, which are being called in CA applications or workflows for processing as designed.
  • Involved in performing ad-hoc change requests for different applications involved.
  • Unit testing the stories, and migrating to a higher environment.
  • Acquired good knowledge in creating and scheduling a wide range of CAWA applications.
  • I worked extensively with the ETL Support team in migrating the codes to production.

Senior Systems Engineer

Infosys Technology Limited
Bangalore
11.2014 - 08.2019
  • Project Overview: CVS is a major pharmacy business management giant based in the U.S. It deals with pharmacy claims, subsidized medication drugs, by linking the supplier (drug manufacturers) to the consumers (subscribed members).
  • Interacted with end users in gathering the requirements and documenting the requirements.
  • Create a high-level design document, and organize a design review meeting with the onsite team.
  • Developing Informatica mappings, workflows, and Teradata BTEQ scripts with required validations.
  • Involved in unit testing, integration testing.
  • Implementing the project, and providing production warranty support.

Senior Systems Engineer

Infosys Technology Limited
Bangalore
11.2014 - 08.2019
  • Project Overview: Geo Expansions is a long-running project at Apple, which includes the setup of new companies for Apple around the globe.
  • Once the setup for the new company is completed, we maintain the master and transactional data related to Apple products.
  • Understanding the specification and business requirements.
  • Preparing high and detailed design documents.
  • Developing and enhancing Informatica setups and Teradata procedures.
  • Involved in unit testing, integration testing
  • Implementing the project, and providing production warranty support.

Education

B. Tech - Biotechnology

Sreenidhi Institute of Science And Technology
Hyderabad
06-2013

Skills

Data Transformation Tools

DBT (Data Build Tool), IICS, Informatica PowerCenter

Languages

SQL, Unix scripting

Database

Snowflake, Postgres, Teradata, SQL, Oracle SQL

Job Scheduling

CAWA, Control – M, Autosys

Certification

  • SnowPro Core Certification (05/2024 - 05/2026).
  • AWS Certified Cloud Practitioner Certification (09/2024 – 09/2027)

Disclaimer

I hereby declare that the information furnished about is true to the best of my Knowledge and belief.

Timeline

Senior Specialist- Data Engineering

LTIMindtree
02.2022 - Current

Application Development Senior Analyst

Accenture Solutions
01.2021 - 01.2022

Associate

Cognizant Technology Solutions
09.2019 - 01.2021

Senior Systems Engineer

Infosys Technology Limited
11.2014 - 08.2019

Senior Systems Engineer

Infosys Technology Limited
11.2014 - 08.2019

B. Tech - Biotechnology

Sreenidhi Institute of Science And Technology

Similar Profiles

CREATE PROFILE
Sruthi Swarna