Data Engineer W/ Matillion - Myrtle Point, United States - Zensar Technologies

Description

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
Design and implement efficient data ingestion strategies for each platform: Google, Facebook, [X], LinkedIn, and potentially Reddit

Data Cleaning and Quality Maintenance:

• Utilize Python scripting capabilities within Matillion to perform advanced data cleaning and quality checks

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

Zensar believes that diversity of backgrounds, thought, experience, and expertise fosters the robust exchange of ideas that enables the highest quality collaboration and work product.

Responsibilities

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
Ensure timely and accurate data retrieval, handling various API limits and quotas efficiently
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

Our employees enjoy flexible work arrangements and a competitive benefits package, including medical, dental, vision, 401(k), among other benefits
Qualifications

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
Design and implement efficient data ingestion strategies for each platform: Google, Facebook, [X], LinkedIn, and potentially Reddit

Data Cleaning and Quality Maintenance:

• Utilize Python scripting capabilities within Matillion to perform advanced data cleaning and quality checks

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

Zensar believes that diversity of backgrounds, thought, experience, and expertise fosters the robust exchange of ideas that enables the highest quality collaboration and work product.

Responsibilities

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
Ensure timely and accurate data retrieval, handling various API limits and quotas efficiently
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

Benefits

Our employees enjoy flexible work arrangements and a competitive benefits package, including medical, dental, vision, 401(k), among other benefits
Why Zensar?

We re a bunch of hardworking, fun-loving, people-oriented technology enthusiasts.

We love what we do, and we re passionate about helping our clients thrive in an increasingly complex digital world.

Zensar is an organization focused on building relationships, with our clients and with each other and happiness is at the core of everything we do.

In fact, we re so into happiness that we... ve created a Global Happiness Council, and we send out a Happiness Survey to our employees each year.

We ve learned that employee happiness requires more than a competitive paycheck, and our employee value proposition grow, own, achieve, learn (GOAL) lays out the core opportunities we seek to foster for every employee.

Teamwork and collaboration are critical to Zensar s mission and success, and our teams work on a diverse and challenging mix of technologies across a broad industry spectrum.

These industries include banking and financial services, high-tech and manufacturing, healthcare, insurance, retail, and consumer services. Our employees enjoy flexible work arrangements and a competitive benefits package, including medical, dental, vision, 401(k), among other benefits. If you are looking for a place to have an immediate impact, to grow and contribute, where we work hard, play hard, and support each other, consider joining team Zensar

Zensar Technologies is seeking a Data Engineer (Matillion specialist with Tableau) remote in the US. We are accepting contractor or fulltime employees for this role.

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.

Zensar believes that diversity of backgrounds, thought, experience, and expertise fosters the robust exchange of ideas that enables the highest quality collaboration and work product.

Zensar is an equal opportunity employer.

All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law.

Zensar is committed to providing veteran employment opportunities to our service men and women.

Zensar is committed to providing equal employment opportunities for persons with disabilities or religious observances, including reasonable accommodation when needed.

Accommodations made to facilitate the recruiting process are not a guarantee of future or continued accommodations once hired.

Zensar does not facilitate/sponsor any work authorization for this position. All candidates must present valid authorization to commence new employment in the U.S. for Zensar.

Candidates who are currently employed by a client or vendor of Zensar may be ineligible for consideration.

Zensar values your privacy.

We'll use your data in accordance with our privacy statement located at:

Data Engineer W/ Matillion &Tableau specialist

Company information
Zensar is a leading experience, engineering, and technology solutions company.

We conceptualize, build, and manage digital products for Forbes Global 2000 clients across the hi-tech engineering, banking and financial services, insurance, manufacturing and consumer services verticals.

With proven excellence across five core areas, including experience services, advanced engineering services, data engineering and analytics, foundation services, and application services, our solutions leverage industry-leading platforms to help our clients be competitive, agile, and disruptive while moving with velocity through change and opportunity.

Zensar's expansive ecosystem of 60+ technology partners, including Oracle, Salesforce, SAP, Guidewire, Automation Anywhere, Adobe, and UiPath, enables us to deliver comprehensive solutions to clients, facilitating seamless integration and allowing them to leverage cutting-edge technologies and tools for enhanced business outcomes.

Zensar is part of the USD 4.4 billion RPG Group.

With headquarters in Pune, India, our 10,500+ employees, representing over 50 nationalities, work from 30+ locations across North America, UK/Europe, and South Africa.

Visit us at
Information Technology, Consulting, Software Development, Computer Software, Information Technology & Services, Information Technology Services, Outsourcing/Offshoring, Outsourcing, Digital Services
Public Company
Pune, Maharashtra

Company Specialties:
IT, BPO, Enterprise Content Management, Business Process Management, Outsourcing, Impact Sourcing, ITES, Retail, Banking & Finance, Manufacturing, and Utilities

#J-18808-Ljbffr