AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
All Filters
1 Schneider Electric BI Engineer Job
Expert BI Engineer
Schneider Electric
posted 11d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Job Description for Senior BI Developer with Schneider Electric India
Schneider Electric (SE) is the global specialist in energy management and automation. SE develops connected technologies and solutions to manage energy and process in ways that are safe, reliable, efficient, and sustainable. SE provides an integrated approach, designed for the reality of digital economy (Plant-to-Plug). The versatile product portfolio addresses all energy needs of industries as well as residential.
Schneider Digital (SD): All IT needs for SE are managed by a group called Schneider Digital (SD); spread across 303 locations in 60 countries with over 2300 staff; along with various engagements with all major Global IT Service Providers.
Role: Senior developer working on BI project which involves OAC RPD design, Data warehousing, Data modelling, Reports/dashboard development and to work in global teams and support global cross-functional environment partnering with internal customers to help, support and enhance business systems
Qualifications & Certifications
1. Engineering Graduate or Master of Computer Applications (MCA)
2. Certified in one or more of the following is an advantage OAC, OAC
Experience
1. 5-8 years of BI experience
2. 5+ years of experience on Informatica, OBI, OAC & SQL (minimum 2-year experience on each of the tool mentioned)
3. Must have worked on at least 2 complete life cycle implementations of BI projects
Required Skills (Must have) along with necessary industry experience
General
1. Experience in any service industry where Oracle BI is extensively used for their global customers with strong customer centric focus.
2. Total experience of 7-10 years, with excellent communication, coordination, and team leadership skills
3. Prior experience in handling E2E Product Operations Lifecycle (Ex: ETL/Report, Incident management/Bug-Fix) and E2E Product Engineering lifecycle (ex: Enhancements and Projects with release life cycle experience)
4. Ability to evaluate technology solution options for business requirements
5. Should be able to identify opportunities for automation and implement the same to bring in efficiencies
6. Ability to manage complex stakeholders in a dynamic, matrix organisation
7. Self-motivated, positive attitude and ability to inject optimism
8. Ability to challenge status quo and lead discussions in the right direction
9. Ability to collaborate with various teams locally and globally
10. Ability to influence without authority
11. Ability to articulate thoughts and ideas clearly
12. Excellent interpersonal skills, ability to negotiate the best things for the organization
13. Crisis, conflict, issues management skills
14. Eye for detail as well as understanding of the big picture
15. Ability to work with ambiguous information
Functional
1. Preferably HCM domain and process knowledge or prior experience of any data warehouse/ERP implementation.
2. Ability to gather requirements and convert business requirements to technical requirements
3. Providing effort estimations to complex BI projects
4. Engage with cross teams to analyze data sources required to integrate for a new analytical solution
5. Maintain and enhance operating rhythm
6. Experience in managing challenging stakeholders
7. Ability to validate change requests
Technical :
1. Should have worked extensively in OAC RPD development involving time series calculations, YTD measures and configuring security
2. Experience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business users
3. Worked to build complex reports in OAC in a performant way and has good understanding of role security aspects.
4. Data modelling expertise using STAR and SNOWFLAKE schema design.
5. Should have worked extensively in OAC RPD development involving time series calculations, YTD measures and configuring security
6. Strong experience in design, development and testing of Informatica based applications (PowerCenter
10.2)
10.2)
7. Transformations like Lookup, sorter, Expression, router , update strategy , filter.
8. Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor).
9. Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
10. Expert in using mapping Parameters, Mapping Variables, testing and fixing the issues in Mapping.
11. Understand complex transformations such as mapplet, worklet, normalizer and custom transformations.
12. Experience in Extract/Load/Transform (ETL)workflows (Informatica PowerCenter)
Knowledge on Informatica Cloud services is an advantage.
Should have Strong knowledge of Oracle database, PL/SQL development, UNIX scripting.
Knowledge on Informatica Cloud services is an advantage.
Should have Strong knowledge of Oracle database, PL/SQL development, UNIX scripting.
13. Experience on creating projects using Oracle Analytics Cloud depicting visualizations to help understand the data trends and analytics for business users
14. Worked to build complex reports in OAC in a performant way and has good understanding of role security aspects.
15. Should have Strong knowledge of Oracle database & PL/SQL development
16. Must know how to write advance SQL, use Oracles SQL aggregate and analytic function
17. Expert in debugging, optimizing, and Performance Tuning of OAC visualizations, Oracle BI Repository & Dashboards / Reports
18. Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation.
19. Understand and design data models to setup robust Datawarehouse environment
20. Hands on experience in tuning mappings, identifying, and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions
21. Monitor and tune the performance of the OAC environment
Essential Day-to-Day Responsibilities:
1. Delivery of enhancement requests and other operational activities of the project
2. Up to date communication to stakeholders using JIRA as medium.
3. Participate in Replenishment calls with stakeholders to clarify blockers and agree on deliveries
4. Train and mentor team members and management to understand technologies and assist with development of OAC/OAC
5. Tracking and following up the action items
6. Ensure all requests are addressed in a timely manner with optimal solution
7. Simplify use every opportunity to simplify to the maximum extent possible and go the extra mile in doing so
8. Collaborate with internal teams to address business needs
9. Assume personal responsibility for achieving defined outcomes
10. Effectively plan & organize work to deliver consistent results
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for BI Engineer roles with real interview advice
What BI Engineer at Schneider Electric are saying
BI Engineer salary at Schneider Electric
reported by
1
employee
with 2
years exp.
₹4.5
L/yr - ₹5.8
L/yr
42%
less
than the average BI Engineer Salary in India
View more details
What Schneider Electric employees are saying about work life
based on 3.7k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Schneider Electric Benefits
View more benefits
Compare Schneider Electric with
Siemens
Compare
ABB
Compare
Honeywell Automation
Compare
Emerson Electric Co.
Compare
Eaton
Compare
Legrand
Compare
Rockwell Automation
Compare
Johnson Controls
Compare
Bosch
Compare
Wipro PARI
Compare
Addverb Technologies
Compare
Titan Engineering & Automation
Compare
Falcon Autotech
Compare
Technosoft Engineering Projects Limited
Compare
Festo
Compare
TMEIC
Compare
Cotmac Electronics
Compare
Marine Electricals
Compare
Utthunga Technologies
Compare
Siemens PLM Software
Compare
Similar Jobs for you
Schneider Electric Bangalore / Bengaluru Office Location
Bengaluru Office
401-403, Prestige Meridian-1, Near-City Bank, Mahatma Gandhi Road
Bengaluru
Karnataka 560001
Karnataka 560001
Share an Interview