Job Title

Role- Technical Lead Location - Bhubaneshwar, Kolkata Experience- 4-12yrs Desired Competencies (Technical/Behavioral Competency) Must-Have** (Ideally should not be more than 3-5) 1 ) Good knowledge in PL-SQL programming of Procedures,Functions,Triggers, Scripts development using Batch Framework(PL/SQL and Unix) 2 ) Creation of database tables and other schema objects 3 ) Good knowledge of SQL joins,cursors 4 ) Good knowledge of using SQL Developer tool 5 ) Creation of low level technical design document 6 ) Knowledge of SQLPLUS tool for loading flat files to database Good-to-Have 1 ) PL-SQL performance tuning knowledge 2 ) Knowledge of basic Unix commands SN Responsibility of / Expectations from the Role 1 Scripts development using Batch Framework(PL/SQL and Unix) 2 Assigning the Technical Tasks to Team on daily basis 3 Guiding Team to build Interface jobs End to End jobs and transformation scripts using Batch framework. 4 Providing technical solutions to team members, Unit Test results review and Code Review. 5 Preparing the Technical Design Document, UDY enrollment, 6 Control-M template preparation and working with BY team to setup the jobs 7 BY ACT setup and configuration, BY Worksheet, Workbenches, FE pages, searches, Optionsets configuration 8 SCPO Configuration - Nodepools, Access, NodePool Memory etc. 9 SRE node pool and server restart scripts, BY SRE process development, testing and output validation. 10 Production deployement co-ordination with BY team 11 Technical KT sessions to TSL IT and BY Teams after or before Prod Migration