Senior Security Informatica Dev
Sr. Security Informatica Dev Responsibilities Strong understanding of Identity and Access Management (IAM) concepts Expert designer, coder and tester for data warehouse programming by using Informatica Power Center. (9.5.1 and Above) Expert in writing complex SQL and PL/SQL blocks for Sybase, Oracle, MSSQL, and UDB/DB2. Expert in design Autosys jobs for scheduling the UNIX Shell Scripts and Informatica workflows. Strong experience in BladeLogic Server Automation and BladeLogic Architect. Required to quickly write complex Shell Scripts to gather any identity details from all Servers in the environment and log events that will prove completeness and accuracy of the solution daily. Experience in BMC BladeLogic Server Automation activities - Adding Servers, Creation/Maintenance of NSH Scripts, Creation of BL Packages, Jobs, Snapshots, Audits etc. Has a good knowledge on how Access Control is applied, implemented and maintained on Active Directory, UNIX & Windows Servers and on databases like Sybase, Oracle, UDB & MSSQL. Experience in creating Shortcuts to reuse objects across folders without creating multiple objects in the Informatica repository. Experience in writing Pre-and Post-session commands on Source and Target database using Shell Scripting. Datamodelling and dimensional data warehouse schema design experience. Qualifications 5-7 years of experience working with Data warehousing and Business Intelligence applications Bachelor's degree in Engineering, Computer Science, Information Technology, related field or equivalent work experience. Candidate should be extremely familiar with Informatica Power Center. Informatica ETL certification is a plus.