Netezza Unix Technical Lead - Hexaware

Job Description

Experience in Data analysis, data mapping, dataloading, and data validation

Understanding business requirements, creating design, and developing ETL using NZ SQL, performing code reviews

Must be able to work with multipleprojects/tasks and the ability to prioritize on the fly Strong written and oral communication skills,with the ability to work with the client.

Experience in leading and mentoring development team is required.

Desired Skills & Experience

8+ years of Experience in DataWarehouse, ETL and Netezza experience.

3+ years of experience in hands-on involvement in the design, development, implementation and maintenance of design artifactssuch as conceptual/logical data architectures and their respective physicaldata models.

4+ years of extensive experience in Unix environment and Shell scripts

Company Description

Hexaware is a global provider of IT and Process outsourcing services. We focus exclusively on maximizing client returns from outsourcing and off-shoring. We have extensive experience in managing large IT applications in real time as well as in providing high value services around packaged enterprise applications such as SAP, Oracle eBusiness Solutions and PeopleSoft.

Our experience in the business process outsourcing arena fully complements and strengthens our service spectrum and allows us to operate as an enterprise-class solution delivery company. Our solutions aim to provide high value by optimising cost of ownership of technology investments for customers.

Hexaware has a client base comprising several Global 1000 organizations. Our commitment is to provide solutions that translate into tangible business outcomes for our customers. Our ‘partner-in-business’ approach generates high business value for customers and rich dividends to Hexaware in the form of a continual stream of repeat business. Hexaware’s domain capability expertise and reduced learning curves enables significant compression in time-to-value deliverables. Our customer-centric philosophy is further strengthened by a robust Key Account Management process to find more ways to delight our key customers and grow market share.

The company's onsite/offshore delivery model provides significant cost savings. Our development centers are assessed at SEI CMMI-Level 5, and are also ISO 9001:2000 and TickIT certified. These help us to continually provide high value, high quality deliverables to our clients. We have consistently delivered to client expectations and have established long lasting relationships with them.

Hexaware's global operations are located in North America, Europe and Asia Pacific.

Additional Information

Posted:

August 6, 2012

Type:

Full-time

Experience:

Mid-Senior level

Functions:

Information Technology

Industries:

Information Technology and Services

Compensation:

Very competitive

Job ID:

3507995

Business Focused Analytics – The Starting Point

Having been a Business Intelligence practitioner for the last 13 years, there has never been a more exciting time to practice this art, as organizations increasingly realize that a well implemented BI & Analytics system can provide great competitive advantage for them. This leads us to the question of – ‘What is a well implemented BI system?’ Let us follow the Q&A below.

Q: What is a well implemented BI system?

A: A well implemented BI system is one that is completely business focused.

Q: Well, that doesn’t make it any easier. How can we have BI that is completely business focused?

A: BI & Analytics becomes completely business focused when they have ‘business decisions’ as the cornerstone of their implementation. The starting point to build / re-engineer a BI system is to identify the business decisions taken by business stakeholders in their sphere of operations. Business decisions can be operational in nature (taken on a daily basis) and/or strategic (taken more infrequently but they tend to have a longer term impact). To reiterate, the starting point for BI is to catalog the business decisions taken by business stakeholders and collect the artifacts that are currently used to take those decisions.

Q: The starting point is fine – What are the other pieces?

A: The next step is to identify the metrics and key performance indicators that support decision making. In other words, any metric identified should be unambiguously correlated to the decision taken with the help of that metric and by whom. Next we need to identify the core datasets in the organization. Please refer to my earlier blog post titled ‘Thinking by Datasets’  on this subject.

Q: What about the operational systems in the landscape? Aren’t they important?

A: Once we have documented the relationship between Business Decisions to Metrics to Datasets, we need to focus on the transactional applications. The key focus items are:

• Inventory of all Transactional Applications
• Identify the business process catered by these applications
• Identify the datasets generated as part of each of business process
• Next step is to drill-down into individual entities that make up each of the datasets
• Once the Facts & Dimensions are identified from the entities, sketch out the classic ‘Bus Matrix’ which would form the basis for dimensional data modeling

 

