Senior ETL Developer

About the job

Position Overview:

We are seeking an experienced ETL Developer with extensive working experience in SAP Data Services to join our dynamic team for MRP project. The ideal candidate will possess a strong foundation in ETL/ELT processes, PL/SOL, and Python. Responsible for managing SAP Data Service migrations, maintaining, and updating existing ETL and integration jobs, and collaborating with functional teams to bridge solution gaps. A deep understanding of various databases and hands-on experience with SAP Data Services is essential for this role.

Key Responsibilities:

Develop SAP Data Services ETL jobs.

Maintain and optimize existing ETL and integration jobs to ensure seamless data transfer.

Collaborate closely with functional counterparts to discuss, design, and develop solutions for identified gaps.

Draft and refine build instructions; work together with the Configuration Management team for deployment in an On-Demand environment.

Aid in the creation, review, and approval cycles of technical specifications for RICE (Reports, Interfaces, Conversions, and Extensions) teams.

Perform rigorous code reviews to ensure best practices and standards are adhered to.

Troubleshoot and resolve production issues in a timely manner.

Engage in unit testing; support functional SIT (System Integration Testing) of custom objects and assist in defect resolution.

Oversee UAT (User Acceptance Testing) and manage production cutover tasks to ensure smooth transition and minimal business disruption. 10. Stay updated with the latest trends in database management, ETL/ELT processes.

Qualifications:

Extensive experience in ETL/ELT processes and tools.

Strong proficiency in PLISQL and Python.

Demonstrated expertise in SAP Data Services, both in design and development of jobs.

Knowledge of various databases and their intricacies.

Proven track record of troubleshooting and resolving complex technical issues.

Strong communication skills, both written and verbal.

Ability to work in a collaborative team environment and manage multiple tasks simultaneously.

Desirable:

Previous experience in an On-Demand environment deployment.

Experience in SAP Data services , Informatica and Azure Data Factory.