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

Informatica ETL Developer
at a global provider of Business Process Management company
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.

Similar jobs (7)
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.
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

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.
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

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.
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.
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









