ETL Informatica Developer

Title: ETL Informatica Reporting

Location: Pleasant Prairie, Wisconsin / Onsite (Needed Local or nearby location)

Duration: Long Term

Job Description:

• Strong experience in architecting SSRS, SSAS and Informatica based solutions.
• Having strong hands-on experience in SSRS,SSAS and Informatica 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 Informatica.
• 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 Informatica based reports by investigating on all major/minor incidents, service requests and enhancements (in Service Now).

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

• Perform support functions and work on report fixes on hard deadlines in case of HIGH PRIORITY issues.
• 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.

Skills Required :

• SQL Server Reporting Services
• Informatica
• SQL/PLSQL
• SQL Server Analysis Services
• Basic Python