ETL Developer with Matillion Tool

7 days ago


Seattle, Washington, United States PETADATA Full time

Job Title: ETL Developer with Matillion Tool

Job Summary:

PETADATA is seeking an experienced ETL Developer with expertise in Matillion Tool to join our team. As an ETL Developer, you will be responsible for designing, developing, and implementing scalable data processing solutions using Apache Spark. You will collaborate with cross-functional teams to understand data requirements and design robust data architecture solutions.

Key Responsibilities:

  • Design and develop efficient data processing solutions using Apache Spark
  • Collaborate with cross-functional teams to understand data requirements and design robust data architecture solutions
  • Implement ETL processes to extract, transform, and load data from various sources to ensure data quality, integrity, and consistency throughout the ETL pipeline
  • Optimize code for performance and scalability, keeping up-to-date with the latest industry best practices
  • Ensure data quality, integrity, and consistency throughout the ETL pipeline
  • Integrate data from different systems and sources to provide a unified view for analytical purposes
  • Collaborate with data analysts to implement solutions that meet their data integration needs
  • Design and implement streaming workflows using PySpark Streaming or other relevant technologies
  • Build strings of configured components inside a job and then run that job to accomplish a desired task such as loading or transforming data using Matillion ETL tool
  • Develop batch processing workflows for large-scale data processing and analysis
  • Analyze business requirements to determine the volume of data extracted from different sources, data models, to ensure the quality of the data involved
  • Identify the data storage needs to determine the amount of data to deal with the company's requirement
  • Ensure the data quality that everything is in place at the transformation stage to eliminate errors and fix unstructured and unorganized data extracted
  • Ensure that the data is loaded into the warehouse system and meets the business needs and standards
  • Responsible for data flow validation, creating and building a secured database warehouse that meets a given company's needs and standards
  • Responsible for determining the storage needs of a business and the volume of data involved

Requirements:

  • Expertise in Matillion ETL, Python, PySpark, ETL processes, CI/CD (Jenkins or GitHub)
  • Expertise in Python and PySpark to develop efficient data processing and analysis scripts
  • Optimize code for performance and scalability, keeping up-to-date with the latest industry best practices
  • Proficient in valuable technical skills such as SQL, JAVA, XML, and DOM, among others
  • Extensive knowledge and hands-on experience on Spark and its technologies
  • Hands-on experience with Apache Spark framework, including the Spark SQL module for querying databases
  • Familiar with various coding languages used in web development, including HTML, CSS, and JavaScript, Python, Java, Scala, or R proficiency
  • Ability to write clean code that's free of bugs and reproducible by other developers
  • Experience managing SQL databases and organizing big data
  • Hands-on experience with ETL such as Matillion ETL, MS SQL, SSIS (Server Integration Services), Python/Perl, Oracle, SQL Server/MySQL
  • Solid understanding of Data warehousing Schemas, Dimensional modeling, implementing data storage solutions to support efficient data retrieval and analysis
  • Skill set necessary for debugging ETL processes, optimizing data flows, and ensuring that the data pipeline is robust and error-free

Educational Qualification:

Bachelor's/Master's degree in Computer Science, Engineering, or a related field

We offer a professional work environment and opportunities to grow in the Information technology world

Note:

Candidates required to attend phone/video call/in-person interviews and after selection, the candidate should go through all background checks on education and experience

Please email your resume to:

Do NOT FORGET to mention your valid LinkedIn on your resume

