Sunday, October 25, 2020

 Data Integrator

100% Remote position

6 Months

Mandatory Skills: Matillion and SQL

Detailed JD

*          7 years of rich experience in AWS cloud data and analytics space with solid understanding of Data warehousing product RedShift, ETL product Matillion and SQL and 3+years with other ETL/Data integration tools and other Databases will be preferred.  Uses knowledge and experience to improve Application related performance. Proficient in oral and written communications skills

*          5+ years of experience in implementing cloud-based data lake/data warehouse technologies. Must have experience working with high-volume data and building batch and near real-time ETL processes using AWS services such as Redshift, Matillion.

*          Experience with Matillion ELT/ETL

*          Experience with AWS Redshift and Redshift Spectrum, AWS EMR, PySpark, Glue and Matillion

*          Redshift Data warehouse experience

*          Lead data migration and integration efforts

*          Craft processes to ensure clean data

*          Prior experience with ETL tools like SSIS/Informatica and Databases like Teradata, SQL server will be preferred.

*          Experience working with RDBMS’s, Sql Server, Redshift, Snowflake, BigQuery, Teradata or Azure SQL -Data WarehouseExperience using Powershell and Python.

*          Prepare data for job runs. Support existing jobs. Solve, analyze and repair production issues.

*          Experience with S3 Object store and other Big Data storage platforms

*          Deep understanding of data mapping, data validation, data manipulation, data analysis use cases and Provide observations of the system and suggest automated steps to full-fill the business operations and the requirements.

*          2+ years of experience with visualization tools (Power BI, Tableau or others) is an added advantage.

*          AWS Certified Big Data Specialty certification is a plus.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Solution Architect/ Lead Consultant

  Toronto, ON Fixed Term Contract  Required skills :  • BA/BS degree in a technology related discipline such as Engineering, Computer Scienc...