SKILLS:

Mandatory:

• Data Integration
  
  • SSIS 2008, 2005 (DTS is a plus)
• Databases
  
  • SQL Server 2008, 2005:
    • Database design and administration
    • T-SQL querying and programming
    • SQL Server Agent
  • MS Access
  • MS Excel, CSV and other data formats
  • mySQL and other databases is a plus
• Fluent English (both technical and verbal)
• No restrictions for business travels
• Presentation and technical writing skills

Nice-to-have:

• Programming and scripting
  
  • .NET Framework 2.0, 3.5, 4.0
  • C#, VB.NET, F#
  • PowerShell
  • Windows command shell
• Business Intelligence tools
  
  • SSAS
  • OBIEE
• Experience in global multi-market projects
• Basic understanding of trade marketing processes

RESPONSIBILITIES:

• Develop the templates of the SQL Server 2008 (2005) objects, according to the customer documentation, including:
  
  • SSIS packages,
  • Tables,
  • Stored procedures,
  • Data load interfaces documentation templates;
• Contribute to the project documentation and presentation materials;
• Implement object templates to the customer markets, configure and customize SSIS interfaces to the market requirements
• Perform data migration and transformation, analyze customer market data of various formats and sources, including:
  
  • MS SQL Server,
  • Oracle,
  • MS Access,
  • MS Excel,
  • CSV and TXT files;
• Set up and maintain markets’ development and production SQL Server environments when this assistance is requested;
• Participate in development, testing and maintenance of the software applications and tools using .NET technologies:
  
  • IDE – Visual Studio,
  • Languages – C#, VB.NET, F#,
  • Graphical subsystems – Windows Forms, WPF,
  • PowerShell, PHP, command line and other scripting;
• Respond to the requests from the customer markets, remotely consult local IT resources of the customer via e-mail, IMS and by phone , provide assistance limited with the project extents, including:
  
  • SSIS packages,
  • Data flow,
  • .NET applications and tools functionality;
• Be ready for foreign business-trips and on-site support in case of requests from the customer markets.