IT Senior Data Analytics Developer (BODS & ETL)

1. Job Summary

The Senior ETL Developer will be a member of a global team with a key emphasis on providing development and administration expertise for SAP Data Services and the ETL process. This role will provide technical leadership to Data Analytics Analysts and Developers to establish best practices, ensuring efficient, and scalable ETL workflows that support business intelligence and data reporting needs. This position will be based at our Bangalore office and incumbent will be on a Hybrid work mode.

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, and ad hoc reports. The individual has proven experience providing complex technology solutions, in both SAP Business Object Data Services (BODS) and Power BI (PBI), to support key business processes and providing troubleshooting support within a global manufacturing environment. This individual will report to the Manager of the Data and Analytics Team.

1. Principle Duties and Responsibilities

• 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, etc.).
• Design, estimate and create project plan for development, testing, and implementation of ETL process and related tasks.
• Manage and maintain the BODS platform, including installation, configuration, upgrades, patching, and monitoring.
• 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.
• Identify opportunities for enhancements to ETL process; work closely with business and technology partners to seek and provide effective resolution to business issues.
• Create documentation to assist business users and IT members in designing & effectively using the solutions developed.
• Develop and maintain comprehensive documentation for ETL processes, workflows, and BODS administration procedures.
• Lead ETL development, providing training, technical guidance, and ensuring best practices in ETL development.
• Ability to quickly learn reports development in Power BI and other analytics applications.

1. Knowledge, Skills and Abilities

• Ability to handle multiple demands with a sense of urgency, drive and energy
• Ability to learn quickly in a challenging environment and work as part of a team or independently to achieve objectives
• Strong problem solving skills and technical aptitude
• Strong verbal and written communication skills
• Experience working in an Agile project environment
• 7+ years of demonstrated technical mastery of Design, Development, Deployment, Administration of SAP Business Objects Data Services and MSFT ETL applications.
• 5+ years of Data Warehouse experience working with SAP (ECC6), SQL, and other data warehouse & OLAP applications.
• Designing complex SAP Data Services job flows to extract from and load to SAP systems and SQL Servers.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing
• Strong knowledge of BODS scheduling and Management Console.
• Expert 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.
• Configuring BODS components including job server, repositories and service designers.
• Deep understanding of enterprise data warehousing best practices and standards.
• Strong expertise with SQL Scripting, creating SSIS packages and DB migrations.
• Strong understanding and knowledge of SAP FICO, SD, MM/Pur, PP data and tables.
• 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.
• Experience with Azure services like Azure Data Factory, Azure SQL Database, or Azure Synapse Analytics.

1. Mandatory Education and Experience

• B. Tech/B. E/MCA/ master’s in business systems Analysis in a relevant stream through the regular course from recognized university and institute in India
• 7+ years of relevant experience in SAP BODS and ETL applications and working in a global organization
• Prefer one or more business intelligence certifications (SAP, Microsoft SQL/Azure, GCP, etc.)