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
Top Skills
What the Team is Saying
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of
business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance,
and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent.
TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients.
DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success.
DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions.
ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
.jpg)