After carefully reviewing your experience and skills, one of our HR team members will contact you on the next steps


  • ETL Developer

    2 weeks ago


    Seattle, Washington, United States Petadata Full time

    Job Title: ETL DeveloperWe are seeking an experienced ETL Developer to join our team at Petadata. As an ETL Developer, you will be responsible for designing, developing, and implementing scalable data processing solutions using Apache Spark and Matillion ETL tool.Key Responsibilities:Design and develop efficient ETL processes to extract, transform, and load...

  • ETL Developer

    3 weeks ago


    Seattle, Washington, United States PETADATA Full time

    Job Title: ETL DeveloperWe are seeking an experienced ETL Developer to join our team at PETADATA. As an ETL Developer, you will be responsible for designing, developing, and implementing scalable data processing solutions using Apache Spark.Key Responsibilities:Design and develop efficient data processing workflows using Matillion ETL toolCollaborate with...

  • ETL Developer

    2 weeks ago


    Seattle, Washington, United States Petadata Full time

    Job Title: ETL DeveloperWe are seeking an experienced ETL Developer to join our team at Petadata. As an ETL Developer, you will be responsible for designing, developing, and implementing scalable data processing solutions using Apache Spark.Key Responsibilities:Design and develop efficient data processing solutions using Apache SparkCollaborate with...

  • AWS DevOps Engineer

    4 days ago


    Seattle, Washington, United States Petadata Full time

    Job Title: AWS DevOps Engineer - MatillionAbout the Role:We are seeking an experienced AWS DevOps Engineer with expertise in Matillion to join our team at Petadata. The successful candidate will design, implement, and manage data integration pipelines, ensuring seamless data flow from various sources to our data warehouse.Key Responsibilities:Design and...

  • ETL Developer

    4 days ago


    Seattle, Washington, United States Petadata Full time

    Job DescriptionPosition: ETL DeveloperLocation: Seattle, WAExperience: 10+ yearsWork type: Fulltime (W2 / C2C)Petadata is seeking a highly skilled ETL Developer to join our team.Key Responsibilities:Design, develop, and implement scalable data processing solutions using Apache Spark.Collaborate with cross-functional teams to understand data requirements and...

  • Senior ETL Developer

    3 weeks ago


    Seattle, Washington, United States Photon Full time

    Senior ETL DeveloperPhoton is seeking a highly skilled Senior ETL Developer to join our Data Services Team. As a key member of our team, you will play a lead role in the areas of ETL design, data modeling, and ETL development.Key ResponsibilitiesDesign and develop ETL processes to extract, transform, and load data into our Enterprise Data...

  • Senior ETL Developer

    2 weeks ago


    Seattle, Washington, United States Photon Full time

    Senior ETL DeveloperPhoton is seeking a highly skilled Senior ETL Developer to join our Data Services Team. As a key member of our team, you will play a lead role in the areas of ETL design, data modeling, and ETL development.Key ResponsibilitiesDesign and develop ETL processes to extract, transform, and load data into our Enterprise Data...


  • Seattle, Washington, United States Photon Full time

    Senior ETL Developer Job DescriptionWe are seeking a highly skilled Senior ETL Developer to join our Data Services Team at Photon. As a key member of our team, you will play a lead role in the areas of ETL design, data modeling, and ETL development.Key ResponsibilitiesDesign and develop ETL processes to extract, transform, and load data into our Enterprise...


  • Seattle, Washington, United States Photon Full time

    About PhotonWe are a high-growth organization serving over 40% of Fortune 100 companies, providing a unique combination of Strategy Consulting, Creative Design, and Technology Services.Our team is passionate about delivering innovative solutions that make a real impact on our clients' businesses.Job Title: Senior ETL DeveloperWe are seeking an experienced...

  • Senior ETL Developer

    2 weeks ago


    Seattle, Washington, United States Photon Full time

    About PhotonWe are Photon, a leading Digital Platform Engineering company that provides a unique combination of Strategy Consulting, Creative Design, and Technology Services to a wide range of customers.As a high growth organization serving over 40% of Fortune 100 companies, we truly believe that our people make the world of difference for our clients and...


  • Seattle, Washington, United States Futran Tech Solutions Pvt. Ltd. Full time

    Job Title: Senior ETL Developer with PentahoFutran Tech Solutions Pvt. Ltd. is seeking a highly skilled Senior ETL Developer with expertise in Pentaho Data Integration to join our team.Job Summary:We are looking for a seasoned ETL Developer with a strong background in data warehousing and business intelligence to design, develop, and deploy enterprise data...

  • Senior ETL Developer

    2 weeks ago


    Seattle, Washington, United States Photon Full time

    About PhotonWe are Photon, a leading Digital Platform Engineering company that provides a unique combination of Strategy Consulting, Creative Design, and Technology Services to a wide range of customers.As a high growth organization serving over 40% of Fortune 100 companies, we truly believe that our people make the world of difference for our clients and...

  • Data Engineer

    3 weeks ago


    Seattle, Washington, United States Tata Consultancy Services Full time

    Job Title: Teradata ETL Data EngineerJob Summary:We are seeking a highly skilled Data Engineer with expertise in ETL development using Teradata utilities and tools. The ideal candidate will have strong knowledge of database concepts, including Oracle, Teradata, and SQL Server, and be able to develop complete ETL jobs.Key Responsibilities:ETL Development:...


  • Seattle, Washington, United States Tata Consultancy Services Full time

    Job SummaryWe are seeking a skilled Data Engineer with expertise in ETL (Extract, Transform, Load) processes to join our team at Tata Consultancy Services. As a Teradata ETL Data Engineer, you will be responsible for designing, developing, and implementing ETL solutions to extract, transform, and load data from various sources into Teradata databases.Key...

  • Senior ETL Developer

    2 weeks ago


    Seattle, Washington, United States Photon Full time

    About PhotonWe are Photon, a leading Digital Platform Engineering company that provides a unique combination of Strategy Consulting, Creative Design, and Technology Services to a wide range of customers.As a high growth organization serving over 40% of Fortune 100 companies, we truly believe that our people make the world of difference for our clients and...

  • Data Engineer

    4 weeks ago


    Seattle, Washington, United States Tata Consultancy Services Full time

    Job Summary:We are seeking a highly skilled Data Engineer with expertise in ETL (Extract, Transform, Load) processes to join our team at Tata Consultancy Services. As a Data Engineer - ETL Specialist, you will be responsible for designing, developing, and implementing efficient ETL solutions using Teradata utilities and tools.Key Responsibilities:Design and...

  • Data Engineer

    2 weeks ago


    Seattle, Washington, United States Tata Consultancy Services Full time

    Job Title: Teradata ETL Data EngineerWe are seeking a skilled Teradata ETL Data Engineer to join our team at Tata Consultancy Services.Location: Seattle, WA (Onsite)Job Type: Full TimeKey Responsibilities:Develop and implement ETL processes using Teradata utilities and tools.Design and optimize database schema for efficient data storage and retrieval.Write...

  • Senior ETL Developer

    3 weeks ago


    Seattle, Washington, United States Photon Full time

    About PhotonWe are Photon, a leading Digital Platform Engineering company that provides a unique combination of Strategy Consulting, Creative Design, and Technology Services to a wide range of customers.As a high growth organization serving over 40% of Fortune 100 companies, we truly believe that our people make the world of difference for our clients and...

  • Data Engineer

    5 days ago


    Seattle, Washington, United States Tata Consultancy Services Full time

    Job Title: ETL / Data EngineerExperience required: (in Yrs)5+ yrs ETL development and script based ETL developmentKey Responsibilities:Develop data pipeline to transfer data from transactional system to Data warehouse.Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management and adhering...


  • Seattle, Washington, United States iSoftTek Solutions Inc Full time

    Job Title: Software Development EngineerWe are seeking a skilled Software Development Engineer to join our team at iSoftTek Solutions Inc. The ideal candidate will have experience with AWS tools and services, as well as a strong understanding of.NET and SQL code.Key Responsibilities:Work with customers to understand their needs and develop solutions using...