Cutshort logo
For Employers
DataMetica logo
ETL Developer

ETL Developer at DataMetica · Pune · 4 - 7 years · ₹5L - ₹15L / yr · Profitable · Posted 14 Jan 2022

DataMetica's logo

ETL Developer

Shivani Mahale's profile picture
Posted by Shivani Mahale
4 - 7 yrs
₹5L - ₹15L / yr
Pune
Skills
ETL
Informatica PowerCenter
Teradata
Data Warehouse (DWH)
IBM InfoSphere DataStage
Requirement -
  • Must have 4 to 7 years of experience in ETL Design and Development using Informatica Components.
  • Should have extensive knowledge in Unix shell scripting.
  • Understanding of DW principles (Fact, Dimension tables, Dimensional Modelling and Data warehousing concepts).
  • Research, development, document and modification of ETL processes as per data architecture and modeling requirements.
  • Ensure appropriate documentation for all new development and modifications of the ETL processes and jobs.
  • Should be good in writing complex SQL queries.
Opportunities-
  • • Selected candidates will be provided training opportunities on one or more of following: Google Cloud, AWS, DevOps Tools, Big Data technologies like Hadoop, Pig, Hive, Spark, Sqoop, Flume and
  • Kafka would get chance to be part of the enterprise-grade implementation of Cloud and Big Data systems
  • Will play an active role in setting up the Modern data platform based on Cloud and Big Data
  • Would be part of teams with rich experience in various aspects of distributed systems and computing.
Read more
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos

About DataMetica

Founded :
2013
Type :
Services
Size :
100-1000
Stage :
Profitable

About

As a global leader in Data Warehouse Migration, Data Modernization, and Data Analytics, we empower businesses through automation and help you attain excellence. Our Belief is to Empowering companies to master their businesses and helping them achieve their full potential, we nurture clients with our innovative frameworks. Our embedded values help us strengthen the bond with our clients, ensuring growth for all. Datametica is a preferred partner with leading cloud vendors. We offer solutions related to migration from current Enterprise Data Warehouses to the Cloud determining which of these is best suited to your needs. We are giving Data Wings.
Read more

Company video

DataMetica's video section
DataMetica's video section

Photos

Company featured pictures
Company featured pictures
Company featured pictures
Company featured pictures
Company featured pictures
Company featured pictures
Company featured pictures
Company featured pictures

Connect with the team

Profile picture
Sumangali Desai
Profile picture
Shivani Mahale
Profile picture
Nitish Saxena
Profile picture
Nikita Aher
Profile picture
Pooja Gaikwad
Profile picture
Sayali Kachi
Profile picture
syed raza

Company social profiles

bloglinkedintwitterfacebook

Similar jobs (10)

Bean HR Consulting
Divya Sharma
Posted by Divya Sharma
Faridabad
4 - 10 yrs
₹10L - ₹20L / yr
Informatica
CDI
CAI
Application Integration
Data integration
+2 more

Job Description:

Skill Set

Informatica, IDMC, Informatica MDM

Experience

4-6 Years

Location

Faridabad, Haryana, India

Work Mode- Hybrid

 

Job Description

Roles & Responsibilities

 

  • Lead project team members through all activities required to successfully deliver Informatica.
  • Define technical specifications for workflows and business rules.
  • Prepare detailed design documents for data migration.
  • Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals.
  • Train and mentor colleagues in Informatica implementation activities and best practices.
  • Support integration, system, and user acceptance testing.
  • Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations.
  • Profile & Analyze Source Data usage using ETL tool.
  • Automation, job scheduling, dependencies, monitoring.
  • Configure/Script Business rules and transformation rules in ETL
  • Data pipeline using IICS
  • Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules
  • Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential.
  • Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems.
  • Experience in administering, supporting, and performance tuning using Informatica.


Read more
MNC
MNC
Agency job
via VY SYSTEMS PRIVATE LIMITED by Akilandeswari Panneerselvam
Bengaluru (Bangalore)
6 - 9 yrs
₹8L - ₹15L / yr
ETL
Informatica
Hadoop
Apache Spark
Snow flake schema

