Atos
Location
India | India
Job description
TBC
ETL Lead - 8 to 12 or years or greater 1.Hands-on Experience in CDC (Change Data Capture) Concept.2.Extensively worked on SQL database objects which includes creating database objects (DDL), SQL's(DML), and proving access to data base objects (DCL), Indexing , primary and secondary keys.3.Extensively worked on writing complex SQL's which includes aggregate functions , Left joins, Right joins , Full joins , Unions , Sub-Queries , OLAP functions and etc.4.Extensively worked on PL/SQL Packages, Views, External tables, data partitions and Exception handling for retrieving, manipulating, checking complex data in Oracle5.Experienced in performance tuning , optimizing complex SQL's , troubleshooting common database issues , Data analysis and implement the best practices in SQL's.6.Strong in DWH concepts , ETL procedures to extract and load data , MPP architecture and data modeling which includes creating data marts ( facts and dimensional tables) using star schema7.Knowledge about Data Lake / Object store in Oracle Cloud platform or any other cloud platform is added advantage8.Knowledge about Oracle Exadata & Oracle golden gate framework are added advantage9.Proficient understanding of code versioning tools such as Git .10.Supply chain domain experience is mandatory.Job tags
Salary
