Data Engineer - ETL, SQL, Snowflake, AWS - BLR

Photon; India; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Photon in India is seeking a data engineering specialist to design and implement ETL mappings, data models, and analytics solutions. You will collaborate with onshore and offshore teams and ensure adherence to architecture and security standards.

Key tools include Informatica, Snowflake, Power BI and Tableau. You will work with SQL, UNIX, AWS EC2, and scheduling with Control‑M, while applying agile practices and dimensional modeling to deliver robust BI capabilities.

Qualifications

• Bachelor's degree in IT/CS/IS required.
• Experience coordinating with cross-functional teams is preferred.

Responsibilities

• Understand requirements, map source to target, and design data model mappings.
• Ensure applications follow architecture standards, risk management, security guidelines, and data governance.
• Develop ETL using Informatica and write SQL/Snowflake queries.
• Work with UNIX environments and data warehousing concepts including dimensional modelling.
• Apply agile methodologies and scripting (Python/shell).
• Leverage AWS EC2, Control-M for scheduling and BI delivery.
• Collaborate with onshore/offshore teams and manage ServiceNow changes.
• Define functional and non-functional requirements and BI delivery strategy.

Skills

ETL development

SQL querying

Unix scripting

Data warehousing concepts

Dimension modelling

Agile methodologies

Python scripting

AWS cloud

Control-M scheduling

ServiceNow

Coordination (onshore/offshore)

BI delivery strategy

Education

Bachelors in Information Systems, Computer Science or Information Technology

Tools

Informatica

Snowflake

Power BI

Tableau

Jenkins

Stash

Control-M

ServiceNow

AWS EC2

Job description

India

Trending

Job Description

The Skills that will make you successful in this role

• Understand requirement, source to target mapping and Data model and create mappings.


• Ensuring associated applications adhere to architecture standards, risk management and security guidelines and data management policies


• Strong working knowledge in ETL – Informatica.


• Good exposure to writing SQL, Snowflake queries


• Working knowledge in Unix


• Good Understanding of Data Warehousing concepts, Dimension modelling.


• Good knowledge in agile methodologies.


• Good knowledge of Scripting (Python scripting, Shell or PowerShell)


• AWS Cloud knowledge and infrastructure management (EC2))


• Experience with scheduling tools like Control-M.


• Experience in working with ServiceNow and ability to manage changes and its processes.


• Coordination with onshore & offshore application teams, Operations and business teams.


• Work with onsite teams to acquire a solid understanding of core deliverables, current state of technology and the strategic direction guiding future effort.


• Participate in the definition of both functional and non-functional requirements of a system and define the BI delivery strategy.

The Skills that are good to have for this role

• UI Engineering with Angular Technology exposure is a plus


• Exposure to Power BI and Tableau is an added advantage


• Experience in using Jenkins / Stash


• Effective communication and excellent story-telling from data abilities


• Have the ability to discover new opportunities where analytical techniques can be leveraged for solving business problems.

The Expertise We’re Looking For

• Bachelors in Information Systems, Computer Science or Information Technology.