Job Title: Data Modeler

About Us

“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.

WHY JOIN CAPCO?

You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

Job Description:

Experience: 7 - 12 years

Hiring Location: Bangalore / Pune

Responsibilities:

Responsibilities Translate Business Requirements to Conceptual, Logical and Physical Data Models
Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of requirements and/or from a Logical Data Model
Participate in mapping of Logical to Physical Data Models and vice versa
Perform model creation for large set of data which are being sourced to Big Data

Role Requirements

Strong Data Modeler with Financial Services experience
Knowledge of and experience using data models and data dictionaries in a Banking and Financial Markets context
Demonstrate a continual desire to implement “strategic” or “optimal” solutions and where possible, avoid workarounds or short term tactical solutions
Working with stakeholders to ensure that negative customer and business impacts are avoided
Manage stakeholder expectations and ensure that robust communication and escalation mechanisms are in place across the project portfolio
Good understanding of the control requirements surrounding data handling

Experience/Skillset

Excellent analytical skills and commercial acumen
Experience in ETL/ELT as well as Entity Relationship (ER) data modelling
Understanding of slowly moving dimensional Datawarehouse (star schema, kimball dimensional data modelling)
Good knowledge of SDLC and formal Agile processes as well as testing experience
Can write SQL (NoDQL) and Python queries, Scala knowledge preferable and navigate data bases especially Hive, CMD, Putty, Note++
Strong self-starter with strong change delivery skills who enjoys the challenge of delivering change within tight deadlines
Strong verbal and written communication skills
Ability to manage multiple priorities
Knowledge of and experience using data models and data dictionaries in a Banking and Financial Markets context
Preferable knowledge and experience in Data Quality & Governance
Enthusiastic and energetic problem solver to join an ambitious team
Business analysis skills, defining and understanding requirements
Attention to detail
Ability to communicate effectively in a multi-programme environment across a range of stakeholders
Knowledge of Hadoop of Google Big Query is a plus

Apply for this Job

* Required

First Name *

Last Name *

Email *

Phone *

Location (City) *

Resume/CV *

Dropbox Google Drive

(File types: pdf, doc, docx, txt, rtf)

Cover Letter

Dropbox Google Drive

(File types: pdf, doc, docx, txt, rtf)

How many years of total experience you have? *

Highlight your experience in data modeling? *

Experience in designing physical, conceptual and logical data models. *

Do you have experience working in Python? *

Highlight your experience working on OLTP and OLAP. *

Do you have experience working with Domestic / International stakeholders? Please specify the geographies and designation of stakeholders. *

What are the key challenges faced in the project? And how did you overcome them? Eg. Strategic vs tactical solution in case applicable *

Key achievements which you would like to highlight *

What is your short-term career aspiration and long-term career aspirations ? *

Willing to relocate: Electronic city-Bangalore/ Pune *

Electronic City - Bangalore
Pune

What is your CCTC in LPA ? *

What is your ECTC in LPA? *

How soon you can join us (official NP) ? *

Do you have any offer in hand? *

Capco Job Candidate Privacy Notice Acknowledgement *

Capco Job Candidate Privacy Notice Acknowledgement

I acknowledge that the information I provide will be processed and used for the purposes described in Capco’s Job Candidate Privacy Notice.

Enter the verification code sent to to confirm you are not a robot, then submit your application.

Security Code *

This application was flagged as potential bot traffic. To resubmit your application, turn off any VPNs, clear the browser's cache and cookies, or try another browser. If you still can't submit it, contact our support team through the help center.