Deepesh Jhamar work email
- Valid
- Valid
- Valid
Deepesh Jhamar personal email
- Valid
• Over 14 years of IT experience in Business Requirements analysis, Application Design, Data Modeling, Coding, Development, Testing and implementation of business applications with RDBMS, Data Warehouse/Data Mart, ETL, OLAP, Client/Server environment applications.• Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.1/7.0/6.2/5.1, OLAP, OLTP, SQL, PL/SQL, Complex Stored Procedures, and Triggers.• Strong experience in Informatica Power Exchange to extract data from Application like SAP, Mainframes• Extracted data from SAP R/3 using ABAP and RFC/BAPI to load into SAP systems.• Integration of various data sources/Targets with Multiple Relational Databases like Oracle, SQL Server, Flat files,DB2.• Having experience working on End-To-End implementation of data warehouse and strong understanding of DataWarehouse Concepts, ETL, Star schema, and Data Modeling.• Experience in debugging and performance tuning of targets, sources, mappings and sessions.• Strong skills in back-end testing using SQL Queries and Excel.• Experience working on Business Intelligence tools like Business Objects• Design and development of Mappings and Scheduling of batches for ETL projects using Control M• Experience in Software Development Life Cycle (SDLC),ISO 9001:2000,SEPG, Agile Methodologies, CMM Level5,and Validations to ensure complete Quality Assurance Control• Ability to work in Multi-Platform Environments like Windows and UNIX.• Expert in leading the software design/development team and handling onsite/offshore execution modelprojects.• Strong analytical ability and problem solving skills.• Quick learner on technology and domains.
-
Technical Program ManagerAmazon Oct 2018 - PresentSeattle, Wa, Us -
Data Engineering ManagerAmazon Jan 2017 - Oct 2018Seattle, Wa, Us
-
Application EngineerAmazon Jan 2015 - Jan 2017Seattle, Wa, Us
-
Lead EngineerWipro Technologies Aug 2009 - Jan 2015Bangalore, Karnataka, In -
Technical LeadSony Electronics May 2013 - Jul 2014San Diego - Us | Tokyo - Jp, Us• Worked with upstream teams in identifying impacted list of fields that are Logically/Structurally impacted or required conversion• Created new ETL interface to load data from retiring applications like mainframes ORA apps into new SAP (DRP) System• Created new BAPI/Idoc interfaces to extract data from SAP BAPI’s and Idoc’s.• Created functional specification /Technical designs for all impacted ETL/New ETL’s and created UAT/SIT docs forthe same after required changes are complete.• Communicated to downstream systems about the impact analysis and handle the changes from reporting endextensively worked with offshore teams and evaluated the timely changes to the coding as a part of conversion.• Reviewed and approved the code changes done by team members.• Used of ripple queries to identify the data lineage.• Extensive use of metadata queries to create a requirement specific metadata table -
Senior Data Warehouse ConsultantSony Electronics Jan 2011 - May 2013San Diego - Us | Tokyo - Jp, Us• Production support maintenance such as monitoring the ETL batch jobs and fixing the job failures, bug fixes and data issue reporting.• Carried out extensive data analysis that led to the resolution of complex problems.• Following the change management activities such creating a CR/FR and attend the CAB meetings.• Tuned the performance of Informatica, Database and Reporting performance. Some of the steps used to tunethe performance include indexes, Informatica and database partitioning, Explain Plan, Effective rewriting thequery and SQL Hints• Enhancements of the existing ETL systems as per business requirement, Enhancements activities includerequirement gathering, design, development and testing• Worked on Offshore Onshore model, held meetings on a daily basis for coordination and planning.• Worked with offshore team and conducted daily meetings to get status update.• Use of BO reporting tool, to understand the data issues raised by the end users.• Supporting the Informatica platform activities like deployments, creating new connection objects, to ensure allthe services are up and running fine, creating new users.• Frequent meetings with the Business to understand the new business requirements and providing the estimateson the same.• Presenting the Weekly status review (WSR) to Client.
-
Senior Etl ConsultantSony Electronics Aug 2009 - Jan 2011San Diego - Us | Tokyo - Jp, Us• Worked with Business Analyst to gather the requirements and created functional and Technical specifications• Coordinated with data modeler in designing the various schemas for planning and manufacturing modules.• Handled client enquiries and prepared daily workloads for the team members.• Created mapping documents and estimates for each mapping.• Worked with SAP team to identify the tables, Functional modules and data sources.• Extensively used various transformations like Aggregator, Expression, connected and unconnected Lookup’s andupdate strategy transformations to load data into target.• Worked on performance issues and bottlenecks to reduce the load time and monitored the data loads.• Created mappings to support delta loads into target using mapping variables.• Production support maintenance such as Monitoring of the ETL batch jobs and fixing the job failures, bug fixesand data issue reported• Participating in knowledge transactions and providing the Sign off.
-
Software EngineerMahindra Satyam Oct 2006 - Aug 2009Pune, Maharashtra, In -
Senior Etl DeveloperBp Feb 2008 - Jul 2009London, England, Gb• Developed detailed functional specifications, enhancements and modifications documentation and track development progress partnering with on-site coordinator.• Offered solutions to the top management regarding project related queries• Participated in testing at all levels (unit, integration and user testing); designing and driving testing initiatives;develop and execute test plans; provide leadership to others in support role; documentation and training endusers on processes• Moved the logic of Credit cards key based on cards numbers from Informatica to source systems.• Truncated the card numbers stored in the files on the Informatica servers, so as to make the application PCIcompliance.• Coordinated the UAT and migration to the production environment. -
Etl DeveloperBp Oct 2006 - Feb 2008London, England, Gb• Extensively used Informatica Power Center for Extracting, Transforming, and Loading into different databases.• Created mappings using Informatica designer, sessions using workflow manager and tested the sessions usingtest data.• Extensively used ETL to load data from Oracle database, SQL server database, and Flat files to Oracle.• Created necessary test plans and design documents for the mappings.• Analyzing the data model and identification of heterogeneous data sources.• Designing and testing the different mappings according to the requirements.• Worked extensively on different types of transformations like Source Qualifier, Expression, Filter, Aggregator,Rank, Lookup, Update Strategy, Stored Procedure, Sequence Generator and Joiner.• Integrated various sources into the staging area in Data Warehouse.• Monitoring of Informatica Platform for CPU and Memory Usage• Migrating Informatica objects from Development repository to Production repository.• Creating Informatica users.
Deepesh Jhamar Skills
Deepesh Jhamar Education Details
-
Rajiv Gandhi Prodyogiki VishwavidyalayaElectronics And Communications Engineering
Frequently Asked Questions about Deepesh Jhamar
What company does Deepesh Jhamar work for?
Deepesh Jhamar works for Amazon
What is Deepesh Jhamar's role at the current company?
Deepesh Jhamar's current role is Senior Technical Program Manager at Amazon.
What is Deepesh Jhamar's email address?
Deepesh Jhamar's email address is de****@****ail.com
What schools did Deepesh Jhamar attend?
Deepesh Jhamar attended Rajiv Gandhi Prodyogiki Vishwavidyalaya.
What skills is Deepesh Jhamar known for?
Deepesh Jhamar has skills like Unix, Informatica, Data Warehousing, Sql, Business Objects, Teradata, Informatica Administration, Power Exchange, Master Data Management.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial