Amarjit Kokare
Pune
Summary
Dynamic and results-oriented professional with over 8 years of experience in Data Warehousing, specializing in ETL development and maintenance on Oracle and Informatica platforms.
Possess a solid understanding of Data Warehousing concepts and dimensional modeling. Strong communication and analytical skills, self-motivated with the ability to conceptualize, document, and communicate project ideas and plans. Eager to leverage expertise and drive impactful solutions in data integration and business intelligence.
Overview
12
12
years of professional experience
Work History
Technology Lead
Infosys Ltd
12.2020 - Current
- Participated in performance tuning activities
- Responsible for analysis data and develop/understand ETL specifications
- Developed and enhanced complex mappings and OBIEE reports
- Met project deadlines consistently, achieving 98% on-time delivery rate and reducing project overruns by 20%
- Extracted data from various sources including Oracle tables and flat files
- Implemented robust error handling mechanisms, reducing data error rates by 50% and ensuring 99.9% data accuracy throughout the ETL process.
- Automated tasks through Unix script creation
- Conducted unit testing, Regression Testing and prepared test cases
- Designed, developed, and maintained ETL processes to extract data from various sources, transform it according to business requirements, and load it into the target data warehouse or database
Business Analyst
Crown Solutions
04.2019 - 12.2020
- Analyzed data and developed ETL specifications
- Created reusable transformations and participated in performance tuning activities
- Implemented performance tuning techniques, resulting in 40% reduction in ETL job runtime and meeting SLAs consistently with 95% success rate.
- Handled Development and support activities.
- Optimized ETL workflows to improve efficiency and performance, resulting in reduced processing time and enhanced data quality.
- Implemented error handling techniques to identify and resolve data quality issues, ensuring accurate and reliable data transformation and loading.
ETL Developer
Tata Communications Ltd
01.2016 - 11.2018
- Analyzed and captured billing and commissioning data
- Developed ETL processes, implemented slowly changing dimensions, and conducted unit testing.
- Mentored and coached junior team members, resulting in 20% increase in their productivity and 15% decrease in error rates within six months.
- Created and maintained documentation for ETL processes, including data mappings, transformation rules, and workflow diagrams, to ensure transparency and facilitate knowledge transfer.
Team Lead
Neeyamo Enterprise Solutions
06.2012 - 12.2015
- Managed day-to-day activities, vendor management, and client escalations
- Led successful transitions for US clients and developed strategic plans for operational activities.
- Maintained detailed documentation for all processes, resulting in 20% increase in team productivity and ensuring smooth knowledge transfer during team transitions.
Education
Bachelors Of Engineering -
Vishwakarma Institute of Technology (VIT)
Pune05.2011
Skills
- Informatica Power Center 10x/9x
- IICS-Informatica Intelligent Cloud Services
- Oracle Business Intelligence Enterprise Edition (OBIEE)
- Tableau and Power BI
- SQL and PL/SQL
- Oracle 10g/11g
- TOAD
- Control-M Informatica Scheduler
- Unix Scripting
- Windows/Unix
Skills
Performance Tuning Data Mapping
Business Intelligence Production Support Activities
Data Warehousing Requirements Gathering
Error handling techniques Design development
Database structures Agile Methodologies
Statistical Analysis Data Visualization
Personal Information
- Title: Data Engineer- Informatica ETL Developer
- Date of Birth: 06/14/1989
- Marital Status: Married
Hobbies and Interests
Watching Movies, TV series, Reading books, Watching Football
Timeline
Technology Lead
Infosys Ltd
12.2020 - Current
Business Analyst
Crown Solutions
04.2019 - 12.2020
ETL Developer
Tata Communications Ltd
01.2016 - 11.2018
Team Lead
Neeyamo Enterprise Solutions
06.2012 - 12.2015
Bachelors Of Engineering -
Vishwakarma Institute of Technology (VIT)
Similar Profiles
CHITHIRA MCHITHIRA M
SAP SD consultant at Infosys LtdSAP SD consultant at Infosys Ltd
Sudhakar KatikireddySudhakar Katikireddy
Lead Consultant at Infosys LtdLead Consultant at Infosys Ltd
SAIKRISHNA HARISAIKRISHNA HARI
Principal Consultant at Infosys LtdPrincipal Consultant at Infosys Ltd
ATHUL AJAYANATHUL AJAYAN
System Engineer at Infosys LtdSystem Engineer at Infosys Ltd
Pratik ChaflePratik Chafle
Data Engineer Manager at SaksoftData Engineer Manager at Saksoft