â€¢ Translates business requirements into technical details. Resolve user-identified functional and technical issues relating to Data Mart and reporting services.
â€¢ Provides onsite/offshore technical leadership on large, complex DW projects. Leads a team of offshore engineers and responsible for on-time delivery of allocated DW project/project modules. Verify/Validate/QA the teams work to ensure that the team generates high quality output.
â€¢ Collaborate with Architect/Center of Excellence teams to develop IP based solution frameworks and productivity accelerators.
â€¢ Possesses a broad understanding of the DW architecture (Data model, ETL and BI/OLAP reporting)
â€¢ Possess technical problem solving skills in database/ETL performance tuning including meta-data skills, analyze query plans, indexes, and locking behavior.
â€¢ Defines documents and communicates the project progress to Project Manager/ Architect/Delivery Manager (follow Virtusa Bi/DW development methodology).
â€¢ Participates in BI/DW practice development including sales proposals
Required Skills :
â€¢ Educational qualification: BS/MS degree in Engineering / Computer Science.
â€¢ Possess excellent verbal and written communication skills, with ability to work in a team environment, interacting with multiple groups on a daily basis
â€¢ Possess hands on experience:
o ETL/ELT - design and implementation experience loading to Star Schemas, Snowflake Schemas and 1-3NF data models including error/suspension handling, control processing, data cleansing, and performance design.
o Ability to write and understand scripting languages (UNIX Shell Scripts, Perl, Python)
o Strong SQL programming skills and strong relational database knowledge including the ability to write, analyze, and debug queries.
â€¢ Extensive experience with IBM - Infosphere â€“ Data Stage 7.5x and Data Stage 8.0, Information Analyzer, Data Stage, Profile Stage, Meta data workbench.
â€¢ Experience/Knowledge with at least one of the following:
o Microsoft - SQL Server SSIS
o Oracle â€“ OWB
o Business Objects
Other skills (desired) :
â€¢ ETL/BI-Tools Consolidation/Migration expÃ©riences a plus
â€¢ Production system/ DW warehouse maintenance experience is a plus.
â€¢ Consulting experience with a large multi-national is a plus
â€¢ Technical Documentation skills a plus
â€¢ Business Analysis skills a plus
â€¢ Delegation and time-management skills a plus
â€¢ Ability to apply for a visa â€“ no prior visa rejections.
â€¢ International travel to client location for short/long term as needed.
Virtusa (Pvt) Ltd.
Phone: 040 - 66536000 Ext: 4810 |