Position: Backup Data ETL Developer

Experience: 6–9 Years

Location:Mumbai

Employment Type: Full-time

Job Description:

We are looking for a Backup Data ETL Developer with 6–9 years of experience in designing, developing, and supporting data extraction, transformation, and loading (ETL) processes.

The candidate should have strong hands-on experience with Hadoop, Spark, Informatica, and Snowflake, along with expertise in large-scale data processing and data integration technologies.

Key Skills:

Hadoop

Spark

Informatica

Snowflake

ETL Development

Data Integration

Data Transformation

Large-Scale Data Processing

ETL Workflows and Data Pipelines

Troubleshooting and Problem-Solving

Strong analytical and collaboration skills

Read more
Raah Techservices
Bengaluru (Bangalore), Mumbai
5 - 10 yrs
₹5L - ₹30L / yr
Ab Initio
Data modeling
Data integration
Hadoop
Informatica
+1 more

We are looking for Data engineer with strong expertise in Data warehousing to join our team.


Key skills : ab initio, ssis , Informatica, Hadoop and Teradata

Read more
 a leading Data, Analytics & Digital Solutions partner that helps global clients unlock value at every stage of the data and product development
a leading Data, Analytics & Digital Solutions partner that helps global clients unlock value at every stage of the data and product development
Agency job
via HyrHub by Shwetha Naik
Remote only
7 - 10 yrs
₹18L - ₹20L / yr
Informatica
Snow flake schema
SQL
Datawarehousing
ETL

Job Description: Informatica IDMC & Snowflake Developer

Experience: 6+ Years

Required Skills: Informatica IDMC, ETL, Data Warehousing, Snowflake, SQL

Contract Duration: 2 months


Required Technical Skills

  • Informatica: Strong hands-on experience with Informatica IDMC, Cloud Data Integration (CDI), Cloud Application Integration (CAI), Mass Ingestion (MI).
  • ETL / ELT: Strong understanding of ETL architecture, data integration patterns, incremental loading, and error-handling strategies.
  • Data Warehousing: Good understanding of dimensional modelling, data marts, fact and dimension tables, and data warehouse design principles.
  • Snowflake: Hands-on experience with Snowflake architecture, SQL, data loading, transformations, performance tuning, and warehouse optimization.
  • SQL: Strong proficiency in complex SQL queries, analytical functions, views, stored procedures, and query optimization.
  • Database Development: Experience creating and maintaining database objects, validating data, reconciling datasets, and troubleshooting performance issues.

Candidate Profile

  • 6+ years of hands-on experience in ETL/ELT development and data integration along with IDMC, Snowflake, Data Warehousing and SQL.
  • Strong analytical, problem-solving, and communication skills.
  • Ability to work independently, manage priorities, and collaborate effectively with cross-functional teams.
  • Proven ability to deliver high-quality, scalable, and maintainable data solutions in an Agile Environment.


Read more
Bengaluru (Bangalore)
6 - 10 yrs
₹2L - ₹22L / yr
ETL Development
Hadoop
PySpark
skill iconPython
SQL
+3 more

Job Description

We are looking for an experienced ETL Developer with strong expertise in ETL development, Hadoop, PySpark, Python, and SQL. The candidate should have hands-on experience in developing data pipelines, processing and transforming large datasets, and working with data warehousing and big data technologies.

Key Responsibilities

  • Design, develop, and maintain ETL processes and data pipelines.
  • Work with Hadoop and PySpark to process and transform large volumes of data.
  • Develop and optimize Python scripts for data processing and automation.
  • Write complex SQL queries for data extraction, transformation, and validation.
  • Perform data cleansing, integration, transformation, and validation.
  • Work with data warehousing concepts and large-scale data processing systems.
  • Optimize ETL workflows for performance, scalability, and reliability.
  • Troubleshoot data pipeline failures and resolve data quality issues.
  • Collaborate with data engineers, analysts, and other technical teams.
  • Follow data governance, quality, and development best practices.

