The Role
Design, build, and maintain cloud-based ETL/data pipelines in Snowflake. Extract and transform data from heterogeneous sources, optimize SQL performance, implement monitoring, and collaborate across teams. AWS and Python experience are advantageous.
Summary Generated by Built In
Technical
- Min of 3 years exp as Data engineer with exposure to min of 1 ETL tool and knowledge of developing Data pipelines on cloud ecosystem
- Experience in Extracting data from heterogeneous sources, including databases, CRM systems, flat files, web services, etc.
- Knowledge of Data warehousing concept and how data moving from one layer to another till visualization layer.
- Transforming the extracted data involves cleaning, aggregating, mapping, and converting it to ensure it meets the business requirements and is in a suitable format for analysis.
- Experience in Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
- Good SQL knowledge (query performance tuning, index maintenance, etc.) as well as an understanding of database structure
- Knowledge of SQL language and cloud-based technologies
- Experience in developing ETL pipelines in Snowflake Datawarehouse on cloud.
- Performance tuning and setting up resource monitors.
- SQL performance measuring, query tuning, and database tuning
- Coding knowledge in languages like Python is an added advantage.
- Knowledge of working in AWS cloud ecosystem.
.
Behavioral :
- Strong communication skills
- Self Starter, with strong confidence level
- Flexible in thought and creative in approach to testing
- Solid understanding of databases and systems and the ability to communicate effectively across groups
- Interact effectively with peers to resolve issues
- Ability to deal with ambiguity
- Promotes positive and professional work environment
The Skills that are Good To Have for this role
- Experience in ETL Test automation tools is added advantage.
- Experience in PYTHON scripting knowledge
- Experience in Agile methodologies and best practices.
The Expertise We’re Looking For
- 3 to 5 years of relevant experience.
- Bachelor’s / Master’s Degree (e.g., Computer Science, Engineering)
Location: Bangalore
Skills Required
- 3 to 5 years relevant Data Engineering experience
- Experience with at least one ETL tool and building ETL pipelines
- Experience developing ETL pipelines in Snowflake data warehouse
- Good SQL knowledge including query performance tuning and database tuning
- Experience extracting data from heterogeneous sources (databases, CRM, files, web services)
- Knowledge of data warehousing concepts and layering to visualization
- Design, implement, and expand data pipelines (ETL/ELT) on cloud
- Experience with performance tuning and setting up resource monitors (Snowflake)
- Knowledge of AWS cloud ecosystem
- Bachelor's or Master's degree in Computer Science or Engineering
- Python coding/scripting knowledge
- Experience with ETL test automation tools
- Experience with Agile methodologies and best practices
- Strong communication skills and ability to work independently
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
