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:
- 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:
- A 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.
Top Skills
What We Do
We are Onity. We get it done. Onity Group Inc. (NYST: ONIT) is a leading financial services company. Through our primary operating subsidiary, PHH Mortgage Corporation, and our Liberty Reverse Mortgage brand, we provide mortgage servicing and origination solutions to homeowners, clients, investors and others. We are headquartered in West Palm Beach, Florida, with offices and operations in the United States, the U.S. Virgin Islands, India and the Philippines, and have been serving our customers since 1988. For additional information, please visit our website (www.onitygroup.com). PHH Mortgage is one of the largest servicers in the country, focused on delivering a variety of servicing and lending programs. Liberty is one of the nation’s largest reverse mortgage lenders dedicated to education and providing loans that help customers meet their personal and financial needs. Our talented, global team members are dedicated to creating positive outcomes for clients, homeowners, investors and communities. Each team member, regardless of their role, is proud of Onity's focus on helping families achieve and sustain homeownership and create success for our customers. Interested in joining our team? Integrity, inclusiveness and respect are integral parts of our culture and work environment, and we are committed to being an organization that creates, promotes and sustains these values. Learn more and see available positions at jobs.onitygroup.com. NMLS#: 2726 PHH Mortgage Corporation NMLS #1849337 Ocwen USVI Services, LLC Onity Group Inc. supports Equal Housing Opportunity
