Lead ETL Developer, Data Management

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.