Loading...
 

Senior ETL Developer (SAP BODS & SQL)

Req ID:  61923
Location: 

Bangalore, KA, IN, 530068

Date:  Nov 18, 2021

For over 140 years our products have helped ensure the safe, reliable operations of key industries. With a passion for precision and partnership, Celeros Flow Technology continues this heritage of high performance and dependability, providing mission critical, sustainable flow control solutions for our customers around the globe.

 

Celeros Flow Technology is looking for individuals with a voice and a vision. We embrace change, diversity and promote new ways of looking at old ideas. We seek talented professionals to join our world-class team of innovators in a global, collaborative & multi-cultural environment, where you will be challenged, supported, and inspired to be extraordinary.

 

Job Summary

The Senior ETL Developer will work on developing and maintaining the ETL process as part of the IT Digital, Data, and Analytics Team at Celeros Flow Technology. This individual will work with the Data Analytics Analyst and Businesses to document field mapping, business rules, and business logic required to transform master and transactional data from various ERP systems into the analytical databases. This individual will design and deliver the end-to-end ETL process and Data Analytics technology infrastructure that will feed data to dashboards, scorecards, standard reports, ad hoc self-service reports, discovery & analysis, predictive analytics, and comprehensive visualizations. The Senior ETL Developer has proven experience providing technology solutions to support key business processes and providing troubleshooting support in a Global Manufacturing Company. This individual will report to the Director of the IT Digital, Data, and Analytics Team. This role will be based at our Bangalore office.

 

Principle Duties and Responsibilities

  • Translate BI Data Analytics needs into requirements by holding requirements gathering sessions and collaborating with stakeholders throughout the company in Finance, Product Management, Sales, Engineering, Manufacturing Operations, and Supply Chain groups.
  • Document mapping and transformation rules from reports to source system fields in SAP and non-SAP ERP systems and other applications.
  • Design, estimate and create a project plan for development, testing, and implementation of ETL process and related tasks.
  • Develop robust and scalable ETL process in SAP Business Objects Data Services (BODS) for source SAP and non-SAP systems and target OLAP systems (SQL, Cloud, etc.).
  • Install and configure the BODS application.
  • Monitor BODS jobs, perform fast troubleshooting and root cause analysis, and provide fast turnaround with a resolution of job failure and any other issues in the BODS production system.
  • Profile source data using SAP Information Steward and discuss results with IT Analyst Business SMEs to define Data Quality checks for Business and IT action.
  • Gather, analyze, and identify opportunities for enhancements; work closely with business and technology partners to seek and provide effective resolution to business issues.
  • Define the engagement success criteria with business users, track and monitor progress during engagements and ensures deliverables are met.
  • Identify and implement solutions to enhance the existing BI infrastructure process and technology, and potentially move to newer BI infrastructure technologies to support the long term roadmap.
  • Create documentation to assist business users and IT members in designing & effectively using the solutions developed.
  • Deliver against the data strategy to support the development and deployment of executive dashboards, operational dashboards, standard reports, ad hoc reports, discovery & analysis, and predictive analytics.
  • Communicate and report project progress related to schedule and work performance to the necessary stakeholders.
  • Ability to quickly learn new ETL tools and technology to support modern Data Analytics platform, such as IIoT big data, cloud data, real-time data acquisition, and advanced analytics platform.
  • Ability to quickly learn reports development in Power BI and other analytics applications.
  • Ability to quickly pick up skills in order to support Azure, Google Cloud Platform and/or AWS based BI platform.
  • Create technical design and data flow diagrams of BI platform and ETL processes.
  • Ability to work independently with minimal supervision.
  • Can manage own tasks and deliverables. Can manage a small team of 3rd party service providers. 

 

Knowledge, Skills and Abilities

  • 7-10 years of demonstrated technical mastery of Design, Development, and Deployment of SAP Business Objects Data Services and MSFT ETL applications.
  • 7-10 years of experience developing ETL process with SAP and non-SAP source systems.
  • 5+ years of experience working with SAP, SQL, and other data warehouse & OLAP applications.
  • Strong development and implementation expertise in SAP Information Steward and Data Quality, experienced in master data management and governance creating, publishing, and maintaining data quality rules & scorecards.
  • Designing complex SAP Data Services job flows to extract from and load to SAP systems and SQL Servers, including delta loads to improve ETL performance.
  • Sound knowledge of BODS scheduling and Management Console.
  • Strong knowledge of SQL, star schema, data modelling and data warehouse concepts.
  • Experience with Data Integration transforms such as Query, Validation, Case transforms as well as Data Quality transforms such as Match, Associate & Data Cleanse and other transforms.
  • Tuning jobs for high volume and complex transformation scenarios.
  • Configuring BODS components including job server, repositories and service designers.
  • Strong expertise with SQL Scripting, creating SSIS packages and DB migrations.
  • Reconciling loaded data with Legacy System.
  • Experience in designing and implementing ETL solutions for various non-SAP ERP technologies.
  • Sound understanding and knowledge of SAP FICO, SD, MM/Pur, PP data and tables.
  • Strong knowledge of SQL server and database.
  • Experience with creating and maintaining SQL servers and databases.
  • Experience in creating the technical design, architecture, and data flow diagrams for BI and analytics applications.
  • Develop and implement experience with real-time IIoT data pipeline in a cloud platform preferred.

 

Education and Experience

  • B. Tech/B. E/MCA/ / Masters in Business Systems Analysis in a relevant stream through the regular course from recognized university and institute in India
  • 7-10 years of relevant experience in SAP BODS and ETL applications and working in a global organization
  • One or more business intelligence certifications (SAP, Microsoft SQL/Azure, GCP, etc.)

 

Celeros Flow Technology is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.