Design, develop, and optimize ETL workflows using IICS, integrating data across Oracle, SQL Server, and Snowflake to support business needs.
- Implement ETL solutions for complex data integration projects, ensuring data accuracy, security, and t imeliness to meet analytics and reporting requirements.
- Develop best practices for data transformations, error handling, and scheduling, ensuring efficiency and reliability. Database Management & Optimization Driving Innovation, Empowering Insights
- Manage and optimize data storage and retrieval within Oracle, SQL Server, and Snowflake environments.
- Create complex SQL queries, stored procedures, and views to support reporting, data transformation, and data migration.
- Perform query tuning, indexing, and data structure enhancements to ensure efficient and scalable database performance. Collaborative Solution Design
- Engage with business units to understand data requirements, collaboratively design data solutions, and provide technical expertise in IICS and data integration.
- Develop and maintain detailed documentation, including ETL workflows, data mappings, and process diagrams, ensuring knowledge sharing across teams. Continuous Improvement
- Identify and implement opportunities to enhance data workflows, system performance, and storage solutions, especially within Snowflake.
- Troubleshoot and resolve data integration and ETL issues, ensuring data availability and accuracy for decision support systems.