About

Romil Wadhwa is a technically competent Oracle Certified Associate with over 11 years of extensive experience in the IT industry and Data Analytics, Hadoop platform. He has a strong background in Database development in Oracle Pl/SQL, ETL process using Informatica Power Center 9.1/9.6 and Informatica cloud. He has conducted POC on multiple cloud ETL Tools as part of the cloud initiative for the client and created a performance matrix on Matilien/Glue/Talend/Informatica cloud as part of the cloud initiative. Romil has experience with EC2, VPC, S3, Redshift, Lambda, Alexa skills, Informatica cloud, and monitoring services. He has created a financial data model based on Guidewire architecture and developed mappings and jobs in Informatica cloud for the financial Mart. He has also developed Infogix checkouts scripts for financial reconciliation in data warehouses. Romil has worked on Performance tuning on the SQL query and Informatica jobs as part of Performance improvement. He has extensively worked on Incident and Problem management as ETL Production Support lead. He has also worked as Lead/Project manager and has the expertise to monitor and delegate the work. Romil has experience in integrating heterogeneous data sources like Relational tables, Flat files, and Excel Sources into the Staging area. He has implemented Complex Mapping such as Slowly Changing Dimensions (SCD’s). He has experience in client interaction and understanding Business applications, Business data flows, and Data relations from them. Romil has excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules. He also has experience in backend programming including schema and table design, stored procedures, Triggers, Views, and Indexes. Romil has worked as a Data solution architect at American Family Insurance and as a Technical Architect at Infosys. He has also worked as a Lead Technical Consultant at Genpact. He has a Bachelor's degree in Electrical, Electronics and Communications Engineering from Uttar Pradesh Technical University. Romil's Tech Stack includes Senior Software Engineer, ETL, AWS, SQL, Hadoop, Backend, QA, Python, and MySQL. With 14.78 years of relevant experience, Romil is a skilled professional who can deliver results with his technical expertise and leadership skills.