Senior Lead Analyst - Implementation Conversion (ETL, PL/SQL)

Requirements

• Graduate in Computer Science or Computer Applications such as B. Sc. / B.C.A. / B. Tech. / B. E./ M.C.A.
• Min 8-10 Years experience overall and major experience in ETL.
• 5-6 years’ experience with ETL tool preferably SSIS, Talend and Adeptia.
• 5-6 years’ experience in writing PL/SQL or T-SQL programming (Stored procedures, functions and Packages) and queries on Oracle / SQL Server databases.
• Strong knowledge on RDBMS concept and OLTP system architecture.
• Competent with other analytical programs like Power BI, Crystal Reports/SSRS, with the desire and ability to understand new software applications
• Experience reviewing query performance and optimizing/developing more efficient code
• Experience with creating table indexes to improve database performance
• Experience writing complex operations, views, stored procedures, triggers and functions to support business needs in a high availability environment
• Strong knowledge on source code control mechanism on any tool.
• Knowledge on GIT / BitBucket is added advantage.
• Strong knowledge of XML and JSON structures and Jenkins.
• Experience of job scheduling and working knowledge on at least one 3rd party scheduler
• Experience utilizing SOAP and REST to access web services
• Ability to analyze and solve problems using learned techniques and tools
• Ability to translate client requirements to technical specifications and participate in Migration and Conversion Strategy.
• Excellent written and verbal communication skills
• Excellent inter-personal skills and comfortable establishing professional relationships especially remotely (electronic, phone, written)
• Proven ability to plan and execute effectively to meet critical time-sensitive objectives
• Ability to effectively work alone and independently
• Experience in either the Banking or Financial Industry is preferred
• Good mentorship skills
• Ability to deliver effectively in high pressure situations
• Added bonus if you have
• Good to have Hands-on languages (Python/Java/C#)

Benefits

• Extensive Health Benefits Program along with the Family Protection Plan
• Best-in-class career mobility options across the globe
• Award-winning learning offerings for career development
• Adaptable home - office work model
• Opportunity to work with global teams and clients