• Formulated and tested extraction, transformation, and load (ETL) processes.• Provided data analysis and technical documentation for both source and target mappings.• Stored procedures and packages within the mappings in addition to modifying Informatica mappings and sessions to make sure optimal performance.• Understanding the business requirement specifications provided by the client and translates them into ETL design specification and loads the data into target… Show more • Formulated and tested extraction, transformation, and load (ETL) processes.• Provided data analysis and technical documentation for both source and target mappings.• Stored procedures and packages within the mappings in addition to modifying Informatica mappings and sessions to make sure optimal performance.• Understanding the business requirement specifications provided by the client and translates them into ETL design specification and loads the data into target database.• Integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, XML. Show less

Roles and Responsibilités:  Understanding the business requirement specifications provided by the client and translates them into ETL design specification and loads the data into the target database. Based on business requirement involved in to prepare the SRS document. Involved in the discussion of requirement clarifications with technical and business teams (Onsite & Offshore). Developed mappings with transformations like Source Qualifier, expressions, and joiner… Show more Roles and Responsibilités:  Understanding the business requirement specifications provided by the client and translates them into ETL design specification and loads the data into the target database. Based on business requirement involved in to prepare the SRS document. Involved in the discussion of requirement clarifications with technical and business teams (Onsite & Offshore). Developed mappings with transformations like Source Qualifier, expressions, and joiner, Aggregators, Lookups, Filter, Rank and Update Strategy etc for loading data to target tables. Developed workflows using tasks and sessions. Worked on change requests and enhancements to the already existed mappings. Performed testing of ETL procedures and programs in session log to ensure successful completion. Supporting for running, monitoring and scheduling, un-scheduling the job. Involved in production support and also post Go-Live production support. Updating client on a daily basis with the Status, Highlighting the Risk areas & progress of the project Show less

Trained and Collaborated with team to work on Oracle and PL/SQL. Implemented data handling best practices with team for distance education project (for both web and mobile based).