Designation: ETL / Data Integration Consultant
Experience: 8+ Years
Location: Ahmedabad | On-site
Priority: Immediate Joiners Preferred
Job Summary
We are looking for a skilled ETL / Data Integration Consultant to build scalable, high-performance data platforms. The ideal candidate should have strong hands-on experience with Pentaho, Snowflake, Databricks and AWS, along with expertise in ETL/ELT development, data warehousing, and modern data transformation practices. This role requires an individual who can work independently, deliver reliable data solutions, and collaborate effectively with cross-functional teams.
Roles & Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines using Pentaho and modern data engineering tools.
- Build and optimize enterprise data platforms using Snowflake and Databricks.
- Design and implement data warehouses, dimensional models, and data marts.
- Develop data transformation models using dbt and ensure high-quality, reliable data delivery.
- Optimize SQL queries and improve Snowflake performance for large-scale datasets.
- Integrate data pipelines with Tableau and other BI/Reporting platforms.
- Work with AWS Cloud Services and Linux environments to deploy and support data solutions.
- Process structured and semi-structured data formats such as JSON, CSV, XML, and Excel.
- Follow Git-based development practices and collaborate using Jira.
- Monitor, troubleshoot, and optimize data pipelines to ensure performance, scalability, and reliability.
Must-Have Skills
- 8+ years of experience in Data Engineering.
- Strong hands-on experience with Pentaho (PDI/Kettle).
- Expertise in Snowflake and Databricks.
- Strong understanding of Data Warehousing, Dimensional Modeling, and Data Mart design.
- Experience with dbt for data transformation and modeling.
- Advanced SQL development, query optimization, and performance tuning.
- Experience building end-to-end ETL/ELT pipelines.
- Hands-on experience with AWS Cloud Services and Linux.
- Experience integrating data platforms with Tableau or other BI tools.
- Strong understanding of JSON, CSV, XML, and Excel data formats.
- Experience with GitHub, version control, and Jira.
- Excellent analytical, troubleshooting, and communication skills.
Good-to-Have Skills
- Snowflake Administration.
- Apache Airflow.
- CI/CD implementation for Data Engineering workflows.
- Data platform monitoring, automation, and performance optimization.
Exposure to enterprise data governance and best practices.
-
Pentaho, Snowflake, Databricks, AWS, ETL, ELT, Data Warehousing, Dimensional Modeling, Data Mart, dbt, SQL, Query Optimization, Performance Tuning, Tableau, BI Platforms, Linux, JSON, CSV, XML, Excel, Git, GitHub, Jira, Communication, Analytical, Troubleshooting, Snowflake Administration, Apache Airflow, CI/CD, Data Governance, Automation, Monitoring, Performance Optimization, Data Engineering
Techify is the Fastest Growing Tech Company with a talented, passionate and learning team. Techify's DNA Is About Solutions & Technologies. We are here to help our customers grow their business.
Our Vision is to Become One of the Best Product Engineering companies in India We put client relationships first hence our mission is to build software solutions that help clients transform their business by unleashing hidden potential with technology.
So our success mantra is Customer first, Team second and We are the third.
Our main focus is our Customers’ and Partners’ success. Our visionary and experienced team turns innovative ideas into efficient products & softwares. Our well-defined processes ensure on-time delivery to our partners giving us an edge over our competitors. The most important pillar in achieving our goals is our dedicated Team and to encourage them and keep them motivated, we have set up a culture that rewards Self Development and Innovation.
Our cutting-edge services include intensive research and analysis to identify the appropriate technology to achieve best performances by incurring least cost possible. We take a studied approach towards cost, performance, feature trade-offs to help companies surmount the challenges of delivering high-quality, timely products and services to the marketplace. We have the ability to take up any product be it at the stage of defining, designing, verifying or realizing.
Here are our recognitions. We are the winner of Grand Challenge in Vibrant Gujarat Summit’2018. We have also achieved prestigious “Trend Setter” award from Gujarat Innovation Society. Times Coffee Table Book Covered us in “Gujarat the Inspiring edge” edition. We are also Amazon web services consulting and networking partners.
