Senior Software Engineer - SQL, Snowflake, Python

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:

• Bachelors 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