Posted 3y ago

Tech Lead (Talend+SQL)

@ Virtusa
India
OnsiteFull Time
Responsibilities:design mappings, deploy workflows, tune performance
Requirements Summary:Talend + SQL expert with 7-9 years total exp; DW concepts; shell scripting; AWS knowledge; ETL design, mapping, and deployment; production issue resolution; unit testing; documentation; Oracle data integration.
Technical Tools Mentioned:Talend, SQL, Shell scripting, AWS, Oracle
Save
Mark Applied
Hide Job
Report & Hide
Job Description

1. Minimum 3+ years of experience in Talend, with overall experience anywhere between 7-9 years

2. Strong SQL knowledge

3. Have worked on DW projects and demonstrate understanding of DW concepts.

4. Shell scripting.

5. Working experience in AWS cloud technologies would be preferable. At least knowledge on them is good

6. Work with business users to define and understand business requirements related to changes and enhancements of existing enterprise data warehouse.

7. Understand existing ETL tool business logic / rules, data sources and convert same ETL jobs to Talen arch and resolve production issues with ETL workflows

8. Perform unit testing of development jobs before submitting it to Business UAT, develop technical documentation, including requirements documents, process overviews, data models, data flow

9. At least 5 Years of Proficient experience in designing and developing of mappings, transformations, sessions and workflows, and deploying integration solutions using Talend tool

10. Strong experience in performance tuning of ETL processes

11. Proficient in data integration between different sources to Oracle.

12. Extensively worked on data extraction, Transformation and loading data from various sources like Oracle and Flat files, in Talend

13. Knowledge and experience of working on SQL Queries and database scripting (procedures, functions, jobs, physical data model creation)

14. Experience in Development, Support, Maintenance, and Enhancement projects.

15. Migration project experience will be preferred