Rohit Deodhar Email & Phone Number

Pune, Mh, In

Pune, Maharashtra

• Build, monitor, and optimize ETL and ELT processes with data models.• Design and implementation of scalable data warehouse solutions.• Develop complex SQL queries for data analytics and business intelligence.• Perform data modeling, ETL processes, and performance tuning for Snowflake environments. • Ensure data security and compliance with industry standards.• Mentor junior developers and collaborate with cross-functional teams.• Project documentation and tracking based on understanding user requirements.• Risk assessment, management, and mitigation plans.• Regular engagement with teams for status reporting and routine activities.

* Project description:CEETRIS squad formed for designing and developing BI applications for countries in the CEETRIS Region. Its aim is making data available and creating outcomes in order to take actions within CEETRIS.* Roles and Responsibilities :• Worked with business end-users and business analysts to define the data requirements.• Designed and developed data requirements for multiple BI applications.• Develop Data flow architecture.• Performed source system analysis, data profiling and design mapping logic between source systems and data warehouses.• Used Shell scripts and Python API’s to extract data from different sources.• Collaborated and contributed to identifying project risks, designing mitigation plans, and developing timeline estimates.

Pune Area, India

Support and Enhancement for BI solutions of leading swiss pharma company in EEMEA region.• Resolving incidents raised by Business users• Involved in requirement gathering and design of tables for new change requests.• Enhancement of existing workflows for better performance.• Assigning tasks to ETL team.• Guiding / Mentoring Team members.• Providing Technical Assistance to the team.

Pune, Maharashtra, India

• Design and develop Physical Data Models for database objects in Staging, EDW and Data mart layers.• Create source to target technical mapping document for ETL process based on data mapping.• Developing ETL components for Archival staging, Staging, EDW and Data mart layers.• Involved in analyzing and profiling source data.• Analyze and document data mapping.• Develop Informatica mappings for staging area.• Develop Informatica mappings for EDW implementing SCD Type II.• Develop Informatica mapping for Bridge tables.• Identifying unit test case scenarios and performing unit testing.• Develop Informatica mappings for Facts and summary table.