IT Senior Data Analytics Developer (BODS & ETL)

Job Description

• Job Summary

This position will be based at our Bangalore office and incumbent will be on a Hybrid work mode.

This individual will report to the Manager of the Data and Analytics Team.

• 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.
• 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.
• 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.)