Senior Data Engineer
Senior Data Engineer
Contract
Princeton NJ (Onsite)
We are looking for a Senior Data Engineer to expedite our Data Platform Stack to support our developers database architects data analysts on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects in a dynamic environment.
Responsibilities
Analyze and interpret complex data sets. Ability to identify data anomalies and resolve data issues
Understand specific business processes and domain concepts and relate them to data subject domains
Collaborate with Data Leads Data Analysts and QA analysts to validate requirements participate in user requirement sessions
Perform tests and validate data flows and prepare ETL processes according to business requirements
Perform ETL tuning and SQL tuning
Ability to document data flows representing business logic in ETL routines
Design and implement data conversion strategy from legacy to new platforms
Perform design validation reconciliation and error handling in data load processes
Design and prepare technical specifications and guidelines including ER diagrams and related documents Qualifications
Must be well versed with Data warehousing concepts including design patterns (Star schemas Snowflake design schemas). Must be aware of data modeling concepts including the data modeling Normal forms
Knowledge of AWS Infrastructure including S3 SNS Ec2 CloudWatch and RDS
8-9 years working in ETL/Data transformation projects with one or more related products such as Informatica or Talend or Microsoft SSIS
8 years working in business intelligence data warehousing initiatives
Advanced working SQL knowledge and experience working with relational databases query authoring (SQL) as well as working familiarity with a variety of databases like Oracle or Ms Sql Server or Vertica.
Good to have at least 1 years working with Matillion ELT tool and Snowflake Database
Good to have experience in building AWS Data Pipelines using Python or Spark SparkSQL in any of Cloud Environments (AWS / Azure / Google).
Good to have - Experience with any of the NoSQL datastores such as ElasticSearch MongoDB DynamoDB Cassandra
Education
Bachelors in mathematics Computer Science or related technical field. Post graduate degree preferred. Minimum 7 years of relevant experience.
Recommended Jobs
Customer Service Representative
**Overview** This position will be responsible for supporting our Parts Department's efforts by acting as the voice of the customer and act as a liaison between the Hussmann parts team and factory to …
Social WorkerGCM
An MSW currently licensed (if applicable)and registered in the state of practice who provides medical social services within the scope of MSW practice standards in collaboration with primary care phy…
PT Seasonal Sales Associate
High-quality fresh chocolate - that's what the Swiss chocolate manufacturer Läderach stands for. Founded in 1962, the family business now employs over 2500 people from more than 80 countries across t…
Assistant Professor, Continuing Track, Physical Therapy
Department of Physical Therapy Continuing-track Faculty Position The Department of Physical Therapy in the College of Health Sciences at the University of Delaware invites applications for a …
Plastics Engineer - Entrepreneurial Opportunity
Job Title: Engineer - Plastics, Electrical, or Mechanical - Unique Entrepreneurial Opportunity Location: Ewing, N.J Company: LMT Mercer Group About Us: At LMT, we are pioneers in state-of-th…
Drive with WARP | Owner Operators
Job Description Take your business to the next level with WARP! Whether you drive a Box Truck, Cargo Van, or 53' Trailer, we connect you with consistent, high-quality loads on our load board. From f…
Nurse (LPN) Days Trach and Vent
FALL in Love with Your Next Client at BAYADA ~15 year-old with Trach and vent in Camden for school and home hours ~16 months old with Trach and Vent in Camden for home hours ~64 year-old wi…
Assistant Director of Patient Care, Medical Unit-III
Job Title: Asst Director Patient Care Location: Main Hospital - New Brunswick Department Name: Medical Unit-III Req #: 0000207992 Status: Salaried Shift: Night Pay Range: $47.85 - $6…
Associate Data Scientist
Infosys Limited is seeking an AI Engineer. In this role you will enable digital transformation for our clients in a global delivery model research on technologies independently recommend appropriate…
Automotive BDC Representative
At Autoland Toyota, we are committed to an environment where the customer is always treated with respect and dignity. Our associates are our most valuable resource and growth is encouraged through dil…