Job Description :
Design, develop, validate and deploy the Talend / Any other ETL Tools’ processes.
Talend knowledge is preferable with 5+ year of experience on ETL.
Experience in Data Integration projects between different data sources like Oracle, SQL Server and PostgreSQL
Understand requirements, existing systems data flows, and databases well enough to propose and implement enhancements and improvements.
Minimum 2 years of experience in writing advanced experience in SQL scripting including but not limited to
o All types of joins
o Partitioning and ranking the data
o Aggregation
o Lead and lag functions
Understand Indexing strategies, Performance Plans for supporting a high volume, always available application.
Good experience in UNIX scripting including commands like AWK, GREP, SED,Iteration and traversing through files for processing.