Data Engineer
Data Engineer
Posted on :
31-08-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Posted on :
31-08-2024
Job Description
Position : 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.
- Handson 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/INSERTPUTGET commands for loading data into Snowflake tables from internalexternal 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
Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race religion color sex age national origin or disability. All applicants will be evaluated solely on the basis of their ability competence and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at .
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
