About

Rohit Kumar is an experienced Software Developer with over 13 years of experience in the industry. He is currently working at Westfield Insurance, where he is responsible for building different PL/SQL objects such as function, procedure, package, trigger, and complex SQL queries. Additionally, he is involved in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications. Rohit is also responsible for developing, supporting, and maintaining the ETL (Extract, Transform and Load) processes using Informatica. He has developed several generic Informatica jobs that can be reused for several processes. Prior to Westfield Insurance, Rohit worked at Bank of the West and Bharti Axa, where he gained extensive experience in developing software applications. At Bank of the West, he worked with business partners and various stakeholders to understand the requirements, file format, validations on data attributes. He also led the implementation from inception by managing resources, development efforts, key deliverables, and issues. At Bharti Axa, he was responsible for generating reports using the Hadoop ecosystem and sending it to BA for analysis. He also designed and developed various Oracle database objects and migrated data from Oracle HRMS to Oracle HCM system using Informatica PowerCenter. Rohit is proficient in various technologies, including Oracle PL/SQL, Informatica PowerCenter, Core Java, Unix Shell Scripting, Hadoop ecosystem, and Snowflake. He has experience in designing and developing complex source-to-target mapping using various transformations inclusive of but not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression, and Router Transformations. He is also experienced in interacting with clients, requirement gathering, design, and delivery. Rohit is a skilled software engineer, SQL designer, ETL developer, and QA tester. Overall, Rohit is a highly skilled software developer with extensive experience in developing software applications. He is a quick learner, a team player, and has excellent problem-solving skills.