Enterprise Data Warehouse data modeling
Design and develop dimension-fact data models for data marts
Design and develop ETL jobs using Informatica PowerCenter
SQL query analysis and tuning
Should be willing to explore and learn new technologies and concepts to provide the right kind of solution.
Work on ETL optimizations
Work collaboratively across various teams
Deployment of application to QA/UAT/Prod environments
Design and implement highly scalable, fault-tolerant, multi-tenant services
Propose, prototype and test positive improvements on scaling transaction processing servers/services
Experience in developing highly scalable and lean ETL jobs on Informatica Power Center 9.0.1 and above
Experience in building large scale Data Warehouse applications is a must.
Experience on shell scripting is a must
Experience in developing parsers/serializers/mappers on Informatica Data Transformation is a big plus
Experience in building large scale Data Warehouse / OLAP solutions/applications is a must.
Experience of SQL, multi-dimensional data modeling for high volume transaction processing, accessing data from data warehouse/mart is a must
Experience in working with column oriented databases like InfoBright, Vertica is a huge advantage.
Experience in working with MySQL databases and knowledge of various database engines like MyISAM, INNODB etc. is a huge advantage.
Should have demonstrated capability and willingness to work in a very dynamic and challenging environment.
Passionate about working in small focused teams.
Should be flexible to take up design challenges, process improvements and should be able to work collaboratively with various team.