Database Architect/Oracle

Responsibilities:

-Lead, participate in gathering business requirements, analysis of source systems, define underlying data sources and transformation requirements, design suitable data model, and develop metadata for the Datawarehouse/Analytical Reporting. -Prepare Technical Design/Specifications; develop routines for data extraction and loading. -This is a highly technical role requiring critical thinking, hands on development, and attention to detail from analysis through implementation and post-production QA/oncall. Provide technical/user documentation and training; perform peer reviews of work items produced at various stages of the project. -Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts. -Demonstrate passion for quality and productivity by use of efficient development techniques, standards and guidelines. -Analyze and determine the impact of technology capabilities and limitations, translate high level design to detailed design specifications, develop, test and deploy code/application in various environments. -Perform effort estimation for various Datawarehouse activities; meet project deliverables as per requirements, on time within budgets.

Qualifications

-Strong Computer science background required. A Bachelor's degree or higher in computer science is required with a minimum of 5+ years of industry experience. -4+ years in working with large data sets and analysing data to identify patterns. -5+ years in data warehousing projects with at least 4 years of full life cycle experience in implementation and support of DW Solutions on Oracle Platform. -Must have extensive knowledge in ETL, Oracle 9i/10g/11g and SQL & PL/SQL. -Must have extensive knowledge in Datawarehouse designing techniques like Star Schema/Snowflake. -Extensive design and coding skills in Perl, Shell script, XML on Unix Platforms. -Knowledge of tuning and scaling in a Datawarehouse environment is highly desired.

Additional Preferred Qualifications:

-Hands-on experience with OBIEE 11g. -Should have very good technical expertise and strong business skills, as he/she will lead the team in delivering Business Intelligence solutions. -Must be aware of testing process and DW implementation methodologies. -Knowledge of Hyperion, Discoverer 10g etc will be an added advantage. -Strong customer focus, ownership, urgency and drive. -Excellent communication skills and the ability to work well in a team. -Effective analytical, troubleshooting and problem-solving skills. -Experience in Erwin Datamodelling and Data Quality tool.