Rohit Dalvi Email and Phone Number
● A Data Engineer with 5+ years of experience in executing data-driven solutions that expedite the efficiency and effectiveness of organizational success.● Has deep knowledge in analyzing and building complex ETL and data integration projects.● Developing applications by fetching data from Hive tables stored in HDFS at the back-end. Able to derive meaningful insights and relations from large data sets.● Proficient in analyzing and translating client requirements to development.● Expertise in SQL Server, Data Warehousing concepts, Data Loading & handling large databases.● Creating the ETL framework for Data Warehouse applications using SSIS● Provided optimum outputs within stringent timelines while working on several tasks with different projects in parallel.● Experience in analyzing the BI needs, interpreting business user requirements, and translating them into Dashboards using Tableau and Qlikview.● Accomplished complete implementation of the Software Development Life Cycle (SDLC) in projects using waterfall and agile project management.● Assisting colleagues in technical as well as functional aspects to improve skills by conducting knowledge-sharing sessions at regular intervals.● Strong verbal and written communication skills which can liaise effectively with both non-technical users and technical counterparts.
-
Data Engineer - Healthcare EconomicsOptumCounty Dublin, Ireland -
Software Engineer- Data EngineeringTransact CampusCounty Dublin, Ireland -
Data Engineering ConsultantAccenture Uk & Ireland Mar 2022 - PresentCounty Dublin, IrelandClient- (UISCE EIRANN): • Worked on creating Normalized & De-Normalized models as per the use case accepted by the client. Interact with businesses on regular basis to gather requirements and align with the scope and deliverables within the sprint. • Build entity relationships between normalized tables and create stored procedures to populate dimension as well as fact tables which are fed as sources to PowerBi dashboards.Client- (BANC NA HÉIREANN):• Responsible for preparing the product backlog & perform data profiling on Teradata tables provided by the modeling team using SQL. • Also, carry out meetings with external teams in case of queries regarding data quality, integrity, and availability.• Creating data mapping documents that contain the Target from Source IDL & IAL mappings.• Prepare the High-Level design document which ensures the list of scope, batch design, the interface used & load strategy, and the data flow diagram. -
Application Development AnalystAccenture In India Dec 2019 - Aug 2020Mumbai Area, India• Gathering data after thorough impact analyses from different sources.• Responsible to build ETL's that extract data from remote servers and schedules jobs with the help of using Control-M to load data into the SQL tables. • Building SSIS packages to transform and process the data till the Reporting layer.• Optimised stored procedures which process millions of records by adding constraints, CTEs, indexing which reduced the workload. Got exposure to Cloud Services such as Data Lake, RDS.• Part of Global releases which focused on Hierarchy changes (NGGM).• Performed Data Analysis using Hive Query Language on tables present in the Hadoop File System. • Developing and maintaining the architecture of the Project as a Data warehouse.• Proficient in end-to-end analysis, build, and testing of complex stored procedures, views, functions in SQL server.Technical Skills/ Tools:•Microsoft-SQL Server (2017)•Microsoft-SQL Server Integration Services (SSIS)•Microsoft Azure DevOps, AWS RDS, Data Lake•SQL Server Data Tools (SSDT) – Business Intelligence for Visual Studio 2013•HDFS, Hive, Hue, Ambari, PuTTY, VPN•Talend Open Studio for Big Data 7.3 -
Application Development AssociateAccenture In India Dec 2017 - Nov 2019Mumbai Area, India• Acquired knowledge of Agile methodologies and began working with them.• Participated in every aspect of the SDLC, from requirements and impact analysis to build and unit testing to post-deployment validation. Utilized QlikView to build various analytical dashboards.• Identifying and resolving faults and bugs, as well as implementing necessary RCA and preventative measures. Gained the ability to work independently and manage multiple tasks within project timelines.• Began working with SSIS packages and became familiar with Data Warehousing techniques.• Carried out deployment on Azure DevOps for moving the developed code to a higher environment for testing and then to production to ensure security and correctness.Technical Skills/ Tools:•Microsoft-SQL Server (2012, 2014)•Microsoft-SQL Server Integration Services (SSIS)•Microsoft Azure, Azure SQL DB•Team Foundation Server•Tableau, Qlikview•Excel
Rohit Dalvi Education Details
-
Computer Science -
First Class -
First Class -
Bunts Sangha'S S.M Shetty High SchoolSecondary School Certificate
Frequently Asked Questions about Rohit Dalvi
What company does Rohit Dalvi work for?
Rohit Dalvi works for Optum
What is Rohit Dalvi's role at the current company?
Rohit Dalvi's current role is Data Engineer - HealthCare Economics.
What schools did Rohit Dalvi attend?
Rohit Dalvi attended University College Dublin, University Of Mumbai, S.m. Shetty College, Bunts Sangha's S.m Shetty High School.
Who are Rohit Dalvi's colleagues?
Rohit Dalvi's colleagues are Yajnaseni Saha, Jonas Ibarra - Cpc, Ashlei Stevens, Gaurav Vlogs, Kritika Agarwal, Gavin Crowther, Jim Colhour.
Not the Rohit Dalvi you were looking for?
-
Rohit Dalvi
Greater Chicago Area3here.com, here-inc.com, morningstar.com -
Rohit Dalvi
Mscs @University Of San Francisco | Swe @Vams Global '24 | Sde Intern @Mercedes-Benz '22 | Google Dsc Lead '21 | Full Stack DeveloperSan Francisco, Ca -
3gmail.com, wipro.com, hdfcbank.com -
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