Lead migration from on-premises Oracle to Snowflake. Design, optimize, and maintain complex SQL queries, build Python data pipelines, and use AWS services (Lambda, SNS, SQS, S3). Ensure data integrity, performance, and scalable cloud data solutions while collaborating across teams.
Job Title: AWS Cloud Data Engineer
Location: Bangalore
Job Description:
Fidelity Investments is undertaking an exciting transition from on-premises Oracle Analytical platform to a cloud-based Snowflake Analytical platform. As an AWS Cloud Data Engineer at Fidelity, you will play a pivotal role in migrating and managing our analytical platform on the cloud. The ideal candidate will have a strong foundation in SQL, experience with Snowflake, and proficiency in Python scripting. Additionally, hands-on experience with various AWS services is essential. Your work will directly contribute to the efficiency, scalability, and reliability of our data solutions.
Key Responsibilities:
- SQL Expertise (50%): Write, optimize, and maintain complex SQL queries. Ensure data integrity and performance through best practices.
- Snowflake Experience (30%): Work on Snowflake-based projects. Migrate data from on-premises Oracle to Snowflake. Snowpro certification is a plus.
- Python Scripting (10%): Develop and maintain data pipelines using Python. Automate data processing tasks and integrate with other systems.
- AWS Services (10%): Utilize AWS services such as Lambda, SNS, SQS, and S3. Implement best practices for cloud infrastructure and data management.
Good to Have:
- Snaplogic: Experience with Snaplogic for ETL processes.
- Control M: Experience with Control M for orchestration and job scheduling.
- AWS Certification: Relevant AWS certifications will be an added advantage.
Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- Proven experience in SQL and data engineering.
- Hands-on experience with Snowflake, including at least one or two Snowflake projects.
- Proficiency in Python scripting for data pipeline creation.
- Practical experience with AWS services such as Lambda, SNS, SQS, and S3.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
Preferred Certifications:
- Snowpro Certification
Photon Bengaluru, Karnataka, IND Office
Bengaluru, India
Similar Jobs
Financial Services
Review, verify, and report client data to ensure accuracy and AML/regulatory compliance. Prepare Currency Transaction Reports and compliance documentation, respond to operational requests, escalate issues, and support process improvements. Use digital tools to manage data, resolve service issues, and contribute to operational excellence.
Top Skills:
MainframeMS OfficePc-Based Systems
Cloud • Security • Software • Cybersecurity • Automation
Provide hands-on technical consultancy to APJ customers to drive GitLab adoption, unblock implementations, lead workshops/demos, and align technical recommendations with account goals. Manage multiple engagements, produce enablement content, mentor peers and customers, and stay current on DevSecOps tooling and GitLab capabilities to support renewals and expansion.
Top Skills:
Agile PlanningCi/CdDevsecopsGitlabSource Code ManagementZoom
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Lead data engineering architecture and execution for large-scale, low-latency analytics. Own technical direction, ensure operational data quality, design streaming and batch pipelines, mentor engineers, coordinate cross-functional teams, and deliver scalable solutions using Spark, Airflow, and AWS or equivalent data platforms.
Top Skills:
AirflowAthenaColumn StoresDatabricksDatabricks ApisEmrFlinkHiveKafkaKappa ArchitectureLambda ArchitectureMaster Data Management (Mdm)Microservices ArchitectureRedshiftSparkSQLStreaming Pipelines
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
