POSITION SUMMARY: We are looking for an experienced ETL (SSIS) Developer to join our Data Management team. This role will work with cross-functional teams to understand their data needs and transform raw data from SQL, Oracle, AWS S3 into our DataWarehouse.
JOB FUNCTION AND RESPONSIBILITIES:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Examples below:
- Develop, develop, and optimize ETL workflows to generate valuable data and reports.
- Integrate data from SQL database, Oracle database, Flat files, AWS S3.
- Troubleshoot and debug existing SSIS packages to improve performance and reliability.
- Performance tune SQL queries and views.
- Work closely with onshore and offshore data team resources.
- Collaborate with business and sales teams to understand their data and automation needs.
- Create and maintain comprehensive documentation for all systems and jobs.
QUALIFICATION:
To perform this job successfully, an individual must have the following education and/or experience:
- Bachelor’s Degree is needed.
- 5+ years of ETL (SSIS) developer experience integrating with various databases and flat files is a must.
- Expert knowledge of SQL is a must.
- Should be fluent in speaking English and be able to communicate well with business stakeholders.
- Experience in Agile Project Management methodology is a plus.
- Experience connecting to AWS services.
- AI/ML experience and knowledge in Python or R for data analysis is nice to have.
WORK SCHEDULE OR TRAVEL REQUIREMENTS:
- General work schedule (for shift roles). Around 3 hours of overlap between onshore and offshore work hours is expected. 1:30 PM IST to 10:30 PM IST.
Read Full Description