Please forward resumes at 

Title:                 BI/SSIS Developer                      

Location:           NYC

Duration:           6 + Months 

(Need to be GC or Citizen)

Phone screen followed by In-person interview
Need two professional references from recent projects


Client is seeking a seasoned BI Developer who will be responsible for the 
overall execution of Data Mart builds, aggregations and OLAP cube development.  
Role will include analyzing, planning and developing the architecture to ensure 
that it is in line with business requirements. Will be responsible for driving 
a technical implementation environment using SQL Server 2005, 2008 SSIS, SSAS 
that is tightly aligned with the technical design and business requirements.  
Consultant will deal directly with the technology and will require hands on 
experience with the Microsoft toolset and general Data Warehouse, Data Mart and 
aggregation constructs. The candidate must be able to provide technical 
expertise, knowledge transfer and operational documentation for the solution 
implemented.  This role will include:

  a.. Build SSIS Master and Child packages for initial load of data and 
incremental (monthly) loads of data 
  b.. Manage the ETL function and use of staging tables 
  c.. Proactively diagnose, research, monitor for and resolves SQL and 
database-related faults and performance problems 
  d.. Develop, maintain, monitor, and performance tuning of the Data Mart 
databases and SSAS OLAP cube(s) 
  e.. Act as a high-level technical data expert, and mentors less experienced 
colleagues in addressing data-related problems of systems integration and 
  f.. Develop and maintain appropriate repositories of data model and dataflow 
diagrams relating to the Data Warehouse 
  g.. Develop and communicate project plans, work assignments, target dates and 
other aspects of assigned projects 
  h.. Ensures that data projects follow prescribed Agile development life cycle 
and meet quality standards 
  i.. Function as a technical expert in the design, development, modification 
and debugging of data OLAP cubes and databases, etc 
  j.. Advise technology architects on database subjects appropriate for 
supporting ongoing development efforts 
  k.. Develop ETL specifications, source to target mapping and other 
documentation required for ETL development 
  l.. Ensure appropriate documentation is completed and stored in the 
repository database 
  m.. Develop test cases and plans, and assists with system testing 
  n.. Facilitate communication between developers and business users to ensure 
that customer requirements are correctly translated to appropriate data design 
  o.. 5+ years experience working with Data Warehouses, Data Marts, and OLAP 
  p.. At least 3 years SSIS, SSAS, SSRS(a plus) on either SQL Server 2005 or 
SQL Server 2008 
  q.. In-depth knowledge of dimensional databases, dimensional modeling and 
Data Warehousing required 
  r.. Demonstrated capabilities in building attribute relationships, 
hierarchies, named sets, MDX within SSAS 
  s.. Proficiency in building security models for drill level access to cubes 
as well as within the physical dimensional schema 
  t.. Ability to write reconciliation and validation scripts 
  u.. Experience designing, maintaining and implementing aggregate Data Marts 
  v.. Ability to mentor and lead team members in the areas ETL and OLAP cube 
  w.. Understanding of data analysis, modeling (PowerDesigner preferred) 
  x.. Ability to hit the ground running and begin to build SSIS packages for 
already designed solution 
  y.. Keen attention to detail. With solid multitasking, analytical, and 
problem solving skills 
  z.. Strong SQL Server 2005, 2008 administration skills 
  aa.. Strong SQL / T-SQL skills 
  ab.. Excellent communication, negotiation, and collaboration skills 
  ac.. Experience training end-users is a plus 
  ad.. Experience with Agile development methodologies is a plus 
  ae.. Undergraduate degree or equivalent experience in a Data Warehousing 

Thanks & Regards
Technical Recruiter
Sriven Infosys INC
Voice: 212-999-6251 Ext: 220
Alt: 646-644-2894
Fax: 212-658-9460

Sriven Infosys Inc is an Equal Opportunity Employer. Qualified applicants will 
receive consideration for employment without regard to race, color, religion, 
sex, national origin, ancestry, citizenship, disability, age, military or 
veteran status, and other characteristics.
We help our clients, employees & partners compete and win!

If wanted to be Removed,Plz reply in the subject line "Remove". Sorry for the 
inconvenience caused



You received this message because you are subscribed to the Google Groups 
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at

Reply via email to