Should have min. 15-18 yrs of experience and must be well versed with Oracle + another RDBMS, DB design, Data warehousing, data mart, OLAP, Business Intelligence Tools, ETL/Informatica, PL/SQL, Big Data/Hadoop/Document databases. This person should have good educational background From IIT or NIT and has worked for MNCs onsite or offshore
* 15+ years of hands on experience as Architect
* Experience within Data modeling and working knowledge in any of ETL tool are required
* Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.
* Hands-on development of complex SQL queries, stored procedures, functions, packages, triggers using PL/SQL.
* Create, develop, and deploy enhancements and bug fixes to support ongoing operations of the warehouse database
* Create DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences.
* Strong understanding of schema design and SQL
* Development experience with PL/SQL, SQL, Oracle, or other database technologies
* Nice to have XML, NOSQL & JSON skills
* Strong problem solving and communication skills, and a results oriented attitude
* Ability to learn quickly and deliver high quality code in a fast-paced, dynamic agile team environment