ETL Programmer Analyst - hyderabad

Company  : Kantar  Operations

Location :  Hyderabad  ( Vanenburgh  IT  Park )

Website : http://www.kantaroperations.com



ETL Programmer Analyst


Role Summary:

We are looking for an innovative and motivated individual to help us transform our ETL methodologies. We collect data from various media, including television, print and internet in a complex database environment. In our West Chester, PA office, data is fed from various collection systems into a data warehouse and data marts where it is made available to our clients via web based applications. Our Database Systems Group is responsible for supporting, maintaining and enhancing database feeds and custom ETL processes. The job candidate whose abilities to help us achieve marks in “enhancing”, as we evolve our future, is the person we are looking for!

Essential Responsibilities:
• Migrating existing systems to current cutting edge platforms and tools.
• Support existing ETL (Extract, Transform and Load) applications in a complex database environment
• Design and write new ETL programs, and modify existing ETL processes
• Provide on-call support in a complex production environment (ability to quickly and accurately diagnose problems and apply appropriate remedies)

Competencies:
• Motivated self-starter – able to take the ball and run
• Ability to take ownership for assigned tasks and work independently to find/build solutions
• Able to remain results-oriented, while multitasking in a dynamic and changing environment
• Focused on providing long-term solutions as we move to the future

Essential Knowledge, Skills and Abilities:
• Ability to design solutions and accurately estimate level of effort and completion dates
• Excellent analytical skills
• Excellent written and verbal communication skills
• 5+ years programming experience
• 3+ years of C# experience and/or .net
• 3+ years of Transact SQL and/or embedded SQL experience
• Experience with latest versions (2008) of MS Visual Studio and MS SQL Server
• Ability to work well in a team environment where collaboration and peer-support is critical
• Knowledge of UNIX, Sybase, Kornshell

Optional Valued Knowledge, Skills and Abilities:
• C++, C
• Microsoft SQL Server experience setting up SSIS/DTS packages
• VAX/VMS
• Third-party ETL Tools/Vendors (e.g. Informatica)
• College degree preferred

Work Environment
• Office Environment
How to Apply
1. If u have received a mail from me ...reply to that mail with your CTC details

Else

2. Send in your resume to bala@crest.in  with ETL  as the subject  ...Include CTC details in your mail

New Positions available for the Same JD as given below

Microsoft BI- SSRS/ SSIS/SSAS

Company : Microsoft  Corporation

Location : Hyderabad

Job Description

Introduction

The Partner Integrated Reporting (PIR) Team at BI Engineering Group - MSIT (India) is looking for a well-qualified person who has prior experiencing in design and implementation of 2-3 end-to-end BI Solutions on Microsoft Technology Stack. This is an IC role. The BIE Team at MSIT India deliver BI solutions for key Microsoft Businesses e.g. Consumer, Partner, Sales and Marketing etc. The PIR Team at BIE is responsible for delivering BI capabilities to Microsoft Partner Teams for enabling key reporting capabilities around the Partner Business of Microsoft. The PIR Team is engaging in a new effort for the upcoming year to deliver enhanced BI capabilities to Microsoft Partner Teams (Next Generation PIR Effort). The PIR Team is looking for a Senior Technical Leader who can help drive the Technical and Architectural direction of the Next Generation PIR across the entire BI SDLC.

Job Position

·     Should have excellent communication skills. Able to talk efficiently and effectively with the global development team and have the talent of challenging technically.

·     Should have 6+ Years of IT Experience with at-least 4 years in the Design and Development of end-to-end BI Projects

·     Should have exposure to complete SDLC for building a BI Application (Requirement Analysis, Design, Development, Deployment and Support)

·     Displays high degree of Confidence and ability to work in ambiguous situations

·     Should be able to Lead the Technical Architecture / Design for the BI Application

·     Should be effective at Cross Group collaboration

·     Should have capability to influence Architecture / Design for Medium to Complex components for the BI Application (within and across the Organization)

·     Evangelizes Technology Patterns and Best Practices

·     Must able to lead a project with less dependency and control the project with respect to schedule and quality.

·     Displays great negotiation skills and displays ability to influence others

·     Excellent Team Player

·     Be an active participant on design, development and support of the project.

·     Bring technical expertise based on development experience, and make sound technical decisions to deliver high quality projects

Responsibilities:

·         Ability to drive Application Development Plans for Medium to Complex deliverables or for entire Release

·         Dimensional Modelling (Physical and Logical)

·         Design and develop ETL and relational Staging and Data Mart Databases.

·         Design and develop multi-dimensional Schemas.

·         Design and develop reporting systems for internal and external partners.

·         Contribute to development methodologies and best practices in the BI space

·         Active participation in technical investigations and prototyping

·         Evangelize on Microsoft BI Platforms and build tools to enhance Team Productivity

·         Define, Optimize and Manage the Version Control Strategy for the Project

·         Experienced in Performance Tuning specific areas of a BI Application (Database Code, ETL, Reporting, OLAP)

·         Experienced in Version Control Tools and Collaboration like Visual Source Safe, VS DB Pro and VSTF

·         Exposure to Microsoft Collaboration platform like Microsoft SharePoint Portal