Data Engineer with 5+ years in Data Warehousing & ETL Development
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Over 5 years of experience in software development, specializing in Data Warehousing, ETL development using Talend, and database management with SQL Server, MySQL, and Oracle. Hands-on experience with Denodo data virtualization platform. Proficient in cloud technologies including Microsoft Azure and AWS. Experienced in integrating data from various sources (Databases, Flat Files, XML, JSON, CSV) using Talend.
Institute of Aeronautical Engineering
Bachelor of Technology
August 1, 2012 – June 30, 2016
HCL Technologies
Sr. Software Engineer
January 1, 2024 – Present
India
Amazon
ETL Developer
December 1, 2021 – January 1, 2023
India
Trupp Global Pvt Ltd
Talend Developer
December 1, 2020 – December 1, 2021
India
Nvidia Graphics Pvt Ltd
Software Developer
April 1, 2018 – August 1, 2019
India
Tracxn Technologies Pvt Ltd
Associate Software Developer
September 1, 2017 – April 1, 2018
India
Project 1:
June 22, 2026 – Present
The objective of project is to maintain energies. We use Denodo as data virtualization platform to manage and integrate data to various sources in a unified manner using Virtual Data Model(Totalenergies Common Model). Built and maintained Unified Data Virtualization databases using Denodo. Responsible for roles like Mr. Smurf and Mr. Clean in platform maintenance. Day to day operation and maintenance of the Denodo Platform (server/Application/Cloud Infra). Managed server operations, patch updates, JRE upgrades. Managing and fixing server using SSH. Use Performance optimization. Participated in business sessions with business users and Tech lead for better understanding of the reporting requirements. Participate in Daily Status call and Scrum Review and Retrospective calls. Provide required privilege to users. Provide required support to users through global mail or servicenow. Working on Agile Kanban board. IT-Testing and Quality checks using EA (enterprise architect). Creating and managing scheduler jobs. Creating AD groups and Managing TLS certificate management.
Project 2:
June 22, 2026 – Present
The objective of project is to maintain retail sales data in enterprise data warehouse system using Talend. There are multiple business applications used by client's data. We will fetch the data, Transform and build a data to provide business insights. Participated in JAD sessions with business users and Tech lead for better understanding of the reporting requirements. Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts and loading data into snowflake (EDW). We have extracted the data from different sources using ETL tools. SQL Server, Oracle data through Talend, we have extracted and placed in snowflake stage, S3 Bucket. We implement Transformation logic in Talend while writing the SQL Query's or Procedures. Incredibly good knowledge in AWS S3 and its components. Participate in Daily Status call, Scrum Calls, and do Health check reports on jobs. Experience in Unit Testing, Code review and working with SPEC and API document. Involved in the deployment and scheduling the Jobs in TAC. Database Components - tDBInput, tDBOutput, tDBCommit, tDBConnection and Bulk Components. Data Quality Components - tSchemaComplianceCheck, tUniqRow, and do Exception handling. File Components - tFileInputDelimited, tFileOutputDelimited, tFileInputFullRow, tFilelist, tFileCopy, tFileExist, tFileArchive. Orchestration Components - tWaitForFile, tParallelize, tPrejob, tRunjob, tPostjob, tUnite. Expert in using different components in Talend like Processing Components - tFilterRow, tAggregateRow, tSampleRow, tFilterColumns, tNormalize, tDeNormalize, tMap and tJoin. Logs & Error Components - tDie, tLogCatcher, tStatCatcher, tLogRow.
Project 3:
June 22, 2026 – Present
The company wishes to allow certain customer/policy information to be updated directly from the Extranet to provide a quicker solution than is currently available and as a result to provide a better service to extranet users and to reduce the number of calls that are made to Capita and the resulting back-office effort to make the changes requested. Used various trigger in TAC to schedule the job. Used designer debugger to test the data flow and fix the mappings. Involved in the code review, unit testing, peer review and documentation. Involved in the deployment of code in Development. Designing and developing the ETL Mapping Specification based on the Business requirements & specifications and designing the ETL process. Data extraction from source systems, cleansing & transforming the data in staging and finally loading the data into warehouse schemas. Performed efficient testing of the ETL mappings and the transformed & cleansed data in Dev and SIT environments to match the user requirements and the data quality in the warehouse. Designing the mapplets, Create Joblets, Transformations and documentation. Analyzing the job running time and improving the performance. Involved in reviews, performance testing and Unit Testing. Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs. Monitoring the Jobs and work on SLA Change Request (CR). Performed Unit tests and validates results with Business Analyst and end users. Having experience in remote repository (Github and nexus).
Project 4:
June 22, 2026 – Present
The objective of project is to build an enterprise data warehouse system using Talend. There are multiple business applications used by client data. We have to be collected and build a data warehouse to provide business insights. Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts and loading data into snowflake. We have extracted the different sources using ETL tools. Worked as ETL Developer in Data loading Phase from Excel, Oracle and CSV files to Oracle. Taking Ownership of the project for Future Change Requests. Translated Business processes into Talend Jobs by using various Components. Prepared Design documents, Use case Documents and Test Cases Documents. Tuned the Jobs for its better performance. Understanding the source and target data model. Create and monitor Talend Jobs using ETL frameworks techniques. Deployment in local and remote directory. Scheduling the jobs in Task scheduler.
Project 5:
June 22, 2026 – Present
The objective of project is to support the data models using Talend. There is HR application to manage for payroll services by client data. We have to Fetch and maintain a flow in data warehouse. Understanding the source and target data model. Involved in business requirement analysis gathering and understanding the functional specification. Created and inserting data using Sequel (SQL Server). Creating simple jobs and modifying existing Jobs. Created various jobs in Talend for implementing business logic. Worked with different sources such as Oracle & files. Extensively used for joining different sources using tMap components. Used different methods, functions in tMap for doing transformation logic.
Cultural Fit Analysis
The candidate has worked across various companies (HCL, Amazon, Trupp Global, Nvidia Graphics, Tracxn Technologies) and projects, indicating adaptability to different organizational cultures. The project descriptions show a focus on data engineering roles, aligning well with the target role. The breadth of tools and technologies used (Talend, Denodo, AWS, Azure, SQL, Oracle, JIRA) suggests a willingness to learn and apply diverse solutions.
Soft Skills & Operational Fit
The candidate demonstrates experience in Agile methodologies, daily status calls, scrum reviews, and user support, indicating a good operational fit. Participation in JAD sessions and business user interactions suggests decent communication and collaboration skills. However, the resume's overall clarity and conciseness could be improved.