Job Seekers, Please send resumes to resumes@hireitpeople.com
Detailed Job Description:
- Experience with Data flow diagrams, Data Dictionary, Database Normalization theory techniques, Entity relation modeling and Design techniques.
- Experience in the analysis, design, development, testing and implementation phases of Software Development Life Cycle SDLC
- Experienced in defining, designing, integrating and re-engineering the Enterprise Data warehouse and Data Marts in different environments like Teradata, Oracle with multiple Terabytes of size and various levels of complexity.
- Working experience in implementing large Teradata DBMSs.
- Expertise in backend development using SQL, PLSQL (Oracle 12c/11g/10g/9i), SQL * PLUS, TOAD, SQL Developer and PL/SQL Developer.
- Experienced in master data management (MDM), Metadata management, data quality
- Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modelling with Teradata and Oracle.
- Excellent scripting knowledge in developing databases using Teradata SQL
- Good knowledge of key Oracle performance related features such as Query Optimizer and Execution Plans.
- Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB, DBMS_DEBUG, DBMS_ERRLOG and UTL_FIL
- Eexperience in the analysis, design, development, testing and implementation phases of Software Development Life Cycle SDLC.
Minimum years of experience*: 5+