Cutshort logo
For Employers
a global provider of Business Process Management company logo
Informatica ETL Developer
a global provider of Business Process Management company
Informatica ETL Developer

Informatica ETL Developer at a global provider of Business Process Management company · Bengaluru (Bangalore) · 5 - 8 years · ₹7L - ₹15L / yr · Posted 14 Feb 2022

Jobdost's logo

Informatica ETL Developer

at a global provider of Business Process Management company

Agency job
5 - 8 yrs
₹7L - ₹15L / yr
Bengaluru (Bangalore)
Skills
ETL
Informatica
Data Warehouse (DWH)

Informatica ETL Developer

Job Description

Having experience in Informatica & SQL, Data Migration, Data Load & Management

Having hands on experience on SQL queries.

Having good knowledge and working experience in Informatica ETL tool right from developing ETL to scheduling/ Monitoring it.

Having experience in writing/ debugging complex SQL queries/ stored procedures.

Ability to build, test, and maintain ETL 

Knowledge and Experience in GIT version control application.

Good to have knowledge on PostgreSQL and Amazon S3.

Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse and operational system; Validate that the operational system and data warehouse meets specified requirements.
Analyze and QA data from different sources and ensure that it is properly loaded into our systems
Investigate data quality issues and implement appropriate solutions

Ability to manage tasks and coordinates with other team members and supervisor to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks.

Requirement gathering – frequent interaction with the Data & Technical Managers, Database administrators, Application Users – all belonging to different departments and divisions of to ensure smooth implementation and running of the application
Knowledge of health system functions, terminology and standard coding systems preferred.
 

Qualifications

Bachelor's degree in computer science engineering, mathematics, statistics, science, information technology, Business Administration required Or Master Degree in computer science, computer application or Business Administration preferred

Min 3 years of extensive experience in Informatica ETL design & development, Data Migration, Data Load & Management, SQL Queries, T-SQL programming & testing

Additional information

Good written and verbal communication skills

Good client interaction experience

Good team player

Total Exp – 5 years out of which min 3 years should be relevant.

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

Similar jobs (7)

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
 a leading Data, Analytics & Digital Solutions partner that helps global clients unlock value at every stage of the data and product development
Actively reviewing applications
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
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
Neuvamacro Technology Pvt Ltd
Actively reviewing applications
Karthik Palani
Posted by Karthik Palani
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
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
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
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