Data Engineer/ETL Developer

1 month ago

indore, India Kanerika Software Full time
Job Description
As a Data Engineer/ETL Developer, you will be responsible for designing, developing, and maintaining our global data warehouse and data marts on the Snowflake Platform. You will play a pivotal role in architecture solutions for complex data integration challenges, ensuring the scalability, performance, and reliability of our data pipelines.
Requirements


Primary Responsibilities:


Design, develop, and implement ETL processes using Snowflake technologies to extract, transform, and load data from various source systems into our global data warehouse.

Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications for data integration and ETL workflows.

Optimize ETL processes for performance, scalability, and reliability to support the processing of large volumes of data.

Develop and maintain data models, schemas, and structures within Snowflake to support efficient data storage and retrieval.

Implement data quality checks, validation routines, and error handling mechanisms to ensure the accuracy and integrity of data.

Work closely with data engineers, data analysts, and business stakeholders to troubleshoot issues, identify opportunities for optimization, and drive continuous improvement of our data solutions.

Document technical designs, configurations, and best practices for ETL processes and data warehouse components.

Stay updated on industry trends and emerging technologies related to data warehousing, ETL, and cloud computing, and provide recommendations for adopting new tools and techniques to enhance our data capabilities.

Must-Have Skills:

  • Strong SQL knowledge.
  • Deep understanding of data warehousing concepts, dimensional modeling, and data mart design principles.
  • Experience with Snowflake features such as SnowSQL, Snowpipe, tasks, and stored procedures is preferred.
  • Experience in creating complex queries and stored procedures.
  • Proven track record of architecting scalable and performant data warehouse solutions, handling large volumes of data and complex data transformations.
  • Proficiency in utilizing the Azure Cloud platform, including Azure Data Factory, Azure Storage, and Azure Databricks.
  • Proficiency in scripting languages such as Python, Shell scripting, or similar for automation and data manipulation.
  • Proficiency in Job Scheduling tools (Tidal)

 

Good-to-Have Skills:

  • Familiarity with Informatica Power Center.
  • Familiarity with tools like SSIS.
  • Python/Java

Benefits


1. Culture:

· Open Door Policy: Encourages open communication and accessibility to management.

· Open Office Floor Plan: Fosters a collaborative and interactive work environment.

· Flexible Working Hours: Allows employees to have flexibility in their work schedules.

· Employee Referral Bonus: Rewards employees for referring qualified candidates.

· Appraisal Process Twice a Year: Provides regular performance evaluations and feedback.


2. Inclusivity and Diversity:


· Hiring practices that promote diversity: Ensures a diverse and inclusive workforce.

· Mandatory POSH training: Promotes a safe and respectful work environment.

3. Health Insurance and Wellness Benefits:


· GMC and Term Insurance: Offers medical coverage and financial protection.

· Health Insurance: Provides coverage for medical expenses.

· Disability Insurance: Offers financial support in case of disability


4. Child Care & Parental Leave Benefits:

· Company-sponsored family events: Creates opportunities for employees and their families to bond.

· Generous Parental Leave: Allows parents to take time off after the birth or adoption of a child.

· Family Medical Leave: Offers leave for employees to take care of family members' medical needs.


5. Perks and Time-Off Benefits:

· Company-sponsored outings: Organizes recreational activities for employees.

· Gratuity: Provides a monetary benefit as a token of appreciation.

· Provident Fund: Helps employees save for retirement.

· Generous PTO: Offers more than the industry standard for paid time off.

· Paid sick days: Allows employees to take paid time off when they are unwell.

· Paid holidays: Gives employees paid time off for designated holidays.

· Bereavement Leave: Provides time off for employees to grieve the loss of a loved one.


6. Professional Development Benefits:

· L&D with FLEX- Enterprise Learning Repository: Provides access to a learning repository for professional development.

· Mentorship Program: Offers guidance and support from experienced professionals.

· Job Training: Provides training to enhance job-related skills.

· Professional Certification Reimbursements: Assists employees in obtaining professional certifications.

