Sign In
 [New User? Sign Up]
Mobile Version

TaCIT- CDT-SQL Server Developer (Customer Data & Analytics)

Bengaluru, KA
Job Code:
  • Oil & Gas
Applying for this job will take you to an external site
  • Shortlist
  • Email Friend
  • Print

Job Details

Technical & Competitive IT (Tacit) Customer data and analytics team (CDA) is accountable to develop, deploy and sustain leading edge marketing and advanced analytics platform capabilities for Shell which (a) consolidates data from a variety of (internal and external) sources, (b) analyses that data to deepen our customer knowledge and build personalized, targeted campaigns, and (c) integrate those campaign offers through multiple channels such as mobile, web and e-mail direct to our customers using the channel with which they prefer to interact with Shell. This provides a truly leading edge customer experience which delivers sustainable competitive advantage and business value to Shell.PurposeData is essential for all the advanced customer data and analytics capabilities and customer CVPs delivered through CDA foundation platform.The purpose of the position is to work in the capacity of SQL developer to design, develop, support and manage the delivery of database solutions in the Customer data and analytics group, sustain and improve the delivery of customer experiences, analytics and reporting done through the enterprise CRM and digital platform.AccountabilitiesUnderstand the data model of various source systems and destination CDA platform.Manage the mappings of source to destination data.Work with Enterprise integration services team, CDA Data Business analyst to develop / update interface specifications.Analyse, Identify and implement improvements to work processes. Support data quality maintenance and improvement.Work with senior colleagues to learn from their experience. Identify knowledge gaps and proactively seek development opportunities.Build strong working relationships with business customers and develop understanding of their requirements and business processes.Conduct quick impact analysis of project or production support changes.Participate in evaluation of new technologies and support technical PoC s to de-risk projects and upgrades.While IT support owns the currently live data source integrations, the data analyst is expected to provide support on data integration to ITSO , support deployments of new changes, releases and ensure up times of the platform for maximization of business value.DimensionsGlobal scope with opportunity to work with multiple businesses across RDS in time (initial focus DS Retail)Wide range of internal and external stakeholders (Businesses, functional IT, IT support, Product Vendors etc).Special ChallengesNeeds to be able to deal with state of the art, differentiated and often unproven technologies which require some learning on the jobNeeds to be comfortable with sometimes vague and changing scope and priorities in a rapidly changing environmentAbility to interact and build relationships both within Shell (IT & Business teams) and external (IT partners and BPO partners)Additional CommentsOpportunity to work on enterprise platform across multiple CoB.Opportunity to work on Tier 1 high visibility program in Shell.Opportunity to work in truly multi-national, multi-cultural, fast paced environment.Opportunity to influence Shell's bottom line in a very measurable and meaningful way.Opportunity to shapeRequirementsExperience, Skills and Qualifications required5 8 years of total experience.SkillsWorking experience with the following core technologies SQL Server 2008 R2/2012, Visual Studio 2113 or higher, SQL Server Data Tools & Team Foundation Server.Expert T-SQL development skills including query optimization, stored procedures, views, functions and triggers; ability to read, interpret and improve query execution plans.Experience in analysing, designing and supporting applications that interface with database.Skilled in database architecture and design principles including relational database design, views, indexes and joins.Demonstrated experience in refactoring, testing, debugging, and optimizing SQL code.Demonstrated experience in performance tuning code and managing large amounts of data through house keeping processes.Business Partnering & Value - AwarenessDevelop & Manage Suppliers- AwarenessIncident, Threat & Vulnerability Management - KnowledgeI & D Design Integrity - KnowledgeIT Architecture- KnowledgeIT Service Delivery & Support Processes - SkillLandscape & Configuration Management- SkillProgramme Management - AwarenessSoftware Engineering- Skill
Additional Degree: BE/ B.Tech (Engineering)

Experience: 5-8


Application Programming | Business/Systems Analysis | Database Administration (DBA) | Software Engineer
Applying for this job will take you to an external site


© Copyright 2015 Al Nisr Publishing LLC - powered by Gulf News