§ Experience in Life Science Domain, should be able to handle Business queries and relate it to the data in the back end. § Experience in Informatica Power Center 9.x and above (ETL - Designer, Workflow Manager), Job Schedulers. § Must have experience in building complex SQL queries and Shell scripting. § Strong on DW Fundamentals & DW concepts. § Understands and review technical requirements, designs ETL process flow and walkthroughs and performs data profiling of required source systems. § Extensive experience in Data Modeling & Architecture. § Experience in full lifecycle data warehouse development. § Excellent understanding of various relational database design concepts. § Experience in managing BI App Support & Maintenance projects. § Experience in Data Migration and Data Quality initiatives. § Error handling and Performance Improvements. § Conduct and participate in design and code walkthroughs. § Good hands on capability - can independently develop good quality deliverable and guide/mentor junior team members effectively. § Participate in requirements gathering sessions with stakeholders from business and IT teams. § Communicates effectively with business partners to identify needs and evaluate options. § Help BI reporting developers with analyzing data source, designing, testing and implementing Analytics reports and dashboards |