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.
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
Photon Chennai, Tamil Nadu, IND Office
DLF IT Park 1/124 Mount Poonamallee Road Sivaji Gardens Manapakkam , Chennai, India, 600089
Similar Jobs
Agency • Information Technology
Design, build and maintain ETL mappings and data models; write SQL and Snowflake queries; manage ETL/infrastructure on AWS (EC2); use Informatica, Control-M and ServiceNow; script in Python/Shell/PowerShell; collaborate with onshore/offshore teams and define BI delivery strategy.
Top Skills:
AngularAws Ec2Control-MDaticalInformaticaJenkinsPower BIPowershellPythonServicenowShellSnowflakeSQLStashTableauUdeployUnix
Agency • Information Technology
Design, develop, and optimize ELT/ETL pipelines and data models using SQL, Python, and cloud services (AWS). Enable cloud data movement to Snowflake, perform SQL performance tuning, support code migrations, and collaborate in agile, distributed teams to deliver analytics-ready data solutions.
Top Skills:
Aws Ec2Aws EmrAws S3Control-MDevops ToolsJIRAOraclePythonSnowflakeSnowsqlSQLUnix Shell
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Responsible for lab equipment maintenance, calibration, troubleshooting, and team leadership while ensuring compliance with regulations and conducting failure analysis.
Top Skills:
3D X-RayBend TesterCsamFibFtirHast ChamberIso/Iec 17025LinuxReflow OvenSemShock TesterSoak ChamberTemp CycleTemperature ChamberTesterThbWindowsX-Section
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