Required Skills

  • Strong experience in ETL Development – Mandatory
  • Hands-on experience with Hadoop – Mandatory
  • Strong experience in PySpark – Mandatory
  • Good programming skills in Python – Mandatory
  • Strong knowledge of SQL – Mandatory
  • Experience in Data Processing and Transformation – Mandatory
  • Knowledge of Data Warehousing – Mandatory
  • Experience with Big Data Technologies – Mandatory

Opportunity Details

Role: ETL Developer – Hadoop & PySpark

Experience: 6–10 Years

Location: Bangalore

Mandatory Skills

ETL Development | Hadoop | PySpark | Python | SQL | Data Processing & Transformation | Data Warehousing | Big Data Technologies

Read more
VY SYSTEMS PRIVATE LIMITED
Bengaluru (Bangalore)
6 - 10 yrs
₹5L - ₹30L / yr
ETL
ETL Development
skill iconPython
PySpark

Hiring: ETL Developer – Hadoop & PySpark

Location: Bangalore

Experience: 6–10 Years

Budget: 25–30 LPA

Work Mode: Weekdays

Job Description

We are looking for an experienced ETL Developer with strong expertise in Hadoop, PySpark, Python, and SQL to design, develop, and optimize data processing and transformation solutions. The ideal candidate should have hands-on experience working with big data technologies, building scalable ETL pipelines, and managing data for data warehousing and analytics.

Key Responsibilities

  • Design, develop, and maintain scalable ETL pipelines for large-scale data processing.
  • Develop data transformation workflows using PySpark and Python.
  • Work with Hadoop and other big data technologies to process and manage large datasets.
  • Write complex SQL queries for data extraction, transformation, validation, and analysis.
  • Implement data cleansing, data quality checks, and data validation processes.
  • Develop and optimize data integration workflows for data warehousing solutions.
  • Troubleshoot ETL failures, performance issues, and data discrepancies.
  • Optimize PySpark jobs and SQL queries for performance and scalability.
  • Collaborate with data engineers, architects, analysts, and other stakeholders to deliver reliable data solutions.
  • Ensure data accuracy, consistency, and adherence to established data governance standards.

Mandatory Skills

  • Strong hands-on experience in ETL development.
  • Good experience with Hadoop and big data technologies.
  • Proficiency in PySpark and Python programming.
  • Strong SQL skills, including complex queries and data manipulation.
  • Experience in data processing, data transformation, and data integration.
  • Understanding of data warehousing concepts and architecture.
  • Experience in developing, debugging, and optimizing ETL pipelines.

Required Experience

  • 6–10 years of relevant experience in ETL development and data engineering.
  • Practical experience handling large datasets using Hadoop and PySpark.
  • Strong analytical, problem-solving, and troubleshooting skills.
  • Ability to work independently and collaborate effectively within a team.


Interested candidates can share their updated resumes along with current CTC, expected CTC, notice period, and total relevant experience.

Read more
Neuvamacro Technology Pvt Ltd
Remote, Bengaluru (Bangalore), Mumbai
8 - 10 yrs
₹13L - ₹16L / yr
SQL
skill iconPython
ETL
Data warehouse architecture
Data modeling
+4 more

Shift: Second Shift (2:00 PM – 10:00 PM)

Joining: Immediate


About the Role

We are looking for an experienced Data Integration Developer with strong hands-on expertise in SQL, Python, ETL development, Snowflake, and AWS data services.

The ideal candidate should have extensive experience in designing, developing, and maintaining data integration solutions, building data warehouse architectures, and implementing scalable ETL pipelines. Strong SQL development and performance optimization skills are essential for this role.

This is a remote position; however, candidates must be available to visit our Mumbai or Bangalore location for three days during the onboarding process.

Key Responsibilities

SQL Development & Performance Optimization

  • Develop complex SQL queries, stored procedures, and data transformation logic.
  • Optimize SQL queries for performance, scalability, and efficiency.
  • Perform advanced data analysis, validation, and reconciliation.
  • Troubleshoot complex SQL and data-related issues.

