Kellton - Senior Data Engineer - SQL/Snowflake DB (8-10 yrs)

Senior Data Engineer

Job Location : - Hyderabad (Work from Office)

Experience Level : Mid-Senior (8+ Years)

About Kellton :

We are a global IT services and digital product design and development company with subsidiaries that serve startup, mid-market, and enterprise clients across diverse industries, including Finance, Healthcare, Manufacturing, Retail, Government, and Nonprofits.

At Kellton, we believe that our people are our greatest asset.

We are committed to fostering a culture of collaboration, innovation, and continuous learning.

Our core values include integrity, customer focus, teamwork, and excellence.

Are you craving a dynamic and autonomous work environment? If so, this opportunity may be just what you're looking for.

At our company, we value your critical thinking skills and encourage your input and creative ideas to supply the best talent available.

To boost your productivity, we provide a comprehensive suite of IT tools and practices backed by an experienced team to work with.

What you will do :

- Provide Expertise and Guidance as a Senior Experienced Engineer in solution design and strategy for Data Lake and analytics-oriented Data Operations.

- Design, develop, and implement end-to-end data solutions (storage, integration, processing, access) in hypervendor platforms like AWS and Azure.

- Architect and implement Integration, ETL, and data movement solutions using AWS Glue, MSK and/or Confluent, and other COTS technologies.

- Prepare documentation and designs for data solutions and applications.

- Design and implement distributed analytics platforms for analyst teams.

- Design and implement streaming solutions using Amazon Kinesis, Kafka, Talend, and Confluent.

- Migrate data from traditional relational database systems to AWS relational databases such as Amazon RDS, Aurora, Redshift, DynamoDB, Cloudera, Snowflake, Databricks, etc.

- Implement ad-hoc analysis solutions using Athena, and other SQL and No-SQL Tools like Alteryx.

- Propose architectures that consider cost/spend in AWS and develop recommendations or plans to right-size AWS data infrastructure.

Who you are :

- Bachelor's degree in Computer Science, Software Engineering.

- 8+ Years of experience in the Data domain as an Engineer and Architect.

- A solid understanding of AWS and Azure storage solutions such as S3, EFS, and EBS.

- A solid understanding of AWS and Azure compute solutions such as EC2.

- Experience implementing solutions on AWS and Azure relational databases such as MSSQL, SSIS, Amazon Redshift, RDS, and Aurora.

- Experience implementing solutions leveraging ElastiCache and DynamoDB.

- Experience designing and implementing Enterprise Data Warehouse, Data Marts/Lakes.

- Experience with Star or Snowflake Schema.

- Experience with R and Python and other emerging technologies in D&A.

- Understanding of Slowly Changing Dimensions and Data Vault Model.

- AWS and Azure Certifications are preferred.

What we offer you :

- Existing clients in multiple domains to work.

- Strong and efficient team committed to quality output.

- Enhance your knowledge and gain industry domain expertise by working in varied roles.

- A team of experienced, fun, and collaborative colleagues

- Hybrid work arrangement for flexibility and work-life balance (If the client/project allows)

- Competitive base salary and job satisfaction.