Gayathri T
Bengaluru
Summary
3+ years of experience as a Database Developer in Analysis, Design and implementation of Business Application using Relational Database Management System and data warehousing. Experience in Data Warehousing applications, which includes Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse. Result-oriented with strong problem-solving, analytical, debugging, and decision-making skills.
Overview
4
4
years of professional experience
Work History
Senior Data Engineer
Affine analytics Private limited
Bengaluru
06.2021 - Current
- Responsible for performing SQL development and SSIS development
- Involved in analysis, design and development, validation, and unit testing for workflow
- Data load from the Source servers to create the Facts and Dimensions tables as per the business logic
- Involved in modifying various existing procedures according to the changing business needs
- Requirement gathering and responsible for all client communications
- Experience in creating the tables, Views and stored procedures and Writing SQL Queries using Joins, Sub Queries to retrieve data from the database
- Expert in performing DDL/DDM/DCL commands using SQL server management studio
- Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views
- Created the whole documentation of packages and wrote Unit Test Cases and rendered unit test results
- Experienced in data modeling technique employing data warehousing concepts like star/snowflake schema and developing database schema like star schema and Snowflake schema (Fact tables, Dimension tables) used in relational, dimensional, and multidimensional modeling
- Coordinated Releases and Hotfixes
- Implemented the ETL Packages with full load as well as the incremental load as per the business rules
- Worked with various Transformations like Lookup, Derive Column, Merge, Sort, Multicast, Conditional Split, &Tasks Data Flow Task, Execute SQL Task
- Implemented Error Handling/ debugging the packages with Data Viewers, Break points, Event Handlers and Configure Error Output
- Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds
- Designed SSIS packages to load data from different sources Text files, Excel, Oracle, DB2 to staging and staging to Data warehouse
- Developed Azure data factory Pipelines for moving data from on premises to Data Lake storage based upon incremental data load process
- Designed Azure ADF pipelines to move data from one Source to another Destination Sink using ADF Pipelines
- Used different Sources and Destination like Azure SQL (Azure SQL Database, Azure SQL Managed Instance, Azure Data Lake Gen1, Gen2, Azure Storages (BLOB Containers Files Share and Tables), Dedicated SQL DWH and On-Premises SQL Server
- Used different activities like Copy activity, Execute Pipeline, Get Metadata, If Condition, Lookup
SQL Developer
Collabera Technologies
Bengaluru
01.2021 - 04.2021
- Payroll process explain the features and processes of the new integrated Finance Management System (IFMS-2)
- Understanding Business requirements and analyzing for project enhancements
- Involved in modifying various existing procedures and functions according to the changing business needs
- Used PL/SQL programming to develop Stored Procedures, Exception handling and cursors to facilitate business logic for data process and calculations
- Collaborated with the team on issues involving operations to provide timely solution to avoid operational delays and business impact
- Used different types of joins, sub queries and nested queries
- Processing the data mapping based on the office level and Unit testing as per business test cases
Education
B.Tech - Electrical, Electronics And Communications Engineering
Siddhartha Institute of Science And Technology ,JNTU
Puttur, AP06-2016
Skills
- Basic Python
- Basic Pyspark
- Basic Databricks
- Windows
- SQL Server
- IBM-DB2
- Redshift
- SSIS
- ADF
Timeline
Senior Data Engineer
Affine analytics Private limited
06.2021 - Current
SQL Developer
Collabera Technologies
01.2021 - 04.2021
B.Tech - Electrical, Electronics And Communications Engineering
Siddhartha Institute of Science And Technology ,JNTU
Similar Profiles
ALTAF UDDIN AHMEDALTAF UDDIN AHMED
Asst. Manager Admin at Affine Analytics Pvt. Ltd.Asst. Manager Admin at Affine Analytics Pvt. Ltd.
Lov NiveriaLov Niveria
IOS Developer at Expedia Group(Affine Analytics)IOS Developer at Expedia Group(Affine Analytics)
Gourav BoseGourav Bose
Senior Associate at Affine AnalyticsSenior Associate at Affine Analytics