Bi Support Engineer I

Year    Chennai, Tamil Nadu, India

Job Description


At Mr. Cooper Group, You Make the Dream Possible.Our purpose is simple: Keeping the dream of homeownership alive. As a Mr. Cooper Group team member, you play a big role in making that dream possible. Around here, we know our roles and work together, volunteer to make a difference, and challenge the status quo when needed. Everything we do is in the care and service of our teammates and our customers.Join us and make the dream of home ownership possible!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 : 60% of L1&L2 work. (Support)
40% 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 \xe2\x80\x93 perform follow up with business on open queriesMr. Cooper Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or status as a protected veteran. EOE/M/F/D/VJob Requisition ID: 022200Job Category: Information TechnologyPrimary Location City: ChennaiPrimary Location Region: Tamil NaduPrimary Location Postal Code: 600089Primary Location Country: IndiaAdditional Posting Location(s):

Mr. Cooper

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD3372235
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Chennai, Tamil Nadu, India
  • Education
    Not mentioned
  • Experience
    Year