Job Description

Are you naturally curious? So are we at MKS. Our collective curiosity drives us to be an innovation leader in many industries. Our products drive technology advancements across a wide range of applications such as 5G, augmented/virtual reality, autonomous vehicles, clean drinking water and space exploration. We are a team of collaborators who value fresh thinking and believe in mutual respect, constructive candor, diversity and inclusion. As a valued and trusted partner to our customers, we are continually pushing the boundaries of possibility. We believe in creating technology that transforms our world and are looking for like-minded individuals to join our team. If this is appealing to you, we want to meet you.We are looking for Sr. SAP BI-HANA Developer, to be based in Manesar, Gurgaon.A key role in MKS Enterprise Reporting and Analytics organization responsible for developing SAP HANA-based enterprise data warehouse solutions. The EDW will include data from ERPs (SAP ECC, Oracle R-12), Salesforce and other business applications within the enterprise. The Sr. BI/HANA Developer will be responsible for all aspects of the EDW: ETL, metadata layer, presentation layer, security/administration, user support and production support as well as:

• Develop a strong understanding of business flows, processes and architecture and leverage that in designing and developing BI content.
• Translate business/functional requirements into technical specifications encompassing the ETL, Metadata layer and Reporting layer.
• Significant experience in the areas of HANA Modeling, HANA data provisioning, HANA Views and SQL Script, Stored procedures.
• Hands-on development within all layers of the EDW environment.
• Data acquisition, modeling, transformation, and load to HANA Platform.
• Design and development of data models in HANA that assimilate data from multiple sources system (SAP and non-SAP) to effectively and efficiently solve business requirements.
• Creation of attribute, analytic, calculation views, and scripted calculation views over column tables used for analytical purposes.
• Design, build and execute data conversions from legacy systems.
• Write and execute test plans (unit, regression and integration)
• Technical and user documentation and training.
• Provide production support and user support, including researching data questions.
• Provide technical guidance and oversee work completed by junior team members

What will you bring to the team, along with your curiosity is:

• 5+ years of full life-cycle experience in Data Warehouse/Reporting projects, preferably in an SAP environment.
• Hands-on experience in all facets of EDW Architecture, Data flow strategy, Data modeling, Metadata & Master data management.
• Preferred experience with BI reporting tools, preferably in the Business Objects suite (Lumira, Design Studio, Explorer, Analysis, Webi and Crystal Reports) and integration with MS Office.
• Experience with SAP HANA architecture and HANA Modeling. Understanding of HANA data provisioning, HANA views and SQL Script.
• Knowledge on extracting data from various sources including SAP and non-SAP system to HANA is required.
• Knowledge on Advanced modeling concepts including Analytic Views, Attribute Views, Hierarchies, Creating Restricted & Calculated Columns, Filter Operations, Variables, Creating Calculation Views, SAP HANA SQL, SQL Script and Procedures.
• Experience integrating HANA systems with external systems is preferred.
• Experience with SAP Data Services, SLT and DXC.
• Exposure to SAP Data Sphere or similar cloud data warehouse
• Understanding of BI and HANA security (users, roles, privileges, etc).
• Excellent written and verbal communication skills
• Strong technical documentation skills

#LI-AS2Globally, our policy is to recruit individuals from wide and diverse backgrounds. However, certain positions require access to controlled goods and technologies subject to the International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). Applicants for these positions may need to be U.S. persons. U.S. persons are generally defined as U.S. citizens, noncitizen nationals, lawful permanent residents (or, green card holders), individuals granted asylum, and individuals admitted as refugees.MKS Instruments, Inc. and its affiliates and subsidiaries (MKS) is an affirmative action and equal opportunity employer: diverse candidates are encouraged to apply. We win as a team and are committed to recruiting and hiring qualified applicants regardless of race, color, national origin, sex (including pregnancy and pregnancy-related conditions), religion, age, ancestry, physical or mental disability or handicap, marital status, membership in the uniformed services, veteran status, sexual orientation, gender identity or expression, genetic information, or any other category protected by applicable law. Hiring decisions are based on merit, qualifications and business needs. We conduct background checks and drug screens, in accordance with applicable law and company policies. MKS is generally only hiring candidates who reside in states where we are registered to do business.MKS is committed to working with and providing reasonable accommodations to qualified individuals with disabilities. If you need a reasonable accommodation during the application or interview process due to a disability, please contact us at: .If applying for a specific job, please include the requisition number (ex: RXXXX), the title and location of the role

MKS Instruments