Job Description

Check It Out!

Ready to be a Cooper too? This might just be right up your alley!

We're here to keep the dream of home ownership alive. Oh, and while we're at it, we're determined to change the lending industry itself. It's simple, but it won't be easy. And we'll need a great team behind us. (That's where you come in.) We want to show the world that transparency, candor and collaboration aren't just good values. They're good business. Working here isn't for people who want to punch a clock. It's for people who want to punch a hole in the status quo. Come join us. And make a difference instead of just a living.

Data support engineer (BI) for BI Support team. This team is responsible for supporting 400+ SSIS jobs scheduled in Mr.Cooper without missing committed SLA.
Shift : 16X7, night shift - on 1st of every month- in round robin method).
Nature of Work : 65% of L1&L2 work. (Support)
35% of L3 and L4 work (Bug fixing & Enhancements)

Skills required

• Must have good hands on experience on SQL/ T-SQL, stored procedures , performance tuning & ETL concepts.
• Must have good communication skills.
• Expert in troubleshooting and debugging in T-SQL and SQL Server Integration Services (SSIS) ETL tool.
• Must have Hands on experience in scheduling and monitoring SSIS, SSRS SQL jobs in different environments (Dev,QA,Prod)
• Should have development experience in SSIS ETL Tools & SQL Server Reporting Services (SSRS).
• Should be good in basic concepts of Data warehousing.
• Hands on experience in power BI reporting tool is an added advantage.

Roles and Responsibilities
Understanding the business process and SLAs
Support and automation using Microsoft SSIS
Performing data analysis for mismatches and fixing.
Monitoring , identifying, alerting, communicating, troubleshooting and fixing issues with jobs scheduled in SSIS.
Supporting Power BI reports
Documentation of end to end process
Performing SSIS job development to schedule Stored procedures, add email notifications, debug issues within jobs, enhance jobs to set requirements.
Resolving medium complex business requirements - perform follow up with business on open queries

Mr. Cooper is committed to nurturing a diverse and inclusive environment where every employee is empowered to be their authentic self. We know that a large part of our success as a business is directly tied to our ongoing efforts to attract and retain diverse talent and maintain an inclusive environment where each employee can thrive. Embracing and leveraging diversity through an inclusive work environment fosters new ideas, new insights, and constant innovation. We strive to weave the principles of diversity and inclusion throughout the fabric of how we work, how we interact, and how we engage with our customers and the community.

Job Requisition ID: 018992

Job Category: Information Technology

Primary Location City: Chennai

Primary Location Region: Tamil Nadu

Primary Location Postal Code: 600089

Primary Location Country: India

Additional Posting Location(s): NSM_Bangalore