Aveek Mukherjee

• Worked closely with Onshore Business Analyst to review the business specifications of the project and also to gather the requirements
• Designed and developed end to end ETL/ESB process from various source systems to final target.
• Designed complex conventional mappings in DI job as well as in Talend Data Mapper for mediation routes.
• Tested Talend Flows in local by setting up local containers in Docker such as SFTP server, Kibana, Grafana, MongoDB, Elasticsearch etc.
• Deployed Talend Flows in server using TAC and scheduled Flows using Triggers.
• Performed code review for all developers in my team before publishing code to higher environment
• Keep track of daily progress or new requirements in JIRA Kanban board and plan accordingly
• Built strong relationships with customers through positive attitude and attentive response.
• Mentored and guided employees to foster proper completion of assigned duties.
• Hired, trained and mentored staff to maximize effectiveness.

Project name: Citi Accounts & Services

• Worked closely with Business Analysts to review the business specifications of the project and also to gather the ETL requirements
• Design and developed end-to-end ETL process from various source systems to final Data Marts.
• Developed Talend jobs to connect to TIBCO EMS queue and capture event-based messages and process the same to update the DB with real time/near real time data.
• Involved in writing SQL Queries and used Joins to access data from Oracle, and MySQL
• Implementing complex business rules by creating re-usable transformations and robust mappings using Talend transformations like tConvertType, tSortRow, tReplace, tAggregateRow, tUnite etc.
• Using tStatsCatcher, tDie, tLogRow to create generic joblets to store processing stats into AMC Database table to record job history
• Integrating java code inside Talend studio by using components like tJavaRow, tJava and Routines
• Using debug mode of Talend to debug a job to fix errors.
• Troubleshot and tune long running jobs.
• Built UNIX scripts to monitor the running sessions for Talend Jobs & housekeep the unused files in server to maintain memory%.

Project name: BT_EIP_ASM_ PROSPECIO_OFFSHORE

• As a part of job scheduling I have configured ABINITIO and PL/SQL jobs in Control-M to trigger them at designated time.
• Expertise in various configurable options (in conditions, out conditions) in Control-M to set the dependencies between jobs to meet business requirements.
• Loading data into tables by creating table partitions, performing partition exchange with staging table and using SQL loader as part of manual activities in production support
• Analyzing production ab-initio graphs as a part of data issue investigations and job failure resolution using the GDE.
• Analyzing production PL/SQL package
• I have been an active and major participant of Ab-initio to PL/SQL code migration.
• Have created/modified many Shell scripts during the Server migration activity to keep the BAU activities intact also to make the daily BAU activities go smoother.
• Investigating DB issues like deadlock, long running sessions, SQL hints etc. using sys tables such as v$session, v$locked_objects, v$sql_area etc
• Creating weekly/monthly statistics and summary reports for ETL activities from audit tables using SQL queries.