Etl Talend

Job Description:ETL Talend Developer • Write and administer ETL jobs to extract data from multiple data sources and load into DataMart’s. • Integrate data from different data sources: databases, csv files, xml files, queues • Integrate data for batch, near real-time, real-time latencies. • Organize data at different aggregation levels, hierarchies • Write complex data transformation logic. • Proactively monitor the performance of data jobs and tune the jobs as needed. • Make the data integration jobs fault tolerant and scalable. • Perform Data quality, data modeling and database tasks as required. • Expected to provide 2nd level support beyond office hours occasionally. • Write Java programs.REQUIRED SKILLS:Must be fully proficient with development and administration of Talend Open Studio and Talend Server.Exp into Talend Studio 7.2, AWS S3, AWS Redshift, Azure Synapse, Azure Blob storage, Windows, Linux, Aurora DB, MY SQLProgramming ability in Java Thorough knowledge and hands on experience with dimensional Data modeling. Experience working with Oracle Database. Thorough knowledge and understanding of all aspects of Data warehouse design and development. Strong communication skills in English, written and verbalJava PL SQL DeveloperMin 5+ years of experience into Java & PL SQL developmentSenior Java/PL SQL developer with design, coding, testing, troubleshoot/bug fixes, and documentation expertise around core java and pl/sql.J2EE, Hibernate, Struts, Oracle Reports , Java ScriptMust have exp in Fixed Income/Financials Services for multiuser environments with 20+ users. Strong knowledge of Java, open source UI component libraries, J Boss, Oracle PL SQL, JDBC, Web Services, JMS, Net beans RCP or Eclipse RCP, Maven and Hudson/Anthill Pro is required.Very good knowledge of SQL (aggregation functions, Joins and various built-in SQL functions and data types)