Data Engineer

Job Description

*Data EngineerJob Summary:Provide prompt and effective support, maintenance and development on OBIA based Analytics Datawarehouse using Oracle Data Integrator - ODI as underlying ETL Tool.The position is responsible for designing, implementation and development and maintenance of ODI environment. The requirements of the position include Datawarehouse Maintenance, ETL Development & Support, performance tuning and expertise in dimensional modelling and designRoles and Responsibilities: Candidate will be responsible to design end to end solutions to cater to business needs of data in Oracle BI Tool stack especially ODI and SQL. Responsibilities:

• Expertise in designing custom Data warehouse solutions specific to business needs.
• Expertise in Dimensional Modelling (using Star / Snowflake schema) and drafting High Level and Low Level DWH Design
• Expertise in preparing Data lineage sheets.
• Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
• Expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs.
• Experience of automating various ETL jobs, failure notification etc
• Ability to review and suggest DWH Design optimization solutions.
• Expertise in performance tuning of mappings in ODI and SQL query tuning.
• Production Support of Daily running ETL loads, monitoring, troubleshooting failures and bug fixing across environments
• Expertise in Multiple databases (Oracle/ SQL Server/etc) including complex SQL, query debug and optimization
• Should have strong understanding of Business Analytics, data warehouse analysis, design, development & testing.
• Strong understanding of Change Management Processes and basic understanding of SBM and ServiceNow

Required Skills and Experience:

• 5+ years of relevant experience working in OBIA on ODI as the ETL tool in BIAPPS environment.
• Exposure to working in other ETL tools.
• Ability to work on highly complex problems and provide feasible solutions in time.
• Ability to review and suggest improvements in existing DWH solution.
• Ability to work in a demanding user environment.
• Ability to provide trainings on ETL, DWH and Dimensional modelling.
• Ability to guide and help team members in technical issues.
• Strong Written and Oral communication skills.
• 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:

• Ensure Accountability
• Customer Focus
• Manages Complexity
• Plans and aligns
• Manages Ambiguity
• Optimizes Work Processes

, *Data EngineerJob Summary:Provide prompt and effective support, maintenance and development on OBIA based Analytics Datawarehouse using Oracle Data Integrator - ODI as underlying ETL Tool.The position is responsible for designing, implementation and development and maintenance of ODI environment. The requirements of the position include Datawarehouse Maintenance, ETL Development & Support, performance tuning and expertise in dimensional modelling and designRoles and Responsibilities: Candidate will be responsible to design end to end solutions to cater to business needs of data in Oracle BI Tool stack especially ODI and SQL. Responsibilities:

• Expertise in designing custom Data warehouse solutions specific to business needs.
• Expertise in Dimensional Modelling (using Star / Snowflake schema) and drafting High Level and Low Level DWH Design
• Expertise in preparing Data lineage sheets.
• Expertise in Data warehousing concepts like SCDs, Dimensional Modelling, Archive strategy, Aggregation, Hierarchy etc and Database concepts like Partitioning, Materialized views etc
• Expertise in ODI development (in BIAPPS Environment) & performance tuning of SQL programs.
• Experience of automating various ETL jobs, failure notification etc
• Ability to review and suggest DWH Design optimization solutions.
• Expertise in performance tuning of mappings in ODI and SQL query tuning.
• Production Support of Daily running ETL loads, monitoring, troubleshooting failures and bug fixing across environments
• Expertise in Multiple databases (Oracle/ SQL Server/etc) including complex SQL, query debug and optimization
• Should have strong understanding of Business Analytics, data warehouse analysis, design, development & testing.
• Strong understanding of Change Management Processes and basic understanding of SBM and ServiceNow

Required Skills and Experience:

• 5+ years of relevant experience working in OBIA on ODI as the ETL tool in BIAPPS environment.
• Exposure to working in other ETL tools.
• Ability to work on highly complex problems and provide feasible solutions in time.
• Ability to review and suggest improvements in existing DWH solution.
• Ability to work in a demanding user environment.
• Ability to provide trainings on ETL, DWH and Dimensional modelling.
• Ability to guide and help team members in technical issues.
• Strong Written and Oral communication skills.
• 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:

• Ensure Accountability
• Customer Focus
• Manages Complexity
• Plans and aligns
• Manages Ambiguity
• Optimizes Work Processes

Keyskills :
sqljavadata warehousinginformaticapythonend to end solutionsetl tooloracle bidata integratorproject managerschange managementbusiness analytics