Lead ETL Developer, Data Management Onity Group Inc.

About Onity Group Inc.

Job Description

You are an experienced ETL (SSIS) Developer who will be an integral part of our Data Management team. Your primary responsibility will involve collaborating with various cross-functional teams to comprehend their data requirements and effectively transform raw data from SQL, Oracle, and AWS S3 into our DataWarehouse. Your key job functions and responsibilities will include: - Developing and optimizing ETL workflows to produce valuable data and reports. - Integrating data from SQL database, Oracle database, Flat files, AWS S3. - Troubleshooting and debugging existing SSIS packages to enhance performance and reliability. - Fine-tuning SQL queries and views for improved efficiency. - Working closely with both onshore and offshore data team members. - Engaging with business and sales teams to grasp their data and automation necessities. - Creating and maintaining detailed documentation for all systems and jobs. To excel in this role, you should meet the following qualifications: - Hold a Bachelor's Degree. - Possess a minimum of 5 years of ETL (SSIS) developer experience, with a proven track record of integrating various databases and flat files. - Demonstrate expert proficiency in SQL. - Exhibit strong English communication skills to effectively interact with business stakeholders. - Ideally, have experience in Agile Project Management methodology. - Familiarity with connecting to AWS services is preferred. - Knowledge in AI/ML and proficiency in Python or R for data analysis would be advantageous. Your work schedule will entail approximately 3 hours of overlap between onshore and offshore work hours, from 1:30 PM IST to 10:30 PM IST.,