Senior Data Engineering

About this role

<p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong>Job Title:   Automation Tester</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong>Location-Bangalore</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong>Exp-3+ years</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong>About Us</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><em>“Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the  </em><em>British Bank Award and </em><em>has been ranked Top 100 Best Companies for Women in India 2022 by </em><a href="https://avtarinc.com/what-we-do/enrich-diversity/best-companies-for-women/"><em>Avtar & Seramount</em></a><em>. 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.  </em></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong><em>WHY JOIN CAPCO?</em></strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">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.</span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong><em>MAKE AN IMPACT</em></strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">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.</span></p> <p> </p> <p> </p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong><em>#BEYOURSELFATWORK</em></strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;">Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.</span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong><em>CAREER ADVANCEMENT</em></strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><em>With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.</em></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong><em>DIVERSITY & INCLUSION</em></strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><em>We believe that diversity of people and perspective gives us a competitive advantage.</em></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong>MAKE AN IMPACT</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong>Job Description:</strong></span></p> <div data-ccp-timestamp="1773216781008"> <p>You’ll design, build, execute, and continuously improve automated tests to ensure our software is reliable, secure, and performs as intended. You’ll work closely with engineers and product partners to prevent defects early, strengthen engineering quality, and help teams ship with confidence.</p> <p>Key responsibilities</p> <p>-</p> <p> ✅ Data Engineering & Development • Design, develop, and maintain scalable ETL/ELT pipelines • Write complex SQL queries, stored procedures, functions, and triggers • Optimize database performance through indexing, query tuning, and partitioning • Work with structured and semi-structured data</p> <p>✅ Data Warehousing & Modeling • Build and maintain data warehouse/data mart structures • Implement data models (star schema, snowflake schema) • Ensure data quality, integrity, and consistency</p> <p>✅ Cloud & GCP (Nice-to-Have / Preferred) • Work with GCP services such as: o BigQuery (data warehouse) o Cloud Storage o Dataflow / Dataproc o Pub/Sub • Migrate on-premise data pipelines to cloud (if applicable)</p> <p>✅ Data Pipeline & Integration • Integrate data from multiple sources (APIs, databases, flat files) • Build batch and (preferably) near real-time pipelines • Work with ETL tools or build custom pipelines</p> <p> ✅ Collaboration & Delivery • Collaborate with Data Analysts, Data Scientists, and Product teams • Translate business requirements into scalable data solutions • Participate in code reviews and maintain…