Note: Please submit with the below self rating and questionnaire, then only we can process further. Overall experience anywhere between 7-9 years Strong SQL backgrounded experience 3+ years of experience in Talend Have worked on DW projects and demonstrate understanding of DW concepts. Shell scripting. Working experience in AWS cloud technologies would be preferable. At least knowledge on them is good Work with business users to define and understand business requirements related to changes and enhancements of existing enterprise data warehouse. Understand existing ETL tool business logic / rules, data sources and convert same ETL jobs to Talen arch and resolve production issues with ETL workflows Perform unit testing of development jobs before submitting it to Business UAT, develop technical documentation, including requirements documents, process overviews, data models, data flow At least 5 Years of Proficient experience in designing and developing of mappings, transformations, sessions and workflows, and deploying integration solutions using Talend tool Strong experience in performance tuning of ETL processes Proficient in data integration between different sources to Oracle. Extensively worked on data extraction, Transformation and loading data from various sources like Oracle and Flat files, in Talend Knowledge and experience of working on SQL Queries and database scripting (procedures, functions, jobs, physical data model creation) Experience in Development, Support, Maintenance, and Enhancement projects. Migration project experience will be preferred Candidate should provide below Self Rating & Questionnaire for next process, without this, we can’t process the resumes. Technology No. of years experience Self-Rating 0-5 (5 being highest) Comments SQL coding SQL Performance Tuning DW Models Dimensions & Facts Talend ETL WS Cloud Scripting (Shell or Python) Answer the below question (Must): What are the various databases that you have worked? Also mention the types like columnar, RDBMS, No-SQL & etc. Briefly explain the types of SQL’s or PL/SQL’s that you have written in your overall experience. Provide couple of examples on how you did the SQL Performance tuning in your experience. What type of DW models that you have worked and how strong you are in those? What type of Dimensions and Facts that you have used in overall experience? What are the typical Talend components that you have used? How many routines & Joblets that you have written in Talend? Provide couple of scenarios for which you have created these. What are the various AWS technologies that you have worked? If any experience with Redshift, what are the typical things that you did in Redshift? Did you work on any programming like Shell scripting, Python & etc.? If yes, provide couple of scenarios where you have written the program. Do you have experience in playing the role of “onsite lead”, with responsibility to oversee offshore team’s work?
SQL shell Python Amazon Web Services (AWS) Amazon Redshift ETL Talend dimensions Oracle flat-file