Job Description & How to Apply Below
For h1bs Passport Mandatory
Pl/SQL, Data modelling, ETL, Tableau Dashboard, UNIX, Shell Oracle 10g, Mongo DB
• BS or Foreign Equivalent in Computer Science or Engineering, Masters preferred • 5 years of experience with PL/SQL programming and performance tuning • 5 years of experience in modelling databases • 5 Years of experience writing Data transformation ETL procedures. • 2 Years on Tableau Dashboard Reporting • Ability to extract, compare, manage data in a database • Experience with UNIX, Shell scripting • Excellent verbal and written communication skills • Experience must have included Use of Oracle SQL and PL/SQL, Oracle 10g, 11g and NoSQL DB including Mongo DB.
• Work as part of a project team to coordinate database development and determine project scope and limitations. • Responsible for the development of new database system and the maintenance of such using Oracle SQL and PL/SQL. Also responsible for detailing and documenting the database applications/models and supporting quality assurance activities and development efforts as part of the Data Management team. • Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. • Guide Application development teams walk through the data models and help them create data retrieval queries. • Designing, customizing and maintaining ETL (Extract, Transform, Load) data integration with the aim of optimizing efficiencies for VES enterprise Reporting model. • Modify existing databases and database management systems or direct programmers and analysts to make changes. • Ensuring existing database documentation and information has been accurately and completely inputted to maintain up-to-date data management systems for analysis purposes and creating trouble-shooting solutions as required. • Experience gathering and refining requirements, interviewing business users to understand and document data requirements including elements, entities and relationships, in addition to visualization and report specifications on Tableau. • Advanced SQL skills– strong understanding of relational and dimensional data models. • Undertaking analysis of existing database structures to prepare reports and recommendations for upgrades and/or improvements to models and functions.
- provided by Dice Pl/SQL, Data modelling, ETL, Tableau Dashboard, UNIX, Shell Oracle 10g, Mongo DB
1 to 2 Years