NR Consulting - India
OBIA on ODI -ADW Senior Data Engineer
What's your preference?
Job Description
- Req#: 25-18228
Title: OBIA on ODI -ADW Senior Data Engineer
Location: Pune
Job Description:
Roles and Responsibilities:
Candidate will be responsible to provide solution design, implementation, migration and support in Oracle BI Tool stack especially ODI and SQL.
Responsibilities:
• ODI development (in OBIA Environment), enhancements and support would be the primary responsibility along with performance tuning of SQL programs
• Data warehouse design, development and maintenance using Star Schema (Dimensional Modelling)
• Production Support of Daily running ETL loads, monitoring, troubleshooting failures and bug fixing across environments
• Experience of working in Oracle BI Analytics Warehouse Methodology & Star Schema with good understanding of CM, SDE, SIL, PLP, Knowledge Modules, Load Tracking tables, Metadata etc
• Experience on working with different data sources Oracle, CRM, Cloud, Flat Files, Sharepoint and other non-oracle systems
• Experience in performance tuning of mappings in ODI and SQL query tuning.
• Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
• Migration and other deployment activities in Oracle BI tool stack(ODI), Kintana and PVCS
• Working knowledge of OBIEE
• Must have strong Oracle database experience including complex SQL, query debug and optimization
• Should have strong understanding in BI/data warehouse analysis, design, development & test experience
• Strong understanding of Change Management Processes and basic understanding of SBM and ServiceNow
Required Skills and Experience:
• 5-7+ years of relevant experience working in OBIA on ODI as the ETL tool in BIAPPS environment.
• Ability to work in a demanding user environment.
• Strong Written and Oral communication skills.
• Knowledge on Tools like Serena Business Manager and Service Now
• Knowledge on SDLC and change management process.
• Coordinating among various teams for day to day activity.
• Working with Project Managers for assistance in various project implementations.
• Designing and improving BI processes for Development and Change Management.
• Ready to work in 24*7 environments.
• Good team player
Required Qualification:
• B.Tech / MCA
Required Competencies:
• Tech Savvy
• Communicate Effectively
• Optimizes Work Processes
• Cultivate Innovation
About the company
Thoughtfully providing global companies with superior staffing solutions from our network of experienced professionals.
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.