ASPAPAC Business Solutions Private Limited..
Role :- Senior Informatica Technical Business Consultant –
Mandatory Skill Set :- 1. Informatica Test Data management with power center 2. Good business consulting skills 3. Informatica Power center 9.x, 10.x , Oracle ,SQL Server 2017,Teradata, SQL PLSQL, Unix, Datawarehouse ,Informatica Products like MDM,IDQ.
Total Years of Experience:- 9 Years Job Type :- Corp to Corp Location – Austin Tx
Job Description : -
Develop test data management strategy and TDM Data masking and generation techniques and concepts .Handling day to day informatica components migration tasks
Scheduling and Monitoring informatica repository backups.Review of informatica ETL design documents and working closely with development to ensure correct standards are followed
Scheduling jobs through AutoSys for monthly and daily job cycles.Remedy Ticket handling and problem ticket analysis
Creating new repositories from scratch, backup and restore
On Call Support as required during the week ends and nights.Scheduling real time system jobs
Root Cause analysis for ETL job failures
Experience with multi domain implementations and Experience in messaging and web service integrations.
Strong experience in ETL process using Informatica Power Center.Design, develop performance tuning using Informatica.Develop stored procedures, triggers and functions in SQL or RDBMS databases.
Extract, Transform and Load (ETL) solutions and data conversion strategies for integrating disparate systems.Create data mapping and modelling for data migrations.
Create end-to-end solution for ETL transformation jobs that involve writing Informatica workflows and mappings, SQL procedures and functions.
Integrate Informatica Power Center code with other components.Develop, recommend, and discuss technical designs that meet business requirements.
Track, monitor, and close production support issues escalated from the help desk; document activities and solutions.
Analyze, document, and perform system configuration and setup as well as integration and system testing for both externally developed and in-house developed applications.
Troubleshoot issues identified during the delivery of new or existing systems and resolve them in a timely manner.
Provide assistance and advice to business users in the effective use of applications and information technology.
