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.