Q: All this is good if we are building a BI system from scratch – How about existing BI systems?

A: For existing BI applications, the above mentioned process could be carried out as a health-check on the BI landscape. The bottomline is that every single report / dashboard / any other analytical component should have traceability into the metrics shown which should then link to the decisions taken by business users. BI & Analytics exist to help organizations take better business decisions and that defines its purpose & role in an enterprise IT landscape.

The answers mentioned above provide the high-level view of Hexaware’s approach to Business Intelligence projects. We have worked with many organizations across industries and a business focused analytical approach has provided good value for our customers.

Thanks for reading. Please do share your thoughts.

Business Focused Analytics – The Starting Point – Part 2

Business decisions are the cornerstone of a successful BI implementation. Cataloging the decisions taken by the key stakeholders in an organization is the first step in understanding the information requirements for a data warehouse. Capturing business decisions – strategic and operational, is not a simple task as most business decisions tend to be complex requiring diverse data points. Further, when all decisions are collected, how will we know the decisions that have the most impact on the business?

Here’s a simple framework based on the six primitive interrogatives that Hexaware has effectively used while assessing information requirements. This framework helps systematically uncover important dimensions of information and organize them in a format that is easy to comprehend.

Question	Description	Comments	Example
Who?	The decision-maker	Stakeholder	Service Delivery Manager (SDM)
What?	The decision	A decision requiring supporting data / information	Resourcing for a project
Why?	The motivation for the decision	The significance of the decision to the business	Getting the right project team is critical to the success of a services project.
When?	When is the decision made	frequency (or) a point in time	Made during the planning stage and reviewed at periodic intervals
How?	The basis for making the decision – KPI / metrics / a logic	the metrics and datasets required for making the decision	By comparing the skill set requirement and project schedule in the Project plan to the  availability of resources (HR and PMO databases) with the right skills (skills database) and good track record (appraisal database)
Where?	The place where the decision is made	Specifies mobility /  additional access requirement	This information needs to be accessed through extranet

Depending on the stakeholder (mostly), the decisions could be strategic or operational. A manager responsible for carrying out a business process will have an operational view of information and will be making operational decisions relating to his/her sphere of operations.  Decisions taken by top management personnel with longer-term business responsibilities tend to be more strategic.  The above framework helps capture both strategic and operational decisions along with the datasets required to make the decisions.

Successfully capturing the decisions and the relevant metrics and the datasets is only half the story in the assessment for a data warehouse. Let’s reserve the other half for a subsequent blog.

Hope this information was useful. Please do share your comments/suggestions.

Technical Architect

Title	Technical Architect
Categories	North America
Salary	$74,235.00 – $98,400.00/yr
Start Date	18-07-2012
Location	Jamesburg
Job Information	Hexaware Technologies seeks a Technical Architect to work in Jamesburg, New Jersey and various undetermined locations to analyze user requirements and develop software architecture. Prepare technical documents, data mapping, and design. Lead production implementation efforts and provide status reports. Must have a Master’s Degree (or foreign equivalent) in Computer Science, Computer Applications, Computer Information Systems, Management Information Systems, Engineering (any), Math, or related field, plus two years of experience in the IT field. One year of the two years of experience must include experience with SQL and Oracle. In lieu of a Master’s Degree and two years of IT experience, we will accept a Bachelor’s Degree plus five years of progressive experience in the IT field. One year of the five years of progressive experience must include experience with SQL and Oracle. All experience may be acquired concurrently. We will accept any suitable combination of education, training, and/or experience in lieu of the above stated education and experience requirements. Travel may be required. Please use reference HEX40. Send resumes to HR Department, Hexaware Technologies, 1095 Cranbury South River Road, Suite 10, Jamesburg, NJ 08831; EOE; $74,235.00 – $98,400.00/yr, 8am to 5pm M-F, 40hrs./wk. CONTACT: HR Department Hexaware Technologies, Inc 1095 Cranbury South River Road, Suite 10 Jamesburg, NJ. 08831
Unit	3