ETL Development & Data Integration

  • Design, develop, and maintain ETL pipelines and data integration workflows.
  • Work with SQL and Python for data extraction, transformation, and loading.
  • Ensure data accuracy, consistency, and integrity across systems.
  • Identify and resolve data pipeline failures and integration issues.

Data Warehousing & Data Modeling

  • Design and maintain data warehouse architectures.
  • Develop data warehouse schemas based on business requirements.
  • Work on dimensional data modeling, including Facts and Dimensions.
  • Implement Slowly Changing Dimensions (SCD).
  • Support data analysis and business information reconciliation.

Snowflake & AWS

  • Develop and manage data solutions using Snowflake.
  • Work with AWS services, particularly Amazon S3.
  • Manage AWS connections and data access configurations.
  • Build and maintain cloud-based data integration solutions.

Python & Apache Airflow

  • Develop data processing and automation solutions using Python.
  • Build, schedule, and monitor workflows using Apache Airflow.
  • Troubleshoot workflow failures and improve pipeline reliability.

Agile & Development Lifecycle

  • Participate in Agile development processes, sprint planning, and team discussions.
  • Contribute throughout all stages of the software development lifecycle.
  • Collaborate with cross-functional teams to understand business and technical requirements.
  • Perform root cause analysis and implement appropriate corrective actions.

Required Skills

  • Advanced SQL – Strong hands-on expertise is mandatory.
  • Python Development
  • ETL Development and Data Integration
  • Snowflake
  • Apache Airflow
  • AWS Services, particularly Amazon S3
  • AWS Connection Management
  • Data Warehouse Architecture
  • Data Modeling (Facts & Dimensions)
  • Slowly Changing Dimensions (SCD)
  • SQL Query Optimization and Performance Tuning
  • Data Analysis and Reconciliation
  • Troubleshooting and Root Cause Analysis
  • Agile Development Methodologies
  • Strong understanding of the Software Development Life Cycle (SDLC)

Experience & Qualifications

  • 8–10 years of overall experience in Data Engineering / Data Integration / ETL Development.
  • Strong professional experience in advanced SQL and Python.
  • Hands-on experience with Snowflake, Apache Airflow, and AWS.
  • Proven experience designing and developing data warehouse solutions.
  • Experience working across the complete product development lifecycle.
  • Ability to independently troubleshoot complex technical challenges.

Additional Requirements

  • Immediate joiners preferred.
  • Must be comfortable working in the second shift (2:00 PM – 10:00 PM).
  • Position is remote, with a mandatory three-day onboarding visit to Mumbai or Bangalore.
  • Strong communication, analytical, and problem-solving skills.
  • Ability to work independently and collaboratively in an Agile environment.


Read more
Automotive
Automotive
Agency job
via Bean HR Consulting by Subhash Tamta
Faridabad
4 - 9 yrs
Best in industry
CAI
IICS
IDMC
ETL
Data integration

Hiring: Informatica IDMC / IICS Developer

Location: Faridabad, Haryana

Experience: 4–7 Years

Must-Have:

• Informatica IDMC / IICS

• Data Integration & Application Integration (CAI)

• ETL / Data Pipelines / Data Migration

• REST, SOAP, SFTP & API Integration

• Strong SQL, Stored Procedures & RDBMS

• Job Scheduling, Monitoring & Performance Tuning


Good to Have: Informatica MFT, DX, DT, MDM & Data Quality

Read more
NeoGenCode Technologies Pvt Ltd
Remote, Pune
3 - 8 yrs
₹14L - ₹30L / yr
Data Platform Engineer
skill iconJava
skill iconPython
SQL
Data engineering
+13 more

Job Title : Data Platform Engineer (SDE 2 / SDE 3)

Experience : 3 to 8 Years (SDE2 : 3 to 5 Years | SDE3 : 5.5 to 8 Years)

Location : Remote (Contract) → Pune (Post Conversion)

Employment Type : Contract-to-Hire (3 Months)


Mandatory Skills :

