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 • HR Tech • Information Technology • Productivity • Software • Automation
Manage US sales and use tax compliance across jurisdictions, including preparing and filing returns, tax data extraction and reconciliations, month-end accruals and GL reconciliations, supporting state and local tax audits, improving tax processes and automation, and partnering with Tax, Accounting, IT, and business teams on tax treatment and reporting.
Top Skills:
AlteryxAvalaraClaudeExcelOnesourceOraclePower BISAPVertex
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The role involves managing finance change, regulatory reporting, project management, and software testing, requiring extensive experience in financial services and team leadership.
Top Skills:
Automation Testing ToolsExcelSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Manage projects in the transaction banking sector with an emphasis on compliance and retail payments, using Agile methodologies and strong stakeholder management.
Top Skills:
ConfluenceIso20022JIRA
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
