Responsibilities:
Design, develop, and support ETL processes using SAP BODS.
Develop complex queries, stored procedures, functions, and performance tuning in Oracle PL/SQL.
Extract, transform, and load large volumes of data from various sources into target systems.
Work closely with business analysts, data architects, and stakeholders to gather requirements.
Perform data validation, quality checks, and ensure accuracy of data migration.
Troubleshoot ETL jobs, optimize workflows, and provide production support.
Create and maintain documentation for ETL processes and data flows.
Requirements:
Hands-on experience with SAP BODS.
Strong expertise in Oracle Database, SQL, and PL/SQL.
Solid understanding of ETL concepts, data warehousing, and data modeling.
Experience in performance tuning of queries and ETL processes.
Knowledge of scheduling tools (Control-M, Autosys, or similar) is a plus.
Strong problem-solving and debugging skills.
Excellent communication and teamwork skills.