Java / Python / Go, SQL, Data Engineering, ETL / ELT, Apache Airflow, Apache Spark / Flink, Kafka, AWS/GCP/Azure, Distributed Systems, API Development, Docker, Kubernetes, CI/CD, System Design


Role Overview :

We are looking for a Data Platform Engineer with strong backend engineering expertise to build scalable, high-performance data platforms and distributed systems. The ideal candidate should have hands-on experience in developing production-grade backend applications along with designing and maintaining modern data pipelines.


Key Responsibilities :

  • Build and maintain scalable ETL/ELT and data processing pipelines.
  • Develop backend services and APIs using Java (preferred), Python, or Go.
  • Design batch and real-time data pipelines using Spark, Flink, Kafka, and Airflow.
  • Optimize SQL queries, data models, and distributed data systems.
  • Work with cloud platforms (AWS, GCP, or Azure) and container technologies (Docker, Kubernetes).
  • Implement CI/CD, monitoring, logging, and performance optimization.
  • Collaborate with product and engineering teams on scalable system design and architecture.


Required Qualifications :

  • SDE 2 : 3 to 5 years of Backend + Data Engineering experience.
  • SDE 3 : 5.5 to 8 years of Backend + Data Engineering experience.
  • Strong coding skills in Java (preferred), Python, or Go.
  • Excellent SQL and data modeling knowledge.
  • Hands-on experience with Airflow, Apache Spark / Apache Flink, or similar technologies.
  • Experience building scalable backend services and APIs.
  • Good understanding of distributed systems, system design. and scalable architecture.
  • Experience with cloud platforms (AWS, Azure, or GCP).
  • Hands-on experience with Docker and Kubernetes.
  • Strong understanding of CI/CD pipelines.
  • Excellent problem-solving and debugging skills.


Good to Have :

  • Experience with Snowflake, BigQuery, or Redshift.
  • Understanding of Kafka, Kinesis, or Pub/Sub
  • Performance optimization of large-scale distributed systems
  • FinTech or high-scale distributed systems experience.
  • Knowledge of data governance, security, and compliance.


Preferred Candidate Profile :

  • Strong Backend + Data Engineering experience
  • Experience building scalable production systems
  • Strong ownership mindset
  • Good system design knowledge
  • Experience processing millions of events using Kafka/Spark
  • Built APIs supporting data infrastructure
  • Production engineering experience


Interview Process :

  1. Take-home Coding Assignment (48 Hours)
  2. Leadership & Strategy Round (1 Hour)
  3. Technical Depth – Data Engineering & Performance (1 Hour)
  4. Culture & Values Fit (30 Minutes)
Read more
VY SYSTEMS PRIVATE LIMITED
Bengaluru (Bangalore)
6 - 10 yrs
₹5L - ₹20L / yr
Hadoop
PySpark

Dear Candidate,

Thanks for showing interest in the opportunity!!!

As discussed, we have an opening for ETL Developer – Hadoop & PySpark with Mphasis for the Bangalore location – Permanent.


Job Description:

We are looking for an experienced ETL Developer with strong expertise in ETL development, Hadoop, and PySpark. The candidate should have hands-on experience in data processing, building and maintaining ETL pipelines, data transformation, and handling large datasets using Big Data technologies.

Primary & Mandatory Skills:

  • ETL Development
  • Hadoop / HDFS
  • PySpark / Apache Spark
  • Data Extraction, Transformation & Loading
  • SQL and Data Processing

Good to Have:

  • Hive / Spark SQL
  • Data Pipeline Development
  • Big Data Processing
  • Python Programming

Company: Mphasis

Role: ETL Developer – Hadoop & PySpark

Experience: As per requirement

Location: Bangalore

Employment Type: Permanent

Read more
Why apply to jobs via Cutshort
people_solving_puzzle
Personalized job matches
Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.
people_verifying_people
Verified hiring teams
See actual hiring teams, find common social connections or connect with them directly.
ai_chip
Move faster with AI
We use AI to get you faster responses, recommendations and unmatched user experience.
Did not find a job you were looking for?
icon
Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.
companies logo
companies logo
companies logo
companies logo
companies logo
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos