Required Skills:

- ETL Development
- SQL
- AWS Data Services
- Relational Databases
- Data Modeling
- Production Support
- Python

Nice to Have:

- Informatica
- Apache Spark
- DBT
- Apache Airflow

Key Responsibilities 1. Data Engineering & Warehouse Development • Own and support enterprise data warehouse solutions and ETL processes. • Design, develop, maintain, and optimize ETL/ELT pipelines. • Write, maintain, and optimize SQL scripts for data integration, transformation, and reporting requirements. • Analyse and tune SQL queries to ensure efficient processing of large datasets. • Design scalable data models and data integration solutions. • Investigate production issues, perform root cause analysis, and drive resolution independently. • Ensure data quality, consistency, and integrity across source systems and downstream consumers. • Support modernization and cloud adoption initiatives. 2. Enterprise Data Layer Development • Design and implement curated, business-ready datasets for reporting, analytics, and AI use cases. • Build and maintain scalable data pipelines using traditional and cloud-native technologies. • Apply dimensional modelling techniques and create optimized analytical data models. • Design reusable and maintainable data engineering solutions aligned to business requirements. • Drive continuous improvements in performance, scalability, and operational stability. 3. Data Platform & Cloud Enablement • Work with AWS-based data platforms and services to support data ingestion, transformation, and consumption.



• Support secure and governed data access across the platform. • Collaborate with business and technical stakeholders to gather requirements and deliver scalable solutions. • Support data cataloguing, governance, and operational best practices. • Take ownership of assigned deliverables and ensure timely, high-quality execution. Mandatory Skills ETL & Data Warehousing (Must Have) • Strong experience in ETL design, development, and support. • Strong understanding of Data Warehousing concepts. • Experience with dimensional modelling and data integration architecture. • Hands-on experience designing and maintaining enterprise data pipelines. • Experience handling large-scale data processing and transformations. SQL & Database Technologies (Must Have) • Strong hands-on experience writing complex SQL queries in production environments. • Expertise in query optimization and performance tuning. • Experience working with: o Complex joins o Subqueries o Common Table Expressions (CTEs) o Window functions o Aggregations o Views o Stored procedures • Ability to analyse execution plans and optimize query performance. • Hands-on experience with one or more relational databases (Oracle, SQL Server, PostgreSQL, MySQL,



Teradata, DB2, etc.). Cloud Exposure • Exposure to AWS cloud services and cloud-based data platforms. • Understanding of cloud-based data engineering concepts and architectures. Additional Required Skills • Data Analysis and Troubleshooting • Data Quality and Validation • Problem Solving and Root Cause Analysis • Stakeholder Collaboration • End-to-End Ownership of Deliverables Good-to-Have Skills • Informatica PowerCenter and/or Informatica Cloud (IICS) • Amazon Redshift • AWS Glue • Python • PySpark • Apache Spark • DBT (Data Build Tool) • Amazon Athena • Amazon S3 • Airflow • AWS Data & Analytics Services Preferred Qualifications • 5+ years of experience in Data Engineering, ETL Development, or Data Warehousing. • Solid hands-on experience writing and optimizing complex SQL queries in enterprise-scale environments. • Proven experience with query performance tuning and handling large-volume datasets. • Strong understanding of enterprise data warehouse architecture and dimensional modelling. • Experience working with AWS-based data platforms and services. • Exposure to Informatica, Redshift, Python, Spark, or DBT is highly desirable. • Demonstrated ability to independently own deliverables from requirements gathering through production support. • Experience working directly with business stakeholders and driving solutions with minimal supervision. • Excellent analytical, problem-solving, and communication skills.

📌 Data Engineer - GTS CSRD Data Delivery Engineer - M S A (Bengaluru)
🏢 Cigres Technologies
📍 Bengaluru