Posted by: Shaikh Ahmad | February 28, 2013

DWH Architect



Primary technical leader for Workforce Management analytics development including analysis, design, development, and testing of data mart. Duties include dimensional modeling, ETL design and development, report metadata definition, report and dashboard design, and integration with applications environment. A thought leader and team player who can guide a team through all phases of the development lifecycle.

  • Handles the architecture and high level design for products, and contributes to architecture and high level design across products.

  • Provides in-depth subject matter expertise in related domain areas

  • Ensures adherence of the development team to the architectural vision and high level design of the product

  • Provides accurate inputs into effort estimation that helps determine project costs

  • Works as a guide and independently sets directions for medium sized projects, in order to provide a complete end-to-end solution of the product

  • Assumes a mentoring role for different teams across locations – mentoring developers, building the skills of less experienced team members, and proactively suggesting process improvements

  • Analyzes, designs and helps in development of features to meet new customer requirements

  • Providing support in conceptualizing the overall software architecture addressing functional and nonfunctional needs of the software.

  • Determines a course of action, which is then executed by project teams

  • Works on problems of highly complex scope, through expert usage of concepts & principles requiring high levels of judgment & interpretation

  • Prepares proof of concept & participates in the writing of technical documents (functional specifications, design documents, etc.) as required

  • Estimates the work required for new features to be added to products

  • Addresses and manages issues for non-functional needs of the architecture such as scalability, performance, and flexibility.

  • Applies advanced knowledge and experience to the development of new methods, programs and procedures

  • Conducts training sessions for Pre-sales / Engineers around application features

  • Offers expertise cutting across units / providing critical points of view on business issues and makes tactical decisions having an impact on business

  • Interacts with senior management on specialized technical issues

  • Conducts, supports and reports research for capability development of the team/ unit


BE / B.Tech in Computer Science / MCA/ M Tech (Computer Science preferred)

14 years of relevant IT experience

  • Strong analytical, problem identification/solving skills

  • Hands on experience with ETL software and processes (Talend preferred, or others such as Informatica)

  • Hands on experience with BI software (Microstrategy preferred or Business Objects/Cognos etc.)

  • Extensive relational database experience with both Oracle and SQL Server

  • Extensive knowledge of programming technologies for constructing ETL processes including stored procedures/views for extraction, and data cleansing methods

  • Experience in implementing Business Intelligence best practices into design and development processes

  • Solid understanding of data warehouse design, practical application of dimensional data models, and use of star schema

  • Exceptional understanding of relational and multi-dimensional data design and reporting

  • Performance tuning and optimization

  • Strong communication skills

  • Must be able to work both individually and as part of a team

  • System development process tools and methodologies (preferably Scrum and agile software development processes)

  • Software specifications and design techniques

  • Application development tools (including workstation operating systems)

  • Programming concepts and languages

  • Unit testing frameworks and functional testing frameworks


  • Microsoft SQLServer and Oracle

  • Talend

  • Microstrategy






Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: