Senior Consultant/Team Lead-OIC Developer

Senior Consultant is responsible for enhancing the internal business specifications and technical design for business features. The key responsibilities include design, develop, and implement ETL codes, support production ETL bug fixes, liaise with other developers in optimizing the in-application SQL statements as necessary and establishes best practices. 

Responsibilities

• Understand the values and vision of the organization and align the activities accordingly
• Protect the Intellectual Property
• Adhere to all the policies and procedures
• Work with other line functions to collect or provide relevant data
• Develop and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules.
• Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Experienced in building/customizing ETLs from Source Systems such as Fusion, Salesforce to Data Warehouse.
• Experience in performance tuning Data Warehouse to meet Business Intelligence needs for applications such as Fusion applications and OBIEE.
• Experience in creating ad-hoc analysis and Dashboards using OBIEE Answers.
• Strong understanding on Data Warehousing concepts such as Star and Snowflake schemas.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses.
• Experienced in developing stored procedures, functions, packages and database triggers using Oracle SQL Developer and PL/SQL to improve query performance.
• Strong SQL knowledge. Familiar with creating queries, tables, views and other relational objects, and maintaining the referential and data integrity.
• Transform business requirements and functional specifications into technical design documents and develop as per the design to meet project requirements

Essential Skills

Job 

• Excellent written and verbal communication skills are essential
• Must be proficient in customer relationship management
• Must have hands on experience on Oracle Data Integrator.
• Must have experience of working on ETL tools.
• A strong background in SQL and PL/SQL is preferred.
• Must be dynamic, flexible and possess perseverance skills

Personal 

• Should understand the business objectives and organization structure
• The candidate must have strong work ethics andtrustworthiness 
• The candidate should possess attention to detail and maintain confidentiality and integrity
• Must be highly collaborative and be a team player with commitment to excellence
• Ability to work under pressure to achieve the multiple daily deadlines for client deliverables with a mature approach

Preferred Skills

Job

• Should be proficient in Microsoft Office
• Self-motivated, fast learner with the ability to operate independently
• An ideal candidate should also have knowledge in Performance Tuning SQL and PL/SQL code

Personal 

• Demonstrate proactive thinking
• Should have strong interpersonal relations and business acumen
• Negotiation and persuasion skills are required to work with partners and implement changes
• Have the ability to work under stringent deadlines and demanding client conditions
• A very inquisitive mind that can factor in several variables acting on the situation

Preferred Skills

Job

• Should be proficient in Microsoft Office
• Self-motivated, fast learner with the ability to operate independently
• An ideal candidate should also have knowledge in Performance Tuning SQL and PL/SQL code

Personal 

• Demonstrate proactive thinking
• Should have strong interpersonal relations and business acumen
• Negotiation and persuasion skills are required to work with partners and implement changes
• Have the ability to work under stringent deadlines and demanding client conditions
• A very inquisitive mind that can factor in several variables acting on the situation