Varun S Email and Phone Number
- Over 16.4 years as a Software Professional with extensive expertise in Data Management across the Bank, Insurance, Travel and Retail domains - Data Engineer - ETL Designer, with a proven track record in leading teams to deliver technology solutions for Data Lakes, Data Warehouses, and data migration projects using both Agile and Waterfall methodologies- Worked closely with business experts (SMEs) at onsite (UK) for 4 years and Finland 1 year- Designed and developed comprehensive ETL solutions and metadata management frameworks, utilizing a range of technologies including BDM, Python, Hive, Informatica, AWS, UNIX, Oracle, MSSQL, and T-SQL- Built some shopping cart websites using web services, PHP, MySQL, HTML, CSS, Java scripts and CMS like Joomla, Drupal- Developed Robotic Process Automation using Blueprism- Scheduled ETL jobs in Tivoli WS(Mainframe/Windows), Cron, Control-M - Experience in tools like PyCharm, Stash, JIRA, GIT, Eclipse, SQL Developer, TOAD, Assyst- Creating detailed design/mapping documents for create and support the products- Good exposure in various testing methodologies like Function, Integration, system, user acceptance, regression, smoke, sanity and database testing- Experience in writing and reviewing of the project plans like cost estimation, resource management
-
Data EngineerTata Consultancy Services -
Data Engineer – Team LeadOp Bank 2022 - PresentVALAS - Operational Data Services (ODS)- Gather the requirement and designed the comprehensive ETL solution and prepared BRD, HLD and LLD and mapping documents- Developed the metadata management framework- Python to create DataStage components (XML)- Wrapper scripts, Encrypt/Decrypt, API, Kafka- Agile, CI/CD, Jenkins, Jira, Confluence
-
Data Engineer – Team LeadTata Consultancy Services Feb 2021 - Aug 2022FPAN Movements 2021- Involved in stakeholders meeting and understand business requirements and with help of Architect prepared standardised BRD, HLD and LLD and mapping documents- Designing and Developing end to end extract, transform and load using Informatica DEI- Wrapper scripts, mappings/workflows and scheduled using TWS
-
Etl Designer / Team LeadTata Consultancy Services Oct 2020 - Feb 2021Informatica-MI, DEI, Hive (EMR), MSSQL, HDFS, Unix
-
Etl Designer / Team LeadTata Consultancy Services Oct 2020 - Feb 2021Data Ingestion- Designed and Developed Metadata Management framework- Developed Ingestion pattern using Dynamic Mappings/Workflows (DEI) using parameters and variables to build Data Hub- Historical data migration using Informatica Mass Ingestion
-
Data Analyst / Team LeadAviva – General Insurance Jan 2018 - Oct 2020Participate SMEs meetings to understand business and technical expectations and highlight risks and dependencies- Migrate mappings, scripts from on-premise to cloud- Developed Dynamic mappings and Python scripts to build data lake- Worked with network team in enabling firewall set-up- Enable SFTP setup and developed generic shell script for SFTP files from AWS to Oracle server- Function, Integration, system, user acceptance, regression, data base and performance testing and captured the evidence and got sign-off from business- Worked with informatica admin and network team to improvement the performance Aid in Production deployment of code and perform validations
-
Robotic Process AutomationAviva – General Insurance Jan 2017 - Jan 2018- Understand client business activities and the software’s involved- Provided High level document to Blue-prism experts to make sure it suits for Automation process and Design Web based solution(s) in Blue Prism – Process Studio - Blue Prism to spy the screen, VB macros for Excel and capture the process log in Splunk- Scheduled Operational Acceptance to make sure the requirements meet
-
Tnps – Pnq History MigrationAviva – General Insurance Apr 2013 - Jan 2017- Delivered Unix Framework and Informatica workflows/mappings in a short span with 2 members team - PnQ- Developed the BTEQ queries to stage the data -Created several mappings to transformation the data and to generate the key- Enhancement done for better performance to the existing mappings and shell scripts- Applied data fix to avoid reload of complete history data- Developed automation tool report - EDW- Developed automation scripts to load the master data tables and created several mappings to transformation the data to EDW- Supporting/Resolving any kind of ETL related issues reported by the end users
-
Business Analyst / Module LeadAviva – General Insurance Jan 2013 - Jan 2017Blue-prism, Splunk, VB Scripts (Macros), Excel, Windows XP
-
Team MemberParamount Pictures Crown Solutions (Tata Consultancy Services) Jul 2011 - Apr 2013Electronic Data Interchange (EDI)- Development and enhancements of Informatica mappings to extract data from various applications- Received the sales data from various dealers and loaded that into data warehouse- Modified the existing UNIX shell scripts as per the business requirement- Supporting/Resolving any kind of EDI or ETL related issues reported by the end users without breaching the SLA
-
Senior Web DeveloperAdodis Techonology Aug 2008 - Jul 2011Web service 2.0, PHP, MySQL, Cake PHP, HTML, CSS, XWAMP
Varun S Education Details
-
K.L.N College Of Information TechnologyComputer Applications -
Madura CollegeMaths
Frequently Asked Questions about Varun S
What company does Varun S work for?
Varun S works for Tata Consultancy Services
What is Varun S's role at the current company?
Varun S's current role is Data Engineer with Python and ETL Informatica AWS.
What schools did Varun S attend?
Varun S attended K.l.n College Of Information Technology, Madura College.
Who are Varun S's colleagues?
Varun S's colleagues are Louis Guma, Dr.vijitha Vivekanandan, Palanivel K, Neha Punjabi, Shrinidhi Puranik, Sameer Patro, Ramesh Nallathambi.
Not the Varun S you were looking for?
-
4yahoo.in, gmail.com, timesinternet.in, coffeemug.ai
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial