Description

Create new fields/columns in Redshift and trace downstream propagation (DBT → QuickSight → reports).

- Build and modify DBT views — staging, intermediate, and marts layers.
- Understand and maintain data lineage across the full stack.
- Architect new data feeds for reporting and analytics consumption (Glue, S3, Redshift).
- Build ETL/ELT pipelines for new data sources as they come online.
- Design and implement schema changes with full impact analysis before deployment.
- Collaborate with reporting team members on the reporting data layer — they handle BI; this role handles engineering.
- Write and optimize complex SQL for data transformations and performance tuning.
- Partner with Data Governance Analyst to ensure current objects are cataloged and documented at creation

Enable Skills-Based Hiring No ECMS REQ IDAdditional Details

- ECMS REQ ID : 580352
- Project Location 1 : Pan India
- Project Location 2 : (No Value)
- Project Location 3 :



(No Value)
- Project Location 4 : (No Value)
- Delivery SPOC : [email protected]
- Relevant Experience : 8-10 years
- Mandatory skills : • AWS Glue / Redshift / S3• Python / Spark• SQL and data modeling• ETL/ELT pipeline delivery• Data lake architecture
- Desired skills : AWS Glue / Redshift / S3• Python / Spark• SQL and data modeling• ETL/ELT pipeline delivery• Data lake architecture
- Domain (Industry) : Insurance
- BGC (Before onboarding / After onboarding) : PreOB
- Total Experience (Ex. 5-7 Years) : 10+ Years
- BGC Details : Infosys Standard
- BGC Vendor : Infosys Standard
- Mode of Interview : Face to Face
- WFO / WFH / Hybrid : Hybrid
- Please enter shift timings : 11:00 AM to 8:00 PM IST
- Shift Timings : General

📌 580352_DNAINS_Sr. AWS Data Engineer_India (India)
🏢 Trigent Software
📍 India