Avinash Ray Email & Phone Number

Pune, Maharashtra, India

Kolkata, West Bengal, India

Role: Talend Developer with JavaClient: CITI Bank Core BankingTechnology and Tool: Talend 7.1, Spring Tool Suite, Oracle, SQL Developer, UNIXRoles and Responsibilities: Requirement Analysis and solicitation Talend Code development as per requirement using various Oracle components, FileComponents, System Components, normalize/de-normalize components, Loop components,aggregate components and Data Mapper Maintaining/Creating metadata tables containing parameter values for Talend jobs Integration of JAVA for complex transformations for generic Talend jobs using JAVA Spring Boot. Upfront Design. Creating new restful APIs (using java 8 features like lambda and streams) for the UI portalbeing handled by a separate frontend team. Writing junit test cases for the code developed. Pushing the code change to GIT and initiating a build using Teamcity.

Kolkata, West Bengal, India

Role: Talend DeveloperClient: CITI Bank SMART PAY 3/DODTechnology and Tool: Talend 6.3, IBM DB2, UNIX, Toad, Bit bucket, GIT, AutosysRoles and Responsibilities: Loading data in database, to generating the final reports for various clients using Talend. Data Model Designing for storing data received in the input file. SQL query Creation. Development of Database Load jobs reading input file with having complex insert updatescenarios. Used Database components like tDB2Input, tDb2Output, tDB2Row, tDB2BulkExec etc. Performed data manipulations using various Talend components like tMap, tJavarow, tjava,tflowtoIterate, tAggregate, tSortRow, tHashInput, tHashOutput, tSystem, tHashMap. Data Mapper used for generating output XML files having complex structure. Developed a Common Framework Job which is being used to load and generate various differentfile types dynamically just by changing the configuration files. Single job generating all ouputbatch files as per requirement. JIL creation for Autosys Job scheduling. Deployment & Unit Testing

Kolkata Area, India

Worked as a Talend Developer for CITI Bank TS2 project which included the following responsibilities:Analysis of other ETL jobs and development of Talend jobs accordingly.• Performed data manipulations using various Talend components such as tMap, DB components, ,normalize/de-normalize components, concept of pre job - post job, different file typecomponents, System components, looping components, java incorporating components,aggregate component , Hash components, MQ connection components and more.• Used Data Mapper in Talend for mapping complex requirements of report generation, likemapping from flat file to complex XML structure output or vice-versa.• Designing SQL extraction queries used to find appropriate data from data base.• Used IBM DB2, knowledge about row level column level access control (RCAC).• Scheduling jobs to run at the required times in Talend Administration Center (TAC) using MQConnection.• Build and Deployment of Talend jobs on Unix Server using Bit bucket and Teamcity.• Writing UNIX scripts for automation of ETL job execution and various prerequisite tasks to beperformed while deploying Talend Code on UNIX box.

Kolkata, West Bengal, India

Worked as a Talend Developer for CITI Bank TS2 project which included the following responsibilities:Analysis of other ETL jobs and development of Talend jobs accordingly.• Performed data manipulations using various Talend components such as tMap, DB components, ,normalize/de-normalize components, concept of pre job - post job, different file typecomponents, System components, looping components, java incorporating components,aggregate component , Hash components, MQ connection components and more.• Used Data Mapper in Talend for mapping complex requirements of report generation, likemapping from flat file to complex XML structure output or vice-versa.• Designing SQL extraction queries used to find appropriate data from data base.• Used IBM DB2, knowledge about row level column level access control (RCAC).• Scheduling jobs to run at the required times in Talend Administration Center (TAC) using MQConnection.• Build and Deployment of Talend jobs on Unix Server using Bit bucket and Teamcity.• Writing UNIX scripts for automation of ETL job execution and various prerequisite tasks to beperformed while deploying Talend Code on UNIX box.

Eastern Region Office ,Dhakuria,Kolkata

Bachelor Of Technology (B.Tech.), Information Technology

Education record