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
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Senior Salesforce Engineer responsible for designing and building Salesforce solutions: develop Apex, triggers, Lightning Web Components, Aura, and Visualforce; build and modernize integrations and platform experiences; lead Quote-to-Cash implementations; troubleshoot production (L3) issues; follow CI/CD and deployment best practices; participate in Agile ceremonies; monitor org performance and advocate Salesforce best practices.
Top Skills:
AgentforceAgenticApexAuraCopadoData CloudLightning Web ComponentsLwcQuote-To-CashSalesforceSlackVisualforce
Cloud • Information Technology • Productivity • Software • Automation
Provide technical support to customers via meetings, chat, and email; troubleshoot product, configuration, networking and cloud issues; empathize and analyze reported problems; use technical knowledge to resolve or escalate; collaborate with Product and Engineering; participate in on-call rotations and specified shift hours.
Top Skills:
APIsAWSBoomiGoogle Cloud PlatformGroovyHadoopJavaJavaScriptLinuxAzureNetSuiteOauth 2.0PostmanReactSalesforceWindows
Cloud • Information Technology • Productivity • Software • Automation
As a Product Support Engineer, you'll troubleshoot customer issues, develop solutions, and work with various technologies to ensure operational success while providing global support during remote and future in-office hours.
Top Skills:
Boomi AtomsphereCharles ProxyEltETLGroovyHadoopHttp/SJavaJavaScriptKubernetesLinuxNetSuiteOauth 2.0PostmanRancher DesktopReactRestSalesforceSftpSoapSsl/TlsTcp/IpWindowsWiresharkWsdl
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
