Connecting Talent with Opportunity

Job Detail

Application DB Developer

Salary 20-28 lpa

  • Pune
  • 01 Nov 2018

Consultant himanshu.gupta@elementsmanpower.com

JobRef BTCI11012018004

 Your Role

o   In-Depth knowledge in Oracle 11G/12C , PL/SQL , UNIX. Comprehensive Experience in Data Modelling tool such as ERWIN, TOAD, SQL DEVELOPER.

o   Demonstrable experience in  developing, validating, maintaining logical and physical dimensional data models, sound concepts of data modeling including star schema, snowflake schema, etc.

o   Analyze functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models using best practices to ensure optimize  data quality and reduce redundancy.

 

Essential Skills

·       In-Depth knowledge in Oracle 11G/12C , PL/SQL , UNIX. Comprehensive Experience in Data Modelling tool such as ERWIN, TOAD, SQL DEVELOPER.

·       Demonstrable experience in  developing, validating, maintaining logical and physical dimensional data models, sound concepts of data modeling including star schema, snowflake schema, etc.

·       Analyze functional and non-functional business requirements and translate into technical data requirements and create or update existing logical and physical data models using best practices to ensure optimize  data quality and reduce redundancy.

·       Evaluate existing data models and physical databases for variances and discrepancies. Perform general technical troubleshooting and give consultation to development team for complex changes.

·      Perform application, database and operating system tuning, performance monitoring and investigative troubleshooting for various applications.

 

Desirable Skills

·       Review modifications of existing codes to improve efficiency and performance.

·       Develop best practices for standard naming conventions and coding practices to ensure consistency of data models. Perform reverse engineering of physical data models from databases and SQL Scripts.

·       Analyze data-related system integration challenges and propose appropriate solutions. Design, development and testing of Archive and restore, disaster recovery solutions.

·       Perform data analysis task  for data profiling, data quality assessment, creation of data mapping and data lineage

Apply

Get in Touch

  • 101 & 101 A, 1st floor, D-Mall, Netaji Subhash Place, Pitampura, Delhi-34
  • 011- 41036660, 47075709
  • info@elementsmanpower.com