$7.0 per Hour
Around 3.5 years of IT experience in all the phases of software development life cycle which are Analysis, development, design, implementation and testing.
Good experience with both Talend open studio and Talend Enterprise platform.
Strong analytical and conceptual knowledge in database design and development using Oracle 11g/10g, SQL Postgres and UNIX Shell scripting.
Having experience in project analysis and cost estimation and also Working with clients to gather the requirements and also the deliverables.
Having experience on Talend Data integration suite and Talend Bigdata Integration suite for design and development of ETL and mappings for enterprise ETL Talend projects.
Knowledge in Talend implementation and administration. Solid ETL knowledge on talend administration center, implementing time and event based schedule, performance tuning and troubleshooting.
Designing and creating ETL mapping processes using Talend.
Experience in extraction, transformation and loading of data from various heterogeneous source systems like flat files (.txt, XML,JSON) and relational database.
Experience in creating context variable to store metadata information of all the sources and targets.
Also good practical understanding of the database schemas like star schema and snowflake schema used in relational and dimensional modeling.
Worked in creating design documents, use case documents, test conditions and also good knowledge of facts and dimensional tables and slowly changing dimensions.
Excellent communication and interpersonal skills.
Tech Stack Expertise
- January 2019 - December 2022 - 4 Year
- March 2021 - October 2022 - 20 Months
Ecommerce platform Development Company that have clients who are operating in different sectors like consumer products, electronics, jewelry, groceries, furniture and the service industry.
Some of the other services provided by MAGENTO IT Solutions are UI/UX design, SEO, paid advertising and digital strategy.
Design and develop en-to-end ETL process from various source systems to staging area, from staging to Data Marts.
Analyzing the source data to know the quality of data by using Talend Data Quality.
Developed jobs in Talend enterprise edition from stage to source, intermediate, conversion and target.
Involved in writing SQL Queries and used Joins to access data from Oracle and MySQL
Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store procession state.
Solid experience in implementing complex business rules by crating re-usable transformations and robust mappings using talend transformations like tConvertType, tSortRow,tReplace, tAggregaterow,tUnite etc.
Developed Talend jobs to populate the claims data to data warehouse – star schema.
Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and incremental loading and unit tested the mappings.
Integrated java code inside Talend studio by using components like tJavaRow, tJava, tJavaFlex and routines.
Created context variables and groups to run Talend jobs against different environments.
Implemented FTP operations using Talend Studio to transfer files in between network folders as well as to FTP server using components like tFileCopy, tFileArchive, tFileDelete, tCreateTemporaryfile, tFTPDelete, tFTPCopy, tFTPRename, tFTPut, tFTPGet etc.
Extracted data from flat files/databases applied business logic to load them in the staging database as well as flat files.
Been part of all the scrum meetings, refinement calls and retrospective calls.
Also been a part of production release nights.
Using JIRA for the bugs/tasks tracking.
- January 2019 - March 2021 - 27 Months
Deals with many companies some of them are Zoom, Coca-cola, Made in CookWare, Consensus, Adobe and P&G. Does all kinds of custom software development including product strategy, product design, full-stack engineering and digital marketing, eCommerce.
Most of the work is based on eCommerce. They deal with all the data of merchandise from the clients.
Participated in all phases of development life cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
Created talend jobs to copy the files from one server to another and utilized Talend FTP components.
Created and managed source to target mapping documents for all facts and dimension tables.
Used ETL methodologies and best practices to create Talend ETL jobs. Followed and enhanced programming and naming standards.
Created and deployed physical objects including custom tables, custom views, stored procedures, and indexed to SQL server from staging and data mart environment.
Design and implemented ETL for data load from heterogeneous sources to SQL server and oracle as target databases and for Fact and slowly changing dimensions SCD-Type1 and SCD- type2.
Extensively used tMap component which does lookup & joiner functions, tJava, tOracle, txml, tdelimitedfiles, tlogrow, tlogback components etc.
Good experience in understanding business application, business dataflow and data relation.
Worked on various talend components such as tMap,tFilterRow,tAggregateRow,tFileExist,tFileCopy,tFileList,tD ie etc.
Developed stored procedure to automate the testing process to ease QA efforts and also reduced the test timelines for data comparison on tables.