Job Title: Dataiku Developer
Location-Mumbai
Exp-7-10 years
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.
MAKE AN IMPACT
Job Title: Dataiku Developer – Data Analytics & Reporting
Domain: Payment
Exp: 6-9 years
Location: Mumbai
Position Purpose:
- We are looking for a strong Datawarehousing resource with 6 to 8 years of hands-on experience in Dataiku DSS, strong SQL programming skills in PostgreSql or Teradata databases, good hands-on on python programming and basic tableau reporting.
- Thecandidate will be a core member of the Data Analytics & Reporting Tribe, working on the design, development and operationalization of end‑to‑end data solutions using Dataiku DSS.
- The candidate should be able to independently design, build, debug, maintain, and enhance analytics solutions while collaborating effectively with business teams.
- The role focuses on translating business requirements into robust, scalable data pipelines, data‑modeling and self‑service analytics while ensuring data‑quality, governance and performance standards of the BNP Paribas group.
- We are looking for top-notch, energetic talent to keep up with the industry’s momentum and support the team efforts.
Responsibilities:
Direct Responsibilities
- Design, build and maintaindata pipelines, recipes and flows in Dataiku DSS to ingest, transform and expose data from source systems (PostgreSQL, Teradata, flat files, etc.) into the enterprise data warehouse / lake.
- Implement data‑warehousing concepts(dimensional modelling, slowly‑changing dimensions, star/snowflake schemas, data vault) to support analytical reporting and BI consumption.
- Develop reusable Python code(Pandas, PySpark, SQLAlchemy) within Dataiku plugins, recipes and notebooks for data cleansing, enrichment and advanced analytics.
- Ensure data quality and consistencyby defining validation rules, unit tests and automated data‑quality checks inside Dataiku.
- Collaborate with data architects and business analyststo translate functional requirements into technical specifications, functional designs and implementation plans.
- Document technical and functional artefacts(design specs, data dictionaries, operational run‑books) and contribute to knowledge‑base for the Data Tribe.
- Set up CI/CD pipelines(GitLab) for Dataiku projects to automate testing, versioning and deployment across environments (dev / test / prod).
- Monitor and optimisepipeline performance, storage utilisation (Parquet/ORC) and cost on the cloud infrastructure (Kubernetes Engine, IBM Cloud).
- Support production incidentsand perform root‑cause analysis, applying fixes and preventive measures.
- Mentor junior team membersand champion best practices in data engineering and Dataiku usage.
Contributing Responsibilities
- Act as a team player and actively participate in squad ceremonies (stand‑ups, sprint planning, retrospectives).
- Adhere to Group standards (coding conventions, security, data‑governance, CI/CD).
- Promote a culture of continuous learning, sharing insights about Dataiku, data‑warehouse trends and emerging technologies.
- Work closely with cross‑functional teams (Data Scientist, BI, Business Units) to understand data needs and deliver reliable solutions.
- Able to integrate in a French-Indian agile extended team.
Technical & Behavioral Competencies
- Experience of 6-8 years in creating data-warehousing solutions using Dataiku DSS required.
- Strong background in data‑warehousing concepts, ETL design, and performance tuning.
- Experience building projects, recipes, plugins, APIs and orchestrations in Dataiku.
- Strong SQL programming hands-on experience in creating procedures, functions, writing complex SQL queries. Knowledge on PostreSql / Teradata will be a add-on.
- Programming - Strong hands-on experience in Python, concepts such as OOPs, reusable utilities, exception handling, debugging, and clean code practices and scripting within Dataiku.
- Hands‑on with GitLab or similar tools to automate builds and deployments.
- Knowledge of Kubernetes, Docker and cloud storage (COS) for scalability.
- Experience with Parquet, ORC and other columnar storage formats.
- Experienced user of ALM/QC, JIRA, Confluence, SharePoint.
- Excellent oral and writing communication skills.
- Experience in working in Agile environment.
- Add‑On (Nice‑to‑have) Apache Airflow – experience building DAGs and orchestrating Dataiku pipelines.
- Add‑On (Nice‑to‑have) Data Visualization – exposure to tools such as Tableau.
- Add‑On (Nice‑to‑have) Streaming / Search – familiarity with Kafka, Elasticsearch, Kibana.
Specific Qualifications:
- Minimum 6 - 8 years of experience along with Bachelor's Degree - in IT, Computer related field or equivalent experience.
Skills Referential (Required knowledge, skills and abilities)
Other Skills:
- Agile methodology exposure
- Knowledge of banking products is a nice to have
- Proactive mindset
Skills Required
- 6-8 years hands-on experience creating data-warehousing solutions using Dataiku DSS
- Strong SQL programming experience (complex queries, procedures, functions) — PostgreSQL or Teradata
- Strong Python programming (OOP, reusable utilities, exception handling, debugging) including Pandas and PySpark
- Develop reusable code within Dataiku (projects, recipes, plugins, notebooks) and data transformations
- Experience with data-warehousing concepts and ETL design (dimensional modelling, SCDs, star/snowflake, data vault)
- Implement automated data quality checks, validation rules and unit tests inside Dataiku
- Experience with CI/CD pipelines using GitLab for testing, versioning and deployment
- Knowledge of Kubernetes, Docker and cloud storage (COS) for scalable deployments
- Hands-on experience with columnar storage formats (Parquet, ORC)
- Experience with ALM/QC, JIRA, Confluence and SharePoint
- Bachelor's degree in IT, Computer related field or equivalent experience
- Exposure to Tableau for data visualization
- Experience building DAGs and orchestrating pipelines with Apache Airflow
- Familiarity with streaming/search technologies such as Kafka, Elasticsearch, Kibana
- Agile methodology experience and ability to work in cross-functional squads
What the Team is Saying
Capco Compensation & Benefits Highlights
-
Healthcare Strength — Health, dental, and vision coverage are described as solid with low copays and a good variety of choices, complemented by mental‑health resources, an EAP, and wellbeing events. Company materials emphasize global availability of these supports.
-
Parental & Family Support — Enhanced maternity, paternity, adoption, and shared parental leave are highlighted, with several months of maternity leave noted in the U.S. in some accounts. Additional paid leave is called out for life events such as pregnancy loss, fertility treatment, menopause, and bereavement.
-
Wellbeing & Lifestyle Benefits — A global wellbeing program, coaching/mentoring, mental‑health initiatives, and wellness reimbursements (e.g., gym, fitness) are positioned as core parts of the offering. Flexible working is emphasized alongside regionally tailored wellbeing events.
Capco Insights
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.
