Must Have Skills:
Experience in designing Informatica 10.1 PowerCenter mappings Experience in implementing Informatica 10.1 PowerCenter mappings Experience in DB2 Database Experience in Oracle Database Experience in UNIX shell scripting Experience in ETL scheduling process using Autosys R11Detailed Job Description:
Extensive experience in designing, building, validating, maintaining and documenting ETL mappings using Informatica Powercenter 10.1.1 client tools. Should have good understanding in UNIX shell scripting. Should be well versed with ETL scheduling process using Autosys R11. Will be accountable for operational support of production jobs including the maintenance and monitoring of job schedules. Should be expert in writing and performance tuning of SQL queries and performance optimization of ETL code. Should have worked on databases (Oracle and DB2), and different file structures (delimited, fixed width, XML files). Should have experience in setting up file transfer protocols, like SFTP and their working.
Minimum years of experience*: 5+