SRIRANGAM NAGASAI TEJA

Data Back Sync:

• Currently working on Database Back Sync of data from Salesforce (PRM) to DB2(AAS) as part of Migration Project
• Developed Fixed Width File Extract on top of salesforce data which will be consumed by Business
• Implemented data pipelines in Azure Data Factory to automate spark notebook executions and execute the sql scripts into the target Database

Source System to Salesforce integration:

• Worked on End-to-End Data Integration from Source System to Salesforce
• Deployed ADF Pipeline to Upsert(insert/update) source system data into salesforce
• Used Databricks Workflow to automate notebook execution instead of ADF normal process and reduced the execution time around 30%

Data Insights:

• Crafted Extracts on top of Data Lake/Source Files which will be used by the end users
• Applied SCD and CDC functionality as per business requirement using delta lake merge
• Built the pyspark code to read the data from data lake and load into Datamart

Project1:

• Experience in importing and exporting data using Sqoop from HDFS/Hive to Relational Database Systems and vice-versa
• Created Partitioned and Bucketed Hive tables in the required file formats and loaded the data into that tables and have developed hive queries on top of that for analytics purposes

Project2:

• Was a part of Middleware Production support team for a retail client which handles tools like IBM Datastage,IBM MQFTE and Azure based HTTPS and MQ based flows
• Worked on IBM Datastage has a production Support Analyst,which is responsible for monitoring/tuning of daily/weekly Jobs to meet the SLA