Production Support Job in Acreaty

Experience in working BAU/Production Support role.

Experience in design & development and deploying reports in MS SQL Server environment using SSRS and SSIS in Business Intelligence Development Studio (BIDS).

Expected to have hands-on experience in Informatica PowerCenter tools (workflow manager, workflow monitor, designer)

Should have knowledge on Programming languages (SQL, XTML)

Informatica developers analyze a business s database storage and warehousing capabilities and assess the company s data requirements.

Review data storage and access procedures and use Informatica tools to update, test, and provide solutions for data issues.

Develop data warehousing systems using Informatica software tools.

Maintain up-to-date documentation of implementation, troubleshooting, and ETL processes related to Informatica systems.

Experience in Integrating system with a company s existing systems, troubleshoot any issues, and smoothly implement the Informatica cloud data management product.

Experience in different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.

Experience in SSIS Migration Project, SSIS packages, Performance tuning of TSQL queries and Stored Procedures ,T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.

Advanced knowledge of software development lifecycle.

Demonstrated ability to coordinate cross-functional work teams toward task completion.

Demonstrated effective leadership and analytical skills.

Advanced written and verbal communication skills are a must.

Should be flexible in work timings.

Desired Skills & Experience

Requirements