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 SQLExperience 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 and

Minimum years of experience*: 6+