Senior Data Engineering
Job Location:
Monthly Salary:
Posted on:
Vacancies:
Job Summary
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 acrossbanking 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:
Youll design build execute and continuously improve automated tests to ensure our software is reliable secure and performs as intended. Youll 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
Required Experience:
Senior IC
About Company
Capco is a global management and technology consultancy dedicated to the financial services and energy industries.
