Senior Software Engineer - SQL, Snowflake, Python - Bangalore

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