Data Engineers with Matillion ELT tool is a must

Matillion ELT tool, SQl, S3, SNS, Ec2, CloudWatch, Informatica, AWS, python, Python/Scala, Apache Spark, SparkSQL, S3 Data Lake, Snowflake, Redshift
Contract W2, Contract Independent, Contract Corp-To-Corp
Depends on Experience
Work from home available

Job Description

Hiring Senior Data Engineer based in Boston, MA. Please note that to start the role it will be remote for 3 - 6 months but once this Covid19 is behind us - it will be an in-house role.

Responsibilities:

  • Analyze and interpret complex data and provide resolutions to data issues.
  • Coordinate with data analyst to validate requirements, perform interviews with users and developers.
  • Perform tests and validate data flows and prepare ETL processes according to business requirements.
  • Perform ETL tuning and SQL tuning.
  • Perform data modeling and schema design, including dimensional and big data modeling.
  • Designing and implement a 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

  • Knowledge of AWS Infrastructure including S3, SNS, Ec2, CloudWatch and RDS.
  • Min 1+ years of experience on Matillion ELT tool and Snowflake Database.
  • Min 5+ years of experience with ETL/Data Transformation and one or more related products such as Informatica and SSIS.
  • Min 4+ years’ work experience in business intelligence, data warehousing, and logical/physical model design required.
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • Experience in building AWS Data Pipelines using Python/Scala, Apache Spark, SparkSQL, S3 Data Lake, Snowflake, Redshift.
  • Good to have - Experience with any of the NoSQL datastores such as ElasticSearch, MongoDB, DynamoDB, Cassandra.
Dice Id : 91017926
Position Id : 7155254
Originally Posted : 2 months ago
Have a Job? Post it

Similar Positions

Hadoop Developer
  • KSN Technologies, Inc.
  • Boston, MA, USA
Cloud Engineer
  • Digipulse Technologies, Inc
  • Boston, MA, USA
AWS Spark ETL Developer
  • The Tri-Com Consulting Group
  • Bloomfield, CT, USA
Technical Architect/ Developer
  • iTech Solutions
  • Bloomfield, CT, USA
Talend Architect
  • Talent Group
  • Hartford, CT, USA
Big Data Engineer
  • Srinav Inc.
  • Bloomfield, CT, USA
Spark Scala Developer/Data Engineer
  • VLink Inc
  • Bloomfield, CT, USA
Hive/Spark Developer (100% Remote)
  • ITECS
  • Melville, NY, USA
Cloud Data Engineer
  • NTT DATA Services
  • Woodcliff Lake, NJ, USA
Sr Data Engineer with AWS
  • With LLC
  • Tarrytown, NY, USA