Yashwanth Basavan
Hyderabad
Summary
6+ years of professional IT experience in all phases of Software Development Life Cycle which includes hands on experience in Microsoft Azure, Azure Data Factory, Azure Data bricks, Azure Devops and SQL.
3 years of experience in designing and deploying solutions for data-ingestion using cloud native services like Azure Data Factory, Azure Data Bricks, Azure Devops, Azure Data Lake Store ,Blob Storage, MS SQL, Postgres SQL and Synapse DB.
Experience working in different domains such as Insurance, CPG and Healthcare.
Worked on the Agile methodology
Overview
6
6
years of professional experience
Work History
Associate Consultant
Atos Syntel
08.2022 - 08.2023
- Client Summary: A UK-based pension trust enabling automatic enrollment to workplace pensions. Led the digitization initiative, migrating historical data from on-premises to Azure Cloud using robust data pipelines based on mapping rules
- Environment: Azure Data Factory, DataFlows, Azure Blob, Oracle DB, Synapse DB, Postgres SQL, Azure DevOps
- Responsibilities:
- Designing ETL using Azure data factory to collect and process the data
- Involved in requirements gathering, analysis, design, and development
- Created data pipelines that moves GBs of data from Oracle to Postgres
- Implementing all the transformations using Dataflows
- Extracted data from Oracle and ingested to Postgre DB
- Extracted data from blob and loaded to synapse
- Loaded Data to Synapse DB as intermediate stage
- Used control flow activities like Getmeta, Lookup, Copy activity, For Each, If Condition activity, Filter and Set variable
- Used transformation components like Aggregate, Alter row, Cast, Conditional split, Derived Column, Exists, Join
- Lookup New Branch, Select, Union
- Implemented SCD type -1 to Synapse
- Creating unit test document and preparing release document for QA
- Used Agile methodology and user stories status for tracking through the JIRA
- Dealing with large amount of data in Azure Synapse DB
- Deployed pipelines to QA environment using DevOps CI/CD pipeline
- Resolved Issues raised by QA Team.
Senior Software Developer
Pyramid Consulting, Inc
10.2021 - 08.2022
- Initially joined Atos Syntel as a contractor, actively engaging in a data migration project. Impressed by my contributions and dedication, Atos Syntel extended a full-time position, allowing me to seamlessly transition while continuing to excel in the same project
Software Developer
Certiview IT and Management Solutions
02.2017 - 09.2021
- Client aims to build a global Data Lake using Azure by migrating the data from Oracle.Success Factors for performing analytics and publishing the data to the end user
- Responsibilities:
- Creating ADF (Azure Data Factory) pipelines for processing the data by following the best practices
- Creating Azure Data Bricks notebooks for processing the data
- Testing the pipelines both unit and functional
- Deploying the pipelines using Azure Devops
- Ingesting the processed data into SQL DB by creating ADF pipelines
- Environment: Talend Data Fabric, S3, Redshift, Salesforce
- Responsibilities:
- Understanding the data, gathering business requirements
- Developed Talend jobs to extract data from salesforce
- Performed brand and country harmonization
- Loaded data into S3 as intermediate storage
- Loaded data into stage layer of Redshift and performed SCD - 1 to warehouse layer
- Used components like tredshiftinput, tredshiftrow, tsalesforceinput, tssh, tjava, joblets, ts3put, tmap, treplicate, tjoin, tfilelist, tjsonextract, tfileoutputdelimited, tnormalize etc
- Deployed code into Nexus repository with versioning
- Created job conductors in Talend administration console.
Education
B.Tech - Electrical and Electronic Engineering
Institute of Aeronautical Engineering
Hyderabad05.2014
Skills
- Azure Data Factory
- Azure Databricks
- Azure Data Lake Store
- Blob Storage
- Azure Devops
- SQL
- Talend
Timeline
Associate Consultant
Atos Syntel
08.2022 - 08.2023
Senior Software Developer
Pyramid Consulting, Inc
10.2021 - 08.2022
Software Developer
Certiview IT and Management Solutions
02.2017 - 09.2021
B.Tech - Electrical and Electronic Engineering
Institute of Aeronautical Engineering
Similar Profiles
Rahul DavaneRahul Davane
Associate Consultant at SYNTEL, Atos SyntelAssociate Consultant at SYNTEL, Atos Syntel
Bikash Kumar TiwariBikash Kumar Tiwari
Associate Consultant at Syntel Private Ltd, ATOS SyntelAssociate Consultant at Syntel Private Ltd, ATOS Syntel
Manjit SarmahManjit Sarmah
SAP S4 Hana Service Delivery Manager at ATOS-SYNTEL (Renamed as Eviden- An ATOS Business)SAP S4 Hana Service Delivery Manager at ATOS-SYNTEL (Renamed as Eviden- An ATOS Business)