| Urgent Requirement for Matillion ETL Data Engineer :: Remote USA at Remote, Remote, USA |
| Email: [email protected] |
| From: Bharadwaj, Fisec Global Inc [email protected] Reply to: [email protected] Hi Everyone, We have an urgent position for below requirement, if you are available and interested, please do reply me with your updated resume to [email protected] Role: Matillion ETL Data Engineer Location: Remote USA Duration: Long Term Contract Job Description: Must have 5 years of experience on Matillion ETL and Tableau (dashboards) What you will be doing: This resource should be proficient of using Matillion tool for extracting, transforming, and loading (ETL) data from various API connectors, focusing on the big 4 social media and advertising platforms Google, Facebook, X, LinkedIn, and potentially Reddit. Maintain data quality through orchestrations, as well as perform advanced data transformations within the data lake. Must Have: A senior resource who understands Data, Experience in ETL tool (Preferably Matillion). Must have very good experience in Tableau (building dashboards with Tableau). Documentation and Knowledge Sharing: - Develop comprehensive documentation for all developed ETL processes and data pipelines. - Share knowledge with internal teams regarding best practices, lessons learned, and technical insights. Collaboration and Support: - Work closely with other data team members, including data analysts, data scientists, and BI developers. - Provide ongoing support and optimization for the ETL processes. Advanced Data Ingestion and Management: - Leverage Matillion to create robust ETL pipelines, utilizing orchestration connector components and the generic API tool. - Design and implement efficient data ingestion strategies for each platform: Google, Facebook, [X], LinkedIn, and potentially Reddit. - Ensure timely and accurate data retrieval, handling various API limits and quotas efficiently. Data Cleaning and Quality Maintenance: - Utilize Python scripting capabilities within Matillion to perform advanced data cleaning and quality checks. - Implement deduplication algorithms and maintain data integrity during the ETL process. - Develop reusable components to validate, cleanse, and enhance data. Data Transformation and Utilization: - Blend and transform raw data into actionable insights, ensuring it is analytics-ready. - Utilize SQL expertise for performing advanced transformations including joins, aggregations, and window functions. - Collaborate with data analysts and stakeholders to understand and implement business logic in transformations. Data Security and Compliance: - Implement secure ETL processes to ensure that sensitive data is protected. - Ensure that the data management practices follow GDPR, CCPA, or other relevant data protection regulations. Keywords: business intelligence information technology |
| [email protected] View all |
| Mon Jan 29 21:45:00 UTC 2024 |