· Promote from Within: Encourages internal growth and advancement opportunities.

 


Requirements
. Primary Responsibilities: Design, develop, and implement ETL processes using Snowflake technologies to extract, transform, and load data from various source systems into our global data warehouse. Collaborate with cross-functional teams to understand business requirements and translate them into technical specifications for data integration and ETL workflows. Optimize ETL processes for performance, scalability, and reliability to support the processing of large volumes of data. Develop and maintain data models, schemas, and structures within Snowflake to support efficient data storage and retrieval. Implement data quality checks, validation routines, and error handling mechanisms to ensure the accuracy and integrity of data. Work closely with data engineers, data analysts, and business stakeholders to troubleshoot issues, identify opportunities for optimization, and drive continuous improvement of our data solutions. Document technical designs, configurations, and best practices for ETL processes and data warehouse components. Stay updated on industry trends and emerging technologies related to data warehousing, ETL, and cloud computing, and provide recommendations for adopting new tools and techniques to enhance our data capabilities. Must-Have Skills: Strong SQL knowledge. Deep understanding of data warehousing concepts, dimensional modeling, and data mart design principles. Experience with Snowflake features such as SnowSQL, Snowpipe, tasks, and stored procedures is preferred. Experience in creating complex queries and stored procedures. Proven track record of architecting scalable and performant data warehouse solutions, handling large volumes of data and complex data transformations. Proficiency in utilizing the Azure Cloud platform, including Azure Data Factory, Azure Storage, and Azure Databricks. Proficiency in scripting languages such as Python, Shell scripting, or similar for automation and data manipulation. Proficiency in Job Scheduling tools (Tidal) Good-to-Have Skills: Familiarity with Informatica Power Center. Familiarity with tools like SSIS. Python/Java

  • Data Engineer/ETL Developer

    1 week ago

    Indore, Madhya Pradesh, India Kanerika Software Full time

    Job Description As a Data Engineer/ETL Developer, you will be responsible for designing, developing, and maintaining our global data warehouse and data marts on the Snowflake Platform. You will play a pivotal role in architecture solutions for complex data integration challenges, ensuring the scalability, performance, and reliability of our data...

  • Data Engineer/ETL Developer

    1 month ago

    Indore, India Kanerika Software Full time

    As a Data Engineer/ETL Developer, you will be responsible for designing, developing, and maintaining our global data warehouse and data marts on the Snowflake Platform. You will play a pivotal role in architecture solutions for complex data integration challenges, ensuring the scalability, performance, and reliability of our data...

  • Data Engineer/ETL Developer

    1 week ago

    Indore, Madhya Pradesh, India Kanerika Software Full time

    As a Data Engineer/ETL Developer, you will be responsible for designing, developing, and maintaining our global data warehouse and data marts on the Snowflake Platform. You will play a pivotal role in architecture solutions for complex data integration challenges, ensuring the scalability, performance, and reliability of our data...

  • Data Engineer/ETL Developer

    2 weeks ago

    Indore, India Kanerika Software Full time

    Data Engineer/ETL DeveloperAbout KanerikaWho we areKanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of...

  • Data Engineer/ETL Developer

    2 weeks ago

    indore, India Kanerika Software Full time

    Data Engineer/ETL Developer About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use...

  • Data Engineer/ETL Developer

    3 weeks ago

    Indore, India Kanerika Software Full time

    Data Engineer/ETL Developer About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use...

  • Data Engineer/ETL Developer

    1 week ago

    Indore, Madhya Pradesh, India Kanerika Software Full time

    Data Engineer/ETL DeveloperAbout KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of...

  • ETL Tester

    3 weeks ago

    Indore, India Kanerika Software Full time

    ETL TesterAbout KanerikaWho we areKanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data. We leverage...

  • Chapter247 - Senior Data Engineer - ETL Tools

    3 weeks ago

    Indore/MP, India Chapter247 Infotech Full time

    Responsibilities : - Design, develop, and implement data warehousing solutions with a strong focus on Snowflake, Databricks, and Azure.- Build productized data ingestion and processing pipelines to facilitate seamless data integration.- Architect, design, and operationalize large-scale data and analytics solutions on Snowflake Cloud Data Warehouse.- Develop...

  • ETL Tester

    1 month ago

    Indore, India Kanerika Software Full time

    ETL Tester About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data. We...

  • ETL Tester

    3 weeks ago

    indore, India Kanerika Software Full time

    ETL Tester About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data. We...

  • ETL Tester

    3 weeks ago

    Indore, India Kanerika Software Full time

    ETL Tester About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data. We...

  • ETL Tester

    1 month ago

    indore, India Kanerika Software Full time

    ETL Tester About KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data. We...

  • ETL Tester

    1 week ago

    Indore, Madhya Pradesh, India Kanerika Software Full time

    ETL TesterAbout KanerikaWho we are Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data. We leverage...

  • Senior Cloud Data Engineer

    1 week ago

    Indore, Madhya Pradesh, India Talent-Max Consultant Full time

    Job Title: Senior Cloud Data EngineerCompany: ConfidentialJob Location: RemoteWorking Hours: 3 PM - 12 AM (IST)Immediate Joining PreferredEmployment Type: Full-TimeRole Overview:Designation: Cloud Data EngineerQualifications: BE/MCA or equivalentExperience: 7-10 YearsKey Job Requirements: Over 7 years of experience working with Alteryx & GCP. Proficient in...

  • Senior Cloud Data Engineer

    2 months ago

    INdore, Madhya Pradesh, India Talent-Max Consultant Full time

    Job Role : Sr Cloud Data EngineerJob Location : RemoteWorking Timings : 3 PM - 12 AM (IST)Joining : Earlier the bestEmployment : Full TimeSpecifications :Designation : Cloud Data EngineerQualifications : BE/MCA or equivalentExperience : 7-10 YearsDesired Job attributes :- 07+ years' experience in Alteryx & GCP.- Experience with SSIS.- Hands-on experience...

  • Senior Cloud Data Engineer

    3 weeks ago

    INdore, India Talent-Max Consultant Full time

    Job Role : Sr Cloud Data EngineerJob Location : RemoteWorking Timings : 3 PM - 12 AM (IST)Joining : Earlier the bestEmployment : Full TimeSpecifications :Designation : Cloud Data EngineerQualifications : BE/MCA or equivalentExperience : 7-10 YearsDesired Job attributes :- 07+ years' experience in Alteryx & GCP.- Experience with SSIS.- Hands-on...

  • Senior Cloud Data Engineer

    2 months ago

    Indore, India Talent-Max Consultant Full time

    Job Role : Sr Cloud Data EngineerJob Location : RemoteWorking Timings : 3 PM - 12 AM (IST)Joining : Earlier the bestEmployment : Full TimeSpecifications :Designation : Cloud Data EngineerQualifications : BE/MCA or equivalentExperience : 7-10 YearsDesired Job attributes :- 07+ years' experience in Alteryx & GCP.- Experience with SSIS.- Hands-on...

  • Senior Cloud Data Engineer

    2 months ago

    indore, India Talent-Max Consultant Full time

    Job Role : Sr Cloud Data EngineerJob Location : RemoteWorking Timings : 3 PM - 12 AM (IST)Joining : Earlier the bestEmployment : Full TimeSpecifications :Designation : Cloud Data EngineerQualifications : BE/MCA or equivalentExperience : 7-10 YearsDesired Job attributes :- 07+ years' experience in Alteryx & GCP.- Experience with SSIS.- Hands-on experience...

  • Senior Cloud Data Engineer

    2 months ago

    INdore, India Talent-Max Consultant Full time

    Job Role : Sr Cloud Data EngineerJob Location : RemoteWorking Timings : 3 PM - 12 AM (IST)Joining : Earlier the bestEmployment : Full TimeSpecifications :Designation : Cloud Data EngineerQualifications : BE/MCA or equivalentExperience : 7-10 YearsDesired Job attributes :- 07+ years' experience in Alteryx & GCP.- Experience with SSIS.- Hands-on...