Location: Bangalore
Experience: 3 - 5 Years
Technical / Behavioral -
You must have proven track record of working in collaborative teams to deliver high quality data solutions in a multi-developer agile environment following design & coding best practices.
You must be an expert in using SQL queries with UNIX shell /Python scripting skills.
You should have experience of using AWS services like EC2, S3, EMR to move data onto cloud platform and experience with Enterprise data lake strategy and use of Snowflake (AWS) is a big plus.
You must have knowledge to develop ELT/ETL pipelines to move data to and from Snowflake data store using combination of Python and Snowflake SnowSQL is a big plus.
You should have experience in SQL performance optimization for large data volumes.
You should have proven analytical and problem-solving skills
You should be strong in Database and Data Warehousing concepts.
You must be able to work independently in a globally distributed environment
You must have superior SQL and Data Modeling skills and experience performing deep data analysis on multiple database platforms like Oracle, or Snowflake.
You should have experience in working with devops tools for code migrations.
Nice to have working experience in Control-M or similar scheduling tools.
Nice to have adequate knowledge on DevOps, JIRA and Agile practices.
How Your Work Impacts the Organization
Cloud Enablement and Data Model ready for Analytics.
Skills Required
- Proven track record working in collaborative teams to deliver high-quality data solutions in a multi-developer agile environment following design and coding best practices
- Expert in writing SQL queries and strong UNIX shell / Python scripting skills
- Experience using AWS services (EC2, S3, EMR) to move data onto cloud platforms
- Knowledge to develop ELT/ETL pipelines to move data to and from Snowflake using Python
- Experience in SQL performance optimization for large data volumes
- Strong database and data warehousing concepts, data modeling, and deep data analysis experience on platforms like Oracle or Snowflake
- Proven analytical and problem-solving skills
- Experience working with DevOps tools for code migrations
- Experience with Snowflake (AWS) and SnowSQL
- Experience with enterprise data lake strategy
- Working experience in Control-M or similar scheduling tools
- Adequate knowledge of DevOps practices, JIRA, and Agile methodologies
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.
