Mranal Jain

Experience

• 

  Defence Research and Development Laboratory (DRDL) - DRDO

  Jun 2019 - Jul 2019

  Intern

  Project that simulates air-breathing target for the testing of missiles. Different types of targets move in various trajectories, missile that is needed to be tested is simulated to test and examines the working of the missiles in a given environment

• 

  Optum Global Solutions

  Jul 2021 - Apr 2024

  Software Engineer

  • Work experience in data integration, ETL processes, and database management.• Proficient in creating and maintaining ETL workflows to automate data integration processes, significantly enhancing operational efficiency.• Demonstrate success in delivering data solutions and optimizing workflows to augment business intelligence and decision-making processes.• Conduct thorough unit testing and performance testing, identifing and resolving bottlenecks in Talend and SQL, contributing to system optimization• Key contributions involve designing and implementing an Error Handling Framework and automating job scheduling using database configuration tables.• Collaborated with teams to facilitate the transition from Legacy Mainframe to Facets System using Talend and SQL Stored Procedures.• Engage in maintaining and remediating Talend Jobs, providing crucial production support.• Knowledge of US Health Care (Facets), participating in enrolling subscribers and members from Facets to create test data. Proficient in creating claims and customer service tasks for these subscribers.• Utilize tools like Jenkins, XL Release, and XL Deploy for seamless code deployment in higher environments. Managed ETL jobs using Tivoli Workload, ensuring smooth execution and performance.• Expertise includes creating mappings in Talend using various components such as tMap, tJoin, tConvertType, tflowtoIterate, tAggregate, tSortRow, tLogCatcher, tSetGlobalVar, tHashInput, tHashOutput, tJava, tJavarow, tAggregateRow, tWarn, tFilter, tGlobalmap, tDie, and others.• Implement advanced query tuning strategies to eliminate performance issues, leveraging execution plans, normalization techniques, SQL hints, and index implementations.• Design and implement ETL processes for data loading from heterogeneous sources to SQL and Oracle, specializing in Fact and Slowly Changing Dimensions (SCD-Type1, SCD-Type2, and SCD-Type3). Show less

• 

  Optum

  Mar 2024 - now

  Senior Software Engineer