BI & DWH Positions

Technical Lead - BI MicroStrategy & Teradata Required Skills:

• 10+ years experience working with ETL and BI tools/applications
• 7+ years experience defining, designing and implementing business intelligence solutions utilizing MicroStrategy
• 5 + years working with MicroStrategy installations, configurations, project design and implementation, dashboards, reports.
• 5+ years developing complex stored procedures that incorporate best practices in data retrieval, error trapping, tuning and exception handling
• Experience utilizing the MicroStrategy SDK to customize the look and feel of the UI.
• Expertise in development of datasets, derived metrics, Custom group, Consolidation, dashboards , widgets
• Expertise in development of MSTR Schema Objects
• Hands-on experience in integration with enterprise portals, mobile integration
• Knowledgeable on admin functionalities of MSTR such as User creation, ACL, Movement of objects using command manager, usage of Integrity Manager, setting up of Enterprise Manager, security filters, subscriptions
• Comprehensive knowledge of the MicroStrategy tool suite (I-Server, Architect, Desktop, Web, Narrowcast, OLAP Services and Report Services).
• Participate in ongoing design, code, test and documentation of new database features or data model enhancements Skills/Attributes
• Demonstrated experience w/ Teradata TD12/TD13 w/ expertise in BTEQ scripts development
• Strong understanding of implementing/programming business logic
• Strong work experience using Teradata Utilities (BTEQ, Fast Load, MultiLoad, FastExport, TPump).
• Strong work experience using Teradata Tools (SQL Assistant, PMON, Teradata Administrator).
• Insurance industry experience is a plus.
• Experience on large multi terabytes data warehouses.
• Should be self-starter to identify and implement new enhancements in the Teradata Warehouse environment to keep up with the advancements in DW industry
• Ability to handle multiple priorities in a fast paced environment while driving toward solutions
• Experience with multiple Business Intelligence tools

Big Data Hadoop Developer ------- 08/15/2013

1. Hadoop specifically with Cloudera;
2. Core Java development exp;
3. TALEND ETL;

Comparable tools to Hadoop:
Mongo DB (open source) or Cassandra or Google big table or IBM big insights or DataMeer or Tableau or Karmasphere or MicroStrategy.
The Big Data Engineering team is actively recruiting for an Engineer Specialist, with a solid understanding and extensive hands-on experience engineering Hadoop products for large scale deployments. The candidate must have experience with all components of the Hadoop ecosystem and will contribute to the architecture and engineering responsibilities of the Hadoop offering within Citi’s portfolio.
Knowledge/Experience:
    § 5+ years overall IT experience.
    § 2+ years of experience with Big Data solutions and techniques.
    § 2+ years Hadoop application infrastructure engineering and development methodology background.
    § Experience with full Hadoop SDLC deployments with associated administration and maintenance functions.
1. designing application solutions that make use of enterprise infrastructure components such as storage, load-balancers, 3-DNS, LAN/WAN, and DNS.
2. developing Hadoop integrations for data ingestion, data mapping and data processing capabilities:
    § Well-versed with concepts of high-availability, redundant system design, disaster recovery and seamless failover.
    § Experience with Cloudera distribution (CDH) and Cloudera Manager is preferred.
Technical Skills:
    § Advanced experience with Java, HDFS, MapReduce (hadoop lang), Hive, HBase, Pig, and Flume - all these are hadoop tools and languages.
    § Red Hat Linux, UNIX Shell Scripting, RDBMS, NoSQL, and ETL solutions.
    § Clojure – scripting for hadoop , Cascading, AVRO JSON.
    § Apache Mahout – same as R- statical analytical tool – nice to have.
    § SOLR – search tool nice to have.
    § Lucene – nice to have.
    § Monitoring tools such as Ganglia and Nagios – nice to have.
    § Analytical tools such as Datameer, Karmasphere and R – nice to have.

Position: Microstrategy Consultant/Lead ------- 02/14/2011
Required:
· MicroStrategy certification for versions 8.
· 5+ years of MicroStrategy experience (creating reports, graphs, metrics, attributes, filters, prompts, hierarchies, transformations)
· 3+ years of Narrowcast experience including dynamic subscription
· 3+ years flash dashboard development
· 3+ years MicroStrategy Administration experience
· Experience working on Windows OS as well as UNIX
· Integrity Manager
· ScanMD and MD Doctor
· Written and verbal English communication skills
· Ability to QA/QC deliverables and processes

Sales Director

Responsibilities:
• Manage existing customers and look for new opportunities
• Write proposals for new business
• Manage new opportunities and bring to closure
• Manage projects, working with India based team
• Hands on project architecture, design and some implementation work
• Contribute to InfoCepts marketing efforts including writing whitepapers, doing webinars, participating in trade shows, etc.
Skills, Experience and Background:
• Seven plus years consulting experience in data warehousing and business intelligence services delivery
• Demonstrated business intelligence and data warehousing solutions implementation experience in a Project Lead role.
• Experience with MicroStrategy preferred
• Outstanding written and verbal communication skills
• Position to be based anywhere in the Northeast

Some travel will be required, though given our offshore delivery model, the bulk of the travel is short (one to three days), no more than once or twice a month. The bulk of work can be done from your home-based office.

Sales Engineer

Responsibilities:
• Load data sets to relational databases for building multi-dimensional cubes, configuring and extending demo to showcase product capabilities and proof-of-concept assistance
• Supporting proof-of-concept work and prototype development
• Providing rapid prototyping support for solution demonstrations of software to prospective customers
• Creating databases, structuring and manipulating data (ETL)
• Data cleansing and analysis
• Building OLAP cubes
• Developing reporting scorecards and various analytic views
• Configuring and building extensions to J2EE application leveraging knowledge of Swing, Spring framework
• Web application installation and configuration

Skills:
• At least four years of industry experience in development / consulting / technical presales
• Experience with MS SQL 2005/2008, SQL programming
• OLAP experience (MS Analysis Services 2005/2008) desirable
• Experience creating MicroStrategy content
• Experience with Java/J2EE based web application development, Swing, ANT
• Strong analytical and problem solving capabilities
• Strong written and communication skills
• Ability to meet deadlines and work within a very dynamic environment where a high degree of flexibility is required.

CMS DATA CENTER APPS:
Nexus 7000 Core Cisco switches
Call Manager Cluster
ALL Managed Security Servers
SevOne
Tivoli
NCIRCLE
CITRIX
Mainframe Traffic / Host on Demand
Active Directory
WiFI Access
SharePoint
CAPMS
Microsoft Lync
Mainframe Access
Fujitsu Access
AD & DNS services
Remedy

After CMS Portal maintenance, Please test the applications. Below is the list that are implemented in this maintenance:

1. Update HIOS landing page
2. Create New Skin for Menu Enabled Portlets
3. Enable Microstrategy Reports under BI tab in PROD
4. Content Change in Request Access Portlet
5. Hidden pages show up in menus
6. Browser Detection and Display Message for Problematic Browsers
7. Context Menus Missing from Standard Skin
8. Javascript error when rendering mega-menu
9. OnePI audit logs should not log any trace information
10. CMS search opens in same window, should be in new window
11. ACO Calendar widget height is not displaying correctly
12. Configure the MSTR LB URL in WAB and change the links to point to LB URL

   (To Be Continued)