ETL with BQ specialist

1 month ago

Chennai, India Revature Full time

Job Title: ETL with BQ specialist

Location: Chennai

Timings: 2PM – 11PM.

Job Description:

We are seeking a skilled ETL (Extract, Transform, Load) Specialist with expertise in Google BigQuery to join our team. The ideal candidate will be responsible for designing, developing, and maintaining ETL processes, ensuring data integrity, reliability, and efficiency. They will work closely with stakeholders to understand business requirements and translate them into effective ETL solutions. This role requires strong analytical skills, attention to detail, and a deep understanding of data warehousing principles. The candidate should be okay with shift timings of 2PM – 11PM.

Responsibilities:

  • develop, and maintain ETL processes using industry best practices and tools, with a focus on Google BigQuery.
  • with cross-functional teams to gather and analyze business requirements, translating them into technical specifications for ETL workflows.
  • data profiling, cleansing, and transformation to ensure data accuracy, completeness, and consistency.
  • ETL workflows for performance and scalability, leveraging advanced features and capabilities of BigQuery.
  • ETL processes, troubleshoot issues, and implement solutions to ensure timely and accurate data delivery.
  • and maintain documentation for ETL processes, including data mappings, transformations, and workflows.
  • updated on emerging technologies and trends in ETL, data warehousing, and Big Data analytics, recommending improvements and best practices.
  • with data engineers, data analysts, and other stakeholders to support data-driven decision-making initiatives.
  • technical guidance and support to junior team members, fostering a culture of learning and continuous improvement.
  • to data governance policies and procedures, ensuring compliance with regulatory requirements and industry standards.

