Ramkumar Sharma Email & Phone Number

- 14 years of experience as a Senior ETL Data Engineer in implementing Data Extraction, Data Migration, Data Transformation and Data Profiling in banking, life sciences, retail, and pharmacy domain using Oracle PL/SQL and Informatica PowerCenter.- Experience in designing ETL applications to integrate heterogeneous sources and target systems like Oracle, SQL Server, Teradata, Snowflake, CSV, XML etc. in a corporate wide environment. - Experience in dimensional data modelling using Star & Snowflake schema, Facts, Dimensions, Slowly changing dimension, Data Mart, Semantic Layer, Data Integration and other ETL methodologies.- Experienced in Agile Methodologies concepts and tools such as daily standups, JIRA board, scrum sessions, backlog refinement, sprint planning etc. Lead the daily scrum calls and worked with product owner in ensuring all backlog items were successfully delivered.- Experienced with performance tuning using advanced Informatica concepts like Session Partitioning, High Availability, Push Down Optimization, Concurrent workflows etc.- Experience in database development including PL/SQL programming, Constraints, Indexes, Views, Stored Procedures, Triggers and Cursors.- Experience in Informatica Cloud (IICS) tasks such as Data Synchronization, Replication and Mapping Tasks.- Knowledge of data warehousing techniques like Star/ Snowflake schema, Facts, Dimensions, Slowly changing dimension, OLTP/ OLAP, Data Integration and other ETL methodologies.- Experienced with advanced Informatica concepts like Session Partitioning, High Availability, Push Down Optimization, Concurrent workflows etc.- Experience with CICD - Continuous Integration and Continuous Delivery (Jenkins, Stash, uDeploy).- Experience in scheduling the batch jobs using Informatica Scheduler, ControlM, Autosys and CA7 scheduling tools.- Passionate about Cloud Technologies and have basic knowledge in Tableau, AWS, Azure, Hadoop.- Highly motivated professional with excellent communication, analytical skills and troubleshooting skills. Ability to work on multiple tasks in fast paced environment independently or as a team to accomplish critical business objectives.

• 

  Gla Institute Of Technology & Management

  Electronics & Communication Engineering