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
Similar Jobs
Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Operate and secure SailPoint's cloud SaaS infrastructure: implement FIM, harden base images, automate audit evidence collection, secure container images, integrate SIEM/IDS/IPS/WAF, support 24x7 production, participate in on-call rotation, and collaborate with engineering and security teams to meet compliance standards.
Top Skills:
AWSAzureChefContainersFile Integrity Monitoring (Fim)IdsIpsJenkinsPuppetPythonRubySIEMSirpTerraformWaf
Fintech • Legal Tech • Software • Financial Services • Cybersecurity • Data Privacy
Provide onsite and remote IT support to internal and external users, handle high-volume service desk tickets, troubleshoot Microsoft OS/Office/Exchange/AD and network/infra issues, track KPIs and SLAs, participate in on-call rotational shifts, produce documentation, and ensure compliance with ITIL and security policies.
Top Skills:
Active DirectoryInfrastructureItilMessagingMicrosoft ExchangeMS OfficeWindowsNetworking
Big Data • Cloud • Software • Database
Manage full-cycle recruiting for People and Finance roles across business units. Source candidates via advanced techniques and tools, partner with hiring managers, maintain ATS data accuracy, and deliver a high-touch candidate experience from outreach through offer execution.
Top Skills:
AtsBoolean SearchCRMGemGreenhouseLinkedin Recruiter
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
