Mohammed Sameer G

Experience

• 

  RAMTECH ENGINEERING SERVICES PRIVATE LIMITED

  Jul 2015 - May 2017

  Database Engineer

  * Worked as a SQL Developer

• 

  Cadmaxx Solutions Pvt Ltd

  May 2017 - Jun 2018

  Associate Engineer

  * Worked as SQL Developer

• 

  Techbeez Software Solutions

  Apr 2020 - now

  Informatica Developer

  * Preparations & Reviews of ETL mapping Specifications. * Created mappings for loading the data for staging, dimension and fact tables, using CDC techniques. * Implemented Business logic like error handling method by maintain the error log table & maintain the audit of data warehouse system which can give one stop shopping to analyzer. * Review of code to maintain proper logic implementation/quality standard in the Mappings * Performed Unit Test Cases for mappings.* Created ETL mappings using Informatica Power Center to move Data from multiple sources like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts. * Developed mappings to extracting, cleansing, transforming and Loading into DW. * Created reusable transformations and mapplet in the designer using transformation developer and mapplet designer tools. * Done Enhancement for the Existing Mappings. * Test mapping to assure that data is loaded as per ETL specification. * Extensively used the Informatica Debugger for debugging the Mappings to check the Business rules implemented correctly or not. * Involved in performance tuning by optimizing the sources, targets, mappings and sessions. * Automated/Scheduled the jobs to run daily with email notifications for any failures. Show less