NAM Info Inc · 2 days ago
Data Engineer ( Snowflake & AWS )
Cranbury, NJ
Full-time
Onsite
Senior Level, Lead/Staff
8+ years expNAM Info Inc is seeking a Data Engineer with expertise in Snowflake and AWS. The role involves designing and developing data architectures and automated ETL/ELT workflows to manage and deliver reliable data for analytical and operational workloads.
CommunitiesInformation and Communications Technology (ICT)Information Technology
Hiring Manager
Jawaharlal Nehru G
Responsibilities
Design, build, and maintain end-to-end ETL/ELT data pipelines to extract, transform, and load data from structured and unstructured sources into Snowflake and AWS-based data lakes
Leverage ETL tools such as AWS Glue, dbt, Informatica, Talend, Matillion, or Apache NiFi to orchestrate data ingestion and transformation at scale
Develop parameterized, reusable, and modular ETL components that can handle large volumes and complex transformations efficiently
Implement incremental data loads, CDC (Change Data Capture), and real-time streaming integrations using Kafka, Kinesis, or Debezium
Integrate data from multiple systems (ERP, CRM, APIs, flat files, relational DBs, and cloud services) into centralized data stores
Apply data cleansing, deduplication, enrichment, and validation logic to ensure accuracy and consistency across data domains
Design and implement data lakehouse and warehouse architectures using AWS S3, Glue, and Snowflake
Perform conceptual, logical, and physical data modeling to support analytics, BI, and machine learning use cases
Develop dimensional models (Star, Snowflake) and Data Vault architectures for analytical workloads
Optimize Snowflake performance through partitioning, clustering, materialized views, and query tuning
Manage and document metadata, data lineage, and schema evolution to ensure traceability and governance
Automate data workflows using Apache Airflow, AWS Step Functions, or Glue Workflows for scheduling and dependency management
Implement CI/CD pipelines for ETL code deployment, testing, and version control using Git, Jenkins, or CodePipeline
Set up data quality validation frameworks and automated reconciliation checks across source and target systems
Monitor pipeline performance, data freshness, and SLA adherence using tools such as CloudWatch, Datadog, or Prometheus
Establish and maintain data quality rules, profiling, and monitoring mechanisms
Implement data governance and access controls aligned with enterprise security standards (IAM, encryption, masking, auditing)
Collaborate with governance and compliance teams to ensure adherence to GDPR, SOC 2, or similar frameworks
Work closely with data architects, analysts, and scientists to understand data requirements and deliver high-quality datasets
Support the development of data marts, semantic layers, and domain-oriented data products
Continuously explore and adopt emerging data integration frameworks, streaming architectures, and data observability tools
Qualification
Required
Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related field
8–10 years of hands-on experience in data engineering and ETL/ELT development within cloud environments
Strong proficiency in Snowflake (schema design, query optimization, performance tuning, and cost management)
Deep expertise in ETL/ELT tools: AWS Glue, dbt, Informatica, Talend, Matillion, Apache NiFi, or Azure Data Factory
Experience with AWS data stack: S3, Redshift, Lambda, Glue, Step Functions, Kinesis, and IAM
Advanced SQL skills and experience in Python, Scala, or Java for data transformation and automation
Solid understanding of data modeling techniques (3NF, Star Schema, Snowflake Schema, Data Vault 2.0)
Familiarity with data orchestration, workflow automation, and CI/CD in data environments
Experience implementing data validation, profiling, and quality monitoring frameworks
Understanding of data governance, metadata management, and security practices
Preferred
Exposure to real-time streaming
CDC pipelines
API-based data ingestion
machine learning data prep
Company
NAM Info Inc
NAM Info Inc.
51-200 employees
H1B Sponsorship
NAM Info Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (19)
2024 (26)
2023 (22)
2022 (46)
2021 (33)
2020 (29)
Funding
Current Stage
Growth StageLeadership Team
Shyam Valloornatt
Chief Operating Officer
Recent News
2025-01-31
Company data provided by crunchbase