Abhijeet Kamthe

Around 9 years of IT experience in the analysis, development and testing of data warehousing applications primarily using Informatica, Oracle. Good understanding of Dimensional Modeling. Planning, analysis, design, development & implementation of various Data warehousing assignments involving Informatica (ETL).

Hands on Experience in Informatica Power center 8.6.0/9.1 with focus on developing mappings, Workflow monitoring and scheduling. Good understanding of UNIX Shell Scripting. Flexibility in adapting to any new technology.

A good team player and can also work as an individual contributor. Proactive and have a good sense of time management.

Software Engineer at Amdocs (2016-11 – 2024-09)

• Part of Teradata to snowflake transformation project
• We have few manual work to do then existing utility to convert. bteq to. snowsql
• We have to build few mappings in IICS as per request
• Being T1 team, We are supposed to send them (T2 Team) a failure detail and command to execute to continue with Production jobs in case of failure
• Automation related work, Implemented auto shell scripts which sends email as well as file in particular log files directory with exact reason so that T2 team can take action
• Part of the Enterprise Datawarehouse team (eCDW) team
• Design, develop, and deliver end to end Datawarehouse/BI solutions
• Use control file in Vertica to support and TWS schedular to maintain and enhance the existing applications
• Optimize Copy utility in Vertica for faster loads
• Write shell scripts to create wrappers for batch execution and interaction with Vertica Databases
• Optimize internal configuration parameters in Vertica for best performance
• Use IBM Tivoli to schedule jobs
• Working in an Agile workflow with iterative deployments

Developer at Amdocs (2019-01 – 2024-09)

Client: AT&T

Developer at Amdocs (2016-11 – 2018-12)

Client: Rogers

• The project was a Migration one in which Applications were migrated from Teradata to Oracle
• The ETLs had to be rebuilt/modified and made to be pointed to Oracle instead of Teradata
• Modified/Rebuild logic to achieve same result in Oracle as in TD for various tables part of different applications
• Worked on performance optimization which was a major concern of the migration project
• Worked closely with DBAs to have better execution plan for the queries impacted and used proper hints in the queries
• Did unit testing right after any enhancement or new development in project

Software Engineer at Mannara Technologies pvt ltd (2015-07 – 2016-08)

Client: Guthy Renker

• Understanding the Business Requirements and Develop an ETL process to load data from source to target
• Creating mappings, sessions and workflows. Scheduled and monitored loading Informatica Workflow Manager
• Performing Unit Testing of ETL Mappings
• Manage day today ETL production support along with error resolution
• Implemented UNIX shell scripts
• Doing Analysis and finding the inconsistence in Informatica jobs, to resolve the problems and sending the right data to the end users
• Involved in Performance tuning in Informatica
• Sending corrected Email Campaign data to End user and third party vendor for e-mail marketing
• Designed Email opt out process and supporting same when required
• Analyzed existing system and developed Support documentation on changes required

Master of Computer Science in Computer Science – PUNE UNIVERSITY