Snowflake Engineer (Datastage, SSIS, DB2, ETL) R
Share
Job Location:
Edison, NJ - USA
Monthly Salary:
Not Disclosed
Posted on:
2 days ago
Vacancies:
1 Vacancy
Job Summary
About Brillio:
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital renowned for its world-class professionals referred to as Brillians distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary groundbreaking technologies and exclusive digital projects. Brillios relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work certification year after year.
Lead Data Engineer
Primary Skills
- DataStream ETL Fundamentals SQL SQL (Basic Advanced) Python Data Warehousing Time Travel and Fail Safe Snowpipe SnowSQL Modern Data Platform Fundamentals PLSQL T-SQL Stored Procedures
Specialization
- Snowflake Engineering: Data Engineer
Job requirements
Snowflake Developer (Senior / Lead Data Engineer)
REQUIREMENTS:
- Minimum 812 years of experience in data engineering ETL/ELT development and data platform implementations
- Strong hands-on experience with legacy ETL tools:
- Informatica / DataStage / SSIS
- Proven experience working with:
- Oracle / SQL Server and migrating to Snowflake
- 35 years of hands-on Snowflake experience (development optimization data loading)
- Strong competency in modern data stack:
- ELT frameworks (dbt preferred)
- Data warehouse / Lakehouse architectures
- Advanced expertise in SQL (complex queries performance tuning optimization)
- Hands-on experience with:
- Snowflake stored procedures UDFs Streams Tasks Snowpipe
- Proficiency in Python for data processing automation and API integrations
- Experience integrating Snowflake with:
- External systems via APIs / scripting
- Familiarity with cloud platforms (AWS preferred):
- S3 Lambda and related services
- Experience with workflow orchestration tools (e.g. Airflow)
- Strong understanding of data validation reconciliation and data quality frameworks
- Experience working in enterprise-scale migration or transformation programs
- Ability to communicate effectively with both technical and non-technical stakeholders
ADDED BONUS FOR:
- Experience with real-time / streaming ingestion frameworks
- Familiarity with CI/CD and DataOps practices
- Exposure to BI and visualization tools (Tableau Power BI etc.)
- Understanding of data modeling techniques (Star schema Data Vault)
- Experience with performance tuning and cost optimization in Snowflake
- Multi-cloud exposure (AWS / Azure / GCP)
- Relevant certifications:
- Snowflake SnowPro
- Cloud certifications (AWS/Azure)
$130000 - $140000 a year
Know what its like to work and grow at Brillio: Click here
We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.
Required Experience:
IC
Key Skills
About Company
Brillio is a global leader in Enterprise Digital Transformation Solutions, providing strategic consulting services and solutions using emerging technologies.
