Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Experience in using ETL (Extraction, Transformation, Loading) utilizing Informatica Power Center, SQL Server Integration Services (SSIS) and Data stage. Excellent knowledge and experience in data warehouse development life cycle, Relational modeling and Dimensional modeling, Normalization and De normalization, implementation of STAR, SNOWFLAKE schemas. Experience in creating mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 6.x/7.x/8.x/9.x. Designing and Developing the PL/SQL Stored procedures to effectively transform the data and prepare it be sent over to Salesforce Configure and Optimize IDQ/Web Service s Data Integration, Model Respository, Monitoring, Content Management and Analyst Services Develops ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc Strong understanding relational database concept and well familiar with SQL and PLSQL (Oracle) Experience in Agile delivery Strong SQL skills, PLSQL and MS SQL Experience in Informatica Power Center and IICS Strong SQL skills, PLSQL and MS SQL Experience in Informatica ETL, Data Warehouse Development, Data Migrations and SQL scripting. Extensive experience in Performance Tuning, advanced Oracle PL/SQL Programming, and UNIX Shell scripting.

Minimum years of experience*: 5+