Sr. Software Engineer TECHM-JOB-31284

Keylent, Inc.

• $100K — $130K *
Dallas, TX 75217In-Person
Telecommunications & Hardware
8 - 10 years of experience
Reposted Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • 8-9 years of experience in data warehousing (DWH)
  • Strong hands-on SQL skills and experience with stored procedures
  • Proficient in data ingestion from various sources
  • Familiarity with cloud databases, particularly Snowflake or Redshift
  • Experience with AWS services like S3 and EC2
  • Strong understanding of slowly changing dimensions (SCD) techniques
  • Good to have knowledge of Python and Kafka

Responsibilities

  • Work independently on complex data warehousing projects
  • Design and implement data ingestion and transformation processes
  • Optimize performance of Snowflake data warehouse using advanced tools
  • Manage and handle large datasets including JSON and CSV
  • Develop and execute ETL scripts to support data processes
  • Utilize SnowSQL and SNOWPIPE for continuous data ingestion
  • Conduct performance tuning and scaling of virtual data warehouses

Benefits

  • Day 1 onsite work environment
  • Exposure to leading cloud technologies
  • Opportunity to work in the telecom domain
  • Engagement in a data-driven culture
  • Potential for skill enhancement in cloud architecture
Full Job Description
Sr. Software Engineer TECHM-JOB-31284
Position :- Snowflake Data Engineer
Location :-Dallas TX (day 1 Onsite)
Job Details
Telecom domain is preferred
  • Resource with around 8 to 9 years of experience in DWH area who can work independently
  • Strong hands on SQL skills/ Stored procedures / writing complex queries
  • Good knowledge of Data warehousing and all related concepts
  • Hands on experience in Data Ingestion from different sources
  • Exposure to any of the cloud DB (Snowflake/ Redshift)
  • Implementing SCD Techniques like slowly changing dimensions (type1, type2 and type3).
  • Experience in working with AWS S3 and Snowflake cloud data warehouse.
  • Good exposure in Snowflake Cloud Architecture and SnowSQL and SNOWPIPE for continuous data ingestion.
  • Handling large and complex data sets like JSON, ORC, PARQUET, CSV files from various sources like AWS S3.
  • Hands-on experience in bulk loading and unloading data into Snowflake tables.
  • Experience in writing complex SQL scripts using Statistical Aggregate functions and Analytical functions to support ETL in snowflake cloud data warehouse.
  • Used COPY/INSERT,PUT,GET commands for loading data into Snowflake tables from internal,external stages.
  • Experience with performance tuning of SnowFlake data warehouse with Query Profiler, Caching and Virtual data warehouse scaling
  • Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
  • Hands on exp loading to snowflake.
  • Knowledge on redshift (Good to have)
  • Knowledge on AWS EC2, lambda
  • Strong Datawarehouse exp
  • Good to have python
  • Should strong on SQL quries
  • Kafka not must. Good to have
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Keylent, Inc.

  • Cloud Architect
    $120K — $150K *
    Atlanta, GA 30349 (Fulton County)
    Reposted Today
    Information Technology
    In-Person
  • Tech Lead TECHM-JOB-28373
    $120K — $150K *
    Atlanta, GA 30349 (Fulton County)
    Reposted Today
    Information Technology
    In-Person
  • Group Benefits SME
    $90K — $120K *
    Springfield, MA 01109 (Hampden County)
    Reposted Today
    Finance & Insurance
    In-Person
  • Software Engineer -Systems
    $90K — $120K *
    Delaware City, DE 19706 (New Castle County)
    Reposted Today
    Information Technology
    In-Person
  • Solution Architect
    $120K — $150K *
    San Jose, CA 95123 (Santa Clara County)
    Reposted Today
    Information Technology
    In-Person

More Telecommunications & Hardware Jobs

Find similar Sr. Software Engineer TECHM-JOB-31284 jobs:

NationwideDallas, TX