Requirements:

  • with CRUD (Create, Read, Update, Delete) operations in relational database management systems (RDBMS), with a focus on SQL fundamentals.
  • knowledge of data analysis practices, including proficiency in utilizing Looker BI as a Business Intelligence and Visualization tool.
  • in BigQuery with a focus on following good data warehousing practices to retrieve and analyze data.
  • experience in generating reports and dashboards using the Looker Platform.
  • experience with extracting raw data from various sources and storing it in a data warehouse.
  • of data validation, tabulation, and database integration techniques.
  • and maintain databases by acquiring data from primary and secondary sources, building scripts to enhance flexibility and scalability across datasets.
  • writing experience in relevant areas, including queries, reports, and presentations.
  • these updated requirements, the ideal candidate will possess a comprehensive skill set spanning from SQL fundamentals to practical experience with Looker BI and BigQuery, enabling them to effectively extract, analyze, and visualize data to support business decision-making processes.

  • Senior Engineering Manager

    1 week ago

    Chennai, India Ford Motor Company Full time

    At Ford Motor Credit Company, we are modernizing enterprise Data Platforms enabled by Google Cloud, to improve Data, Analytics and AI/ML capabilities, and enhance customer experience, regulatory compliance & operational efficiencies.  This position will manage the India based supplier delivery team for migration of legacy data warehouse from Teradata to...

  • Senior Engineering Manager

    16 hours ago

    chennai, India Ford Motor Company Full time

    At Ford Motor Credit Company, we are modernizing enterprise Data Platforms enabled by Google Cloud, to improve Data, Analytics and AI/ML capabilities, and enhance customer experience, regulatory compliance & operational efficiencies.  This position will manage the India based supplier delivery team for migration of legacy data warehouse from Teradata to...

  • DigiHelic - ETL Test Engineer

    2 weeks ago

    chennai, India Digihelic Solutions Pvt. Ltd. Full time

    Job Description :We are seeking a seasoned ETL Testing Specialist with a minimum of 5 years of overall testing experience to join our team. The ideal candidate will have a strong background in managing test activities within medium to large projects and possess excellent interpersonal skills for effective collaboration with clients and business partners....

  • Senior Specialist

    3 weeks ago

    Chennai, India LTIMindtree Full time

    Senior Specialist - Data EngineeringJob Req Id: 1243143 Senior ETL Developer Candidate must be experienced working in ETL based projects involving Abinitio • Abinitio (Technical Expert) • Teradata (or equivalent RDBMS) • Understands where to obtain information needed to make the appropriate decisions • Demonstrates ability to break down a problem to...

  • DigiHelic - ETL Test Engineer

    2 weeks ago

    Bangalore/Chennai, India Digihelic Solutions Pvt. Ltd. Full time

    Job Description :We are seeking a seasoned ETL Testing Specialist with a minimum of 5 years of overall testing experience to join our team. The ideal candidate will have a strong background in managing test activities within medium to large projects and possess excellent interpersonal skills for effective collaboration with clients and business partners....

  • Senior Specialist

    1 month ago

    chennai, India LTIMindtree Full time

    Senior Specialist - Data Engineering Job Req Id: 1243143 Senior ETL Developer Candidate must be experienced working in ETL based projects involving Abinitio • Abinitio (Technical Expert) • Teradata (or equivalent RDBMS) • Understands where to obtain information needed to make the appropriate decisions • Demonstrates ability to break down a...

  • Senior Specialist

    1 month ago

    Chennai, India LTIMindtree Full time

    Senior Specialist - Data Engineering Job Req Id: 1243143 Senior ETL Developer Candidate must be experienced working in ETL based projects involving Abinitio • Abinitio (Technical Expert) • Teradata (or equivalent RDBMS) • Understands where to obtain information needed to make the appropriate decisions • Demonstrates ability to break down a problem...

  • Senior Developer/Tech Lead

    1 month ago

    chennai, India HuQuo Full time

    Role Description: Sr. Developer - K2View Fabric- 3B  Location: : The ideal candidate is a hands-on K2View Developer with experience in developing ETL scripts and Data Warehousing for real-world use cases. They must be at ease working with on-prem Big Data ecosystem in an agile environment with little supervision. The person should be a self-motivated...

  • Senior Developer/Tech Lead

    2 weeks ago

    Chennai, India HuQuo Full time

    Role Description: Sr. Developer - K2View Fabric- 3B Location: : The ideal candidate is a hands-on K2View Developer with experience in developing ETL scripts and Data Warehousing for real-world use cases. They must be at ease working with on-prem Big Data ecosystem in an agile environment with little supervision. The person should be a...

  • Data Engineer

    1 month ago

    Chennai, India CliqHR Full time

    Job Description : Mandatory Skills : GCP, Python, SQL, Snap logic, Airflow, Data flow- 6-8 years of experience in to GCP Data engineer.- GCP Components (Composer, BQ, Data flow, Pub/Sub, Cloud functions, GCS storage) Intermediate- SQL Advanced level- ETL Processing Advanced level- Python Advanced level - Rest API Must Have- Java Advanced level- Other...

  • Data Engineer

    1 month ago

    Chennai, India CliqHR Full time

    Job Description :Mandatory Skills : GCP, Python, SQL, Snap logic, Airflow, Data flow- 6-8 years of experience in to GCP Data engineer.- GCP Components (Composer, BQ, Data flow, Pub/Sub, Cloud functions, GCS storage) Intermediate- SQL Advanced level- ETL Processing Advanced level- Python Advanced level - Rest API Must Have- Java Advanced level- Other...

  • Data Engineer

    4 weeks ago

    Chennai, Tamil Nadu, India CliqHR Full time

    Job Description :Mandatory Skills : GCP, Python, SQL, Snap logic, Airflow, Data flow- 6-8 years of experience in to GCP Data engineer.- GCP Components (Composer, BQ, Data flow, Pub/Sub, Cloud functions, GCS storage) Intermediate- SQL Advanced level- ETL Processing Advanced level- Python Advanced level - Rest API Must Have- Java Advanced level- Other...

  • Senior Developer/Tech Lead

    2 weeks ago

    Chennai/Hyderabad, India HuQuo Full time

    Role Description: Sr. Developer - K2View Fabric- 3B  Location: : The ideal candidate is a hands-on K2View Developer with experience in developing ETL scripts and Data Warehousing for real-world use cases. They must be at ease working with on-prem Big Data ecosystem in an agile environment with little supervision. The person should be a self-motivated...

  • Senior Developer/Tech Lead

    4 weeks ago

    Chennai/Hyderabad, Tamil Nadu, India Huquo Full time

    Role Description: Sr. Developer - K2View Fabric- 3B Location: : The ideal candidate is a hands-on K2View Developer with experience in developing ETL scripts and Data Warehousing for real-world use cases. They must be at ease working with on-prem Big Data ecosystem in an agile environment with little supervision. The person should be a self-motivated person...

  • System integration senior specialist

    15 hours ago

    Chennai, India NTT DATA Services Full time

    ETL TesterReq. Experience: 7+ YearsProficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical cubes.Previous...

  • System integration senior specialist

    16 hours ago

    chennai, India NTT DATA Services Full time

    ETL Tester   Req. Experience: 7+ Years   Proficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server. Previous experience of testing large scale BI solutions integrating with multiple source and target systems. Understand the mappings of source systems to data models in the target data warehouse schema and analytical cubes....

  • System integration senior specialist

    1 day ago

    Chennai, India NTT DATA Services Full time

    ETL Tester Req. Experience: 7+ Years Proficient enough in SQL to interrogate databases to test the ETL on Microsoft SQL Server.Previous experience of testing large scale BI solutions integrating with multiple source and target systems.Understand the mappings of source systems to data models in the target data warehouse schema and analytical cubes.Previous...

  • Sr Product Specialist

    2 weeks ago

    Chennai, Tamil Nadu, India Cognizant Technology Solutions Full time

    Facets Job Description :Good understanding and hands on experience in Facets data model and Facets batch architecture. Must be proficient in Facets Claims module along with either Member or Provider modules. Able to write SQL queries, stored procedures to extract data from database. Able to Analyse and design based on the business requirements. Have...

  • Sr Product Specialist

    3 weeks ago

    Chennai, India Cognizant Full time

    Facets Job Description : Good understanding and hands on experience in Facets data model and Facets batch architecture.  Must be proficient in Facets Claims module along with either Member or Provider modules. Able to write SQL queries, stored procedures to extract data from database. Able to Analyse and design based on the business requirements. ...

  • Consultant Specialist

    3 weeks ago

    Chennai, India BirlaSoft Full time

    Data Engineer will primarily prepare data for analytical or operational use by creation of business unit specific Data Marts within the data warehouse.The goal is to make data easily accessible and to optimize the organization analysis opportunities by designing and building systems for collecting, storing, and analyzing data at scale.The data engineer...