Python / SQL with Spark

Python / SQL with Spark

Must Have Technical / Functional Skills

Primary Skill : PYTHON

Secondary : SQL

Tertiary : Pyspark / Spark

Experience : Minimum 7 years

Roles & Responsibilities

Resource to design, develop, maintain and test software, collaborating with the development team and business partners to ensure successful delivery and implementation of application solutions in an agile environment. Should be hands on and able to successfully deliver on time without defects. Ability to analyze, design and support implementation of Oracle PL / SQL, Views, create / modify database tables based on business requirements and specifications

Responsibilities

• Responsible for developing code in PYSPARK , PYTHON
• Responsible to develop / modify PL / SQL, SQL Views in Oracle
• Responsible to create a new tables / modify existing table structure.
• Performance tuning and good understanding of explain plan
• Normalization, renormalization and star schema
• Develops stored procedures, database triggers and SQL queries
• Must be able to work independently with minimum supervision.
• Responsible to develop test cases and perform unit testing.
• Must be able to interact and co-ordinate with distributed team.
• Must be good in communication skills.
• Responsible to provide regular task status update to the management

Understand and be able to visualize and manage upstream / downstream dependencies.

Work in Agile environments