Job Seekers, Please send resumes to resumes@hireitpeople.com Must Have Skills: Informatica SQL Databases Detailed Job Description: Around 8 years of experience in IT Software Development Life cycle involved in Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and Implementation of Data Warehousing applications in healthcare and retail domains. Strong knowledge in ETL Informatica. Proficient in T - SQL queries using Store Procedure, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL etc. Strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PLSQL code, modifying database parameters. Good understanding of ETL, D Writing scripts in Unix to process source files, target files, to automate the email notifications, Archive the files, copy, ftp and cleanse the files to process in ETL. Extensive experience in creating documents for Low level and High-level design docs, Unit test plans, test cases and test scripts. Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts Good communication and interaction with client. Minimum years of experience required: 8+