CGI Hiring Associate Consultant-MSBI Architect

Job Description

Associate Consultant_MSBI Architect

Position Description
Provides first level supervision to the team of Professionals in Applications Development sub-function. The team supervisor’s focus is on mentoring, coaching, coordination as well as providing technical leadership. Leads teams in the design and development of software applications or specialized utility programs that will enhance the organization’s/client’s ability to achieve strategic goals and targets

Your future duties and responsibilities
• Member will be responsible for Design and provide solution to the functional enhancements, legislative changes and maintenance updates to the existing BI application.
• Member will be responsible Technical Design documents based on user Functional Specifications and in collaboration with the Product Specialist(s) and the Environment.
• Member Leads the data architecture and design/enhance for a Data Warehouse assignment
• Member should take ownership of complete data architecture and capable of suggesting design solutions
• Member should have very Strong knowledge in ETL (SSIS, Informatica) with Kimball methodology
• Member will be responsible to provide scoping and estimating on Data Warehouse activities
• Member should work closely with other Technical architect, project members and project management to document standards and procedures for the definition of reference architectures
• Member will be responsible to review other project members prepared technical documents and finalize the documents
• Member should Interact and works directly with onshore team members on projects and support issues
• Follows change management and problem management processes
• Member should be responsible for coordination with customer on the design review and architectural decisions

Required qualifications to be successful in this role
• Knowledge on SQL Server 2008 R2 or SQL Server 2012/14/16
• 12 to 14yrs of Total Experience with Relevant of 8 to 12 Yrs in required technical skill
• Candidate should have Strong expertise in DWH concepts
• Candidate should have working knowledge in data modeling tool (ER/Studio or Erwin)
• Good to have exposure VLDB system
• Should have work experience in SSAS, SSRS
• Intermediate knowledge in C#
• Intermediate knowledge in PowerShell Script
• Knowledge in SharePoint 2010/2013
• Good to have domain knowledge with Energy (petroleum/Gas) product
• B.E. / B.Tech. / M.C.A Preferred