Database Architect/Oracle

Company Description

SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

Job Description

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.