- Develop and deploy ETL job workflow with reliable error/exception handling and rollback.
- Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with Database backups and performance tuning.
- Design, Develop, Test, Adapt ETL code & jobs to accommodate changes in source data and new business requirements.
- Develop automated data audit and validation processes
- Manage automation of file processing as well as all ETL processes within a job workflow.
- Designs and develops ETL solutions using data warehouse design best practices for Next Generation Analytics platform
- 8+ years of Software/Data Engineering experience in ETL design, development, optimization & testing using SAP Business Object Data Services (BODS)
- 5+ PL/SQL , Complex SQL Tuning, Stored Procedures, Data Warehousing concepts and best practices etc.
- Intelligent Cloud Services (IICS), Informatica PowerCenter 10.2/9.6.1/9.5.1, Informatica IDQ Analyst and Developer.Strong problem-solving capabilities. Results oriented. Relies on fact-based logic for decision-making.
- Preferably have exposure to cloud technologies (AWS, Google Cloud, Azure) related to data ingestion tools, CI/CD processes, Cloud architecture understanding, Big Data implementation.
Excellent communication skills and ability to discuss complex technical concepts with Developers as well as end users
- Should be analytical and able to improvise configuration and code to adopt to new situations
- Strong problem-solving skills.
- Demonstrated ability to learn new things with initiative, curiosity and courage
- Ability to work within diverse global and virtual teams including flexible schedules as needed
- Good communication skills, written and verbal in English
- Well organized and can take direction and work independently
- Strong team collaboration skills