Currently working as Sr Talend Developer, having 12+ Years of IT experience in Data Warehousing Projects. Worked on different phases of Data Warehouse development lifecycle – Designing, Development, Testing and Code Deploying to Production. Requirement gathering from end user converting the requirements into technical documents. Expertise in creating Data Warehousing Architecture and concepts. Expertise in Data modelling, where I have created Conceptual model to logical and physical modelling. Expertise in ETL tool Talend Data Integration, Talend Big Data Integration and Talend ESB. Worked as both Architect and developer on Talend Data Integration 8.x and Talend Big Data Integration 7.x and 6.x. Worked on various scenarios on files like file consolidation, fetching latest date file from a directory, point of failure recovery and dynamic file generation. Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Job level and System in ETL Process. Successfully installed Talend (TAC and TMC) and its supporting applications like Job server, Nexus Repository, Audits Database and SVN/Git Repository on Linux machines and configured them in TAC. Designed overall architecture and Admin activities of the code migration from Talend 6 to Talend 8. Successfully installed and Configured Talend Management Console along with its support applications (GIT and Remote Engine paring) Creating the users and projects in TAC/TMC and assigning the Projects to the respective users. Designed various Jobs for extracting data from various sources involving relational tables and flat files and API’s. Extracting/Uploading Flat files from various cloud services like Salesforce, AWS S3 bucket, GCP cloud, Azure blob storage, Network Drive and SFTP’s using Talend components. Implemented performance tuning and optimized the code to run in respective time duration. Experience in managing large Analytic teams and applications service intake into operations. Created customised jobs for both SCD type 1 and 2 using Talend studio. Handled dynamic Schemas from data sources. Created Error Handling mechanism includes job statistics, logs, email notifications of job status. Capturing source and targets statistics like count, rejected records which are not falling under requirements. Experience in converting the Store Procedures logic into ETL requirements. Created SQL and PLSQL scripts for developing Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) objects. 5 years of experience in Data lineage/catalog. In which we analyse operations and analysis results are displayed in the view. Data linage results trace backword the component and transforms the data in the output column name passes through before being written in the column. I have generated data linage export to HTML that gives a description of the project that holds the analysed Jobs in addition to a preview of the analysis graphical results. Created Pipelines in Talend Data catalog and deployed them to cloud. Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment. Worked on multiple databases like Salesforce, Snowflake, PostgreSQL, MSSQL, MySQL, Oracle 11g, and Amazon Redshift. Expertise in migrating the projects from one database to another data base. Created Re-Usable objects like joblets for business logics. Uploading files to HDFS and loading them into Hive tables. Created tables in Hive databases based on requirement (internal and external tables) and Stored formats like text file and ORC. Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success. Highly skilled software development professional bringing enormous talents for software design, development and integration. Offering advanced knowledge of in-demand programming languages. Background writing code and developing systems for [Industry] applications.
Talend Data Integration Certificate
Azure AI Fundamentals