Senior Data Engineering
Capco Technologies Pvt LtdJob Description
Senior Data Engineering
Job Title: Automation Tester
Location-Bangalore
Exp-3+ 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 Description:
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.
Key responsibilities
-
✅ 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
✅ Data Warehousing & Modeling • Build and maintain data warehouse/data mart structures • Implement data models (star schema, snowflake schema) • Ensure data quality, integrity, and consistency
✅ 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)
✅ 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
✅ Collaboration & Delivery • Collaborate with Data Analysts, Data Scientists, and Product teams • Translate business requirements into scalable data solutions • Participate in code reviews and maintain documentation
Required Skills (Primary)
🟢 Core SQL / PL-SQL Expertise • Strong hands-on experience in: o Advanced SQL (joins, window functions, CTEs, aggregations) o PL/SQL programming (procedures, packages, cursors) • Experience with databases like: o Oracle / SQL Server / PostgreSQL / MySQL
🟢 Data Engineering Fundamentals • Strong understanding of: o ETL/ELT frameworks o Data warehousing concepts o Data modeling techniques • Experience handling large datasets,
Preferred / Secondary Skills
🔵 GCP Ecosystem • Experience with: o BigQuery o Cloud Composer (Airflow) o Dataflow / Apache Beam • Understanding of distributed processing
🔵 Additional Skills • Programming: Python / Shell scripting • Tools: Airflow, Informatica, Talend, dbt • Knowledge of CI/CD pipelines • Exposure to Apache Spark / Hadoop ecosystem
Experience Level
Senior LevelJob role
Job requirements
About company
Similar jobs you can apply for
Logistics/ Warehouse operationsQuality Supervisor
K N P Industries
Junior Software Engineer
Dexterous (Automation Apt)Quality Assurance Executive
Sun MobilityTesting Engineer
Electronics & Controls Power Systems Pvt Ltd
Quality Control Executive
Flavour TroveBusiness Developer (Internship)
Paramjyothi ElectricalsYou can expect a minimum salary of 0 INR. The salary offered will depend on your skills, experience and performance in the interview.
The candidate should have completed the required education and people who have 3 to 31 years are eligible to apply for this job. You can apply for more jobs in Bengaluru/Bangalore to get hired quickly.
The candidate should have sound communication skills and sound communication skills for this job.
Both Male and Female candidates can apply for this job.
No, it's not a work from home job and can't be done online. You can explore and apply for other work from home jobs in Bengaluru/Bangalore at apna.
No work-related deposit needs to be made during your employment with the company.
Go to the apna app and apply for this job. Click on the apply button and call HR directly to schedule your interview.
The last date to apply for this job is . For more details, download apna app and find Full Time jobs in Bengaluru/Bangalore . Through apna, you can find jobs in 64 cities across India. Join NOW!