ETL/Informatica With BI Reporting

Power ETL/Informatica with BI Reporting and Production Support

Pleasant Prairie, WI (Onsite)

Long term contract 

In person is required for final round

Job Description:

• Strong experience in architecting SSRS, SSAS and Power BI based solutions.
• Having strong hands-on experience in SSRS,SSAS and Power BI report development & Support.
• Must be very strong in SQL/PLSQL. Should be Strong enough to troubleshoot complex report queries and stored procedures.
• Should be able to implement architect on data refresh, security, performance optimization of SSRS and Power BI reports.
• Should have very good experience in relational database system like SQL Server, Oracle etc.
• Perform support functions for all applications related to SSRS, SSAS and Power BI based reports by investigating on all major/minor incidents, service requests and enhancements (in Service Now).
• Perform support functions and work on report fixes on hard deadlines in case of HIGH PRIORITY issues.
• Should have experience in PBRS to create new schedules and support existing.
• Strong Technical skills in Power BI Desktop and Power BI service, especially expertise in DAX functions and Power BI modelling.
• Perform application, batch jobs monitoring, and ensure smooth functioning of the client business processes end to end and collaborate with other teams in case of any issues with batch run.
• Should be very strong in improving the performance or optimizing the runtime of SSRS and Power BI reports on hard deadlines.
• Strong experience in Data Modeling.
• Having good knowledge or experience in Cognos and Python is an added advantage.
• Should be ready to support over weekend as a POC.

Moreover, coordinate with business and offshore teams to convey the requirements, clarify the designs, and verify the deliverables.

Skills Required:

• SQL Server Reporting Services
• Power BI (On-prem and Cloud)
• Informatica
• PBRS
• SQL/PLSQL
• SQL Server Analysis Services
• Cognos
• Basic Python