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