Oracle PL/SQL Developer with PythonIn this role, you would be part of the data integrity/analysis team in the Banking and financial domain. You will be responsible to independently build data analysis around complex business problems from data available in the client owned or accessible systems. For these tasks, you would be encouraged to understand the business ask/problem, assess the scope, quantity and quality of the available data, prepare and build the Data pipeline, and loading data into DWH and Data Mart for downstream consumption team.ResponsibilitiesOracle DB and Python Developer with extensive experience in PL/SQL and Python.6+ years of relevant experience and skilled in Oracle Database with hands on exposure.Exposure to data analysis and data crunching on database with very good SQL skills.Good hands-on on PL/SQL including Stored procedures, functions, view, materialized views, cursors and exception handling.Person shall have good knowledge on Window functions, analytical functions, CTE, Merge.Very good experience in reading SQL plans, performance tuning, partitioning and other techniques.Very good SQL expertise in Joins, Analytical functions and triggers.Person should have worked on python dtypes like list, dictionariesHands-on and good experience on python libraries like pandas, sys, os, logger, argument parser, oracle conn libraries.Good exposure to string handling and email function using python.Experience in Agile/Scrum based project executionsGood to have knowledge on CI/CD using Jenkins/Bamboo.Good to have python experience with hands-on experience on pandas, snowpark, data crunching, connecting other RDBMS.Good to have Cloud knowledge on AWS services like S3,Team player, collaborative approach and excellent communication skillsCandidate should be good in communication and articulationQualifications we seek in you Minimum qualificationsGraduate/B Tech/MCAKnowledge/exp.
of Banking or Capital Markets is an added advantage for this positionPreferred qualificationsOracle DB and Python Developer with extensive experience in PL/SQL and Python.6+ years of relevant experience and skilled in –, Oracle Database with hands on exposureExposure to data crunching and analysis on database with very good SQL skills.Good hands-on on PL/SQL including stored procedures, functions, views, materialized view, cursors and exception handling.Person shall have good knowledge on Window functions, analytical functions, CTE, Merge.Very good SQL expertise in Joins, Analytical functions.Person should have worked on python dtypes like list, dictionaires, tuplesGood to have exposure on python libraries like pandas, sys, os, logger, argument parser, oracle conn libraries.Good to have exposure to string handling and email function using python.Good to have experience in Python programming for ETL.Experienced in SQL performance tuning, analytical functions, joins and troubleshootingKnowledge on CI/CD using Jenkins/BambooExperience in Agile/Scrum based project executions