Key Responsibilities
ETL Development & Data Integration
- Design, develop, and maintain ETL pipelines using SAP BODS and Informatica IICS
- Implement robust data extraction, transformation, and loading processes
- Ensure seamless data integration across multiple enterprise systems
Data Warehousing & Database Management
- Work with Oracle 19c databases for data storage and processing
- Develop and optimize SQL queries, PL/SQL, T-SQL, and stored procedures
- Support enterprise data warehousing solutions and data modeling activities
Scheduling & Workflow Orchestration
- Manage job scheduling and workflow orchestration using Redwood Scheduler
- Ensure timely execution of ETL jobs and data pipelines
- Monitor and troubleshoot scheduling failures and performance issues
Data Modeling & Platform Fundamentals
- Apply data modeling principles to design scalable data structures
- Work with modern data platform fundamentals for efficient data processing
- Ensure alignment with enterprise data architecture standards
Python & Automation Support
- Use Python for data processing, automation, and pipeline enhancements
- Support scripting for ETL optimization and data transformation tasks
- Improve efficiency through automation of repetitive workflows
Performance Optimization & Quality Assurance
- Optimize ETL processes for performance and scalability
- Ensure data accuracy, consistency, and integrity across systems
- Conduct troubleshooting and root cause analysis of data issues
Collaboration & Requirement Gathering
- Work closely with business analysts, data architects, and stakeholders
- Translate business requirements into technical ETL solutions
- Participate in Agile development and delivery processes
