25 Oct
Data Engineers with Matillion ELT tool is a must
Massachusetts, Boston , 02108 Boston USA

Vacancy expired!

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.

Vacancy expired!


Related jobs

Report job