For Gurgaon based product development MNC involved in medical implants & equipments
General Description:
The Data warehouse off-shore Lead will help manage the planning and delivery of data warehouse architecture design, providing sizing and configuration and performing needs assessments. Analyzes current business practices, processes and procedures, and identifies future business opportunities for leveraging the data warehouse. The Lead should have strong knowledge and understanding of the Oracle Prebuilt analytics ETL architecture and the ability to develop and understand complex ETL mappings. The lead should also closely work with on-site lead to manage workloads among 4-5 team members on-site and off-site.
Essential Functions:
· Reviews and analyzes data warehouse requirements, develops detailed modeling specifications to meet identified requirements.
· Must be able to assist in the data analysis efforts necessary to resolve data issues encountered during the course of the project.
· Responsible for all tasks involved in extracting, transforming and loading data from Oracle E-Business applications into the Oracle Pre-Built analytics Data warehouse.
· Ability to understand and create complex mappings using Informatica PowerCenter and experience using DAC for scheduling and monitoring of jobs.
· Must have experience installing and configuring the Oracle Pre-Built Analytics and DAC software.
· Designing detailed ETL specifications based on business requirements.
· Documentation of all development processes and unit testing.
· Execute test plans and document results and discrepancies.
· Perform data analysis to resolve issues related to source data.
· Mentor junior members of the team.
· Assist in the hiring of required project members.
· Create detailed project plans.
QUALIFICATIONS:
· At least 5 years of experience in developing and deploying Data Warehouse solutions
· Bachelors degree or higher with a strong preference towards computer and base sciences
· Knowledge of the Data Warehouse development lifecycle, including analysis, design, development, testing, and deployment.
· In depth knowledge of Oracle 11i applications
· Understanding of the following ETL development tools, programming languages, operating systems, and databases:
o Must have: Informatica PowerCenter 8.X, Mapping Designer, Workflow Manager, Monitor, Strong PL/SQL, Perl or Shell Scripting, SQL performance tuning.
Strong expertise in ORACLE ETL Prebuilt Packaged Analytic applications v10.1 or higher. Extensive knowledge of Oracle Database. General knowledge of AIX operating system.
o Nice to have: Familiarity with OBIEE reporting environment. Other ETL tools such as Oracle Warehouse builder.
· Extensive prior experience working with Pre-built Informatica ETL
· Hands on experience using execution plans, working with joins and subqueries.
· Must have experience in Building indexes that support efficient queries.
· Use ref cursors and bulk collect for fast performance.
· Must be able to perform STAR transformation tuning and materialized view creation for optimal Oracle data warehousing performance.
· Nice to have understanding of the Oracle 10g architecture.
· Excellent analytical and problem-solving skills
· Strong oral and written communication skills
· Commitment to excellence and high standards
· Versatility, flexibility, and a willingness to work within constantly changing priorities with enthusiasm
· Ability to work on complex projects with general direction and minimal guidance
· Ability to deal effectively with a diversity of individuals at all organizational levels.
· Good judgment with the ability to make timely and sound decisions.
· Ability to coordinate multiple tasks simultaneously.
· Ability to collect, interpret, and/or analyze complex data and information.
· Must be a team player.
· Acute attention to detail
· Strong organizational, problem-solving, and analytical skills.
0 comments:
Post a Comment