Interview: Phone and skype
From the hiring manager :I really want more of a Lead, not a heads down developer who isn't very communicative. This should be a 10+ years of experience, someone very comfortable with interaction with teams and upper management
Key Responsibilities:- Creates and maintains all PL/SQL required for development, testing, education and production usage. Develop MV log refresh script for transfer of Data from OLTP database into EDW. Specifically use the MV log technology as a Change Data Capture tool.
- Design and Develop Database Trigger and Views to enable BI enhanced MV's.
- Organize Data in EDW in different schemas like Staging, CDC, Target.
- Understand the requirement to create Dimensional Model from OLTP system.
- Develop Data structures which allows ROLAP /OLAP Cubes , Use PL/SQL load scripts to perform
- Data load / Transformation.
- Performs ongoing tuning of the database instances. This includes partitioning of Large Tables and Proper Indexing.
- Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
- Implements and enforces row level security for all of the Oracle Databases using security views.
- Understands Row processing using Cursors and Oracle Analytical Function
Qualifications:- In-depth experience in managing/operating information solutions
- Candidate should have a combination of strong communication/facilitation skills with conceptualization/design skills
- Strong applied knowledge of software development efforts through implementation including good design, documentation and supportability practices
- Five years' experience managing multiple complex systems with:
- Demonstrated leadership of multidiscipline, high-performance work teams/groups; and
- Demonstrated high competency in execution of multiple large projects
- Experience working in a program management office (PMO) using project and portfolio management tools
- Candidate should have a minimum of ten years of experience in IT, with at least three years in Deployment, Maintenance and Operations Project Management
- Candidate should have a combination of strong communication/facilitation skills with conceptualization/design skills.
Other Requirements:- Bachelor's degree in computer science, management information systems, or related field
- Knowledge of software implementation methodologies such as SDLC, Agile, etc.
- General knowledge of application architecture and data modeling
- Knowledge of interfacing with various applications, management information systems, data structures, systems analysis and design, and programming languages
- Ability to design, implement and modify systems
- Ability to work effectively in a multi-disciplinary team
- Strong organizational skills
- Verbal and written communication skills
- Interpersonal/human relations skills
- Ability to maintain confidentiality
•
Last updated on Sep 12, 2016