Databricks and Informatica Developer ||Apptad Technology || Bangalore

Skill : DataBricks and Informatica

Experience: 8+ Years
Location: Bangalore
Notice Period: Immedidate

Mandatory: Candidate should understand the ServiceNow database/schema structures.

We are looking for a Databricks & Informatica Developer with strong experience in data engineering, ETL/ELT, and enterprise data integration. The ideal candidate should have hands-on expertise in Databricks and Informatica, along with a good understanding of Enterprise Service Management (ESM) and the ServiceNow data schema.

The candidate will be responsible for developing and maintaining scalable data pipelines, integrating enterprise applications, transforming data, and supporting data flows involving ServiceNow and other enterprise systems.

Key Responsibilities

• Design, develop, and maintain scalable ETL/ELT pipelines using Databricks and Informatica.
• Develop data ingestion and transformation workflows using Databricks notebooks, Spark, SQL, and PySpark.
• Build and maintain Informatica mappings, workflows, transformations, and data integration processes.
• Perform data extraction, cleansing, transformation, validation, and loading across enterprise systems.
• Integrate data from ServiceNow and other enterprise applications into data platforms.
• Understand and work with the ServiceNow schema, including common enterprise service management entities and relationships.
• Work with ServiceNow data such as Incident, Problem, Change, Request, Configuration Item (CI), User, Group, and related records.
• Analyze source-to-target mappings and develop appropriate data transformation logic.
• Implement data quality, validation, error handling, and reconciliation mechanisms.
• Troubleshoot and optimize Databricks jobs, Spark workloads, and Informatica workflows.
• Collaborate with business analysts, ServiceNow teams, data architects, and other technical stakeholders.
• Support production deployments, issue resolution, monitoring, and performance optimization.
• Ensure adherence to enterprise data governance, security, and development standards.
• Document technical designs, data mappings, workflows, and integration processes.

Required Skills

Databricks

• Hands-on experience with Databricks.
• Strong knowledge of PySpark, Spark SQL, and SQL.
• Experience developing Databricks notebooks and data pipelines.
• Understanding of Delta Lake and data transformation concepts.
• Ability to troubleshoot and optimize Spark/Databricks workloads.

Informatica

• Hands-on experience with Informatica ETL/data integration technologies.
• Experience developing mappings, transformations, workflows, and reusable ETL components.
• Strong understanding of ETL/ELT concepts and data integration patterns.
• Experience with data validation, error handling, and performance tuning.

ServiceNow / Enterprise Service Management

• Good understanding of Enterprise Service Management (ESM) concepts.
• Understanding of the ServiceNow data model/schema.
• Familiarity with entities such as Incident, Problem, Change, Request, Configuration Item (CI), User, Group, and Service.
• Understanding of relationships between ServiceNow tables and enterprise service management processes.
• Exposure to ServiceNow data extraction/integration is highly desirable.

Preferred / Good-to-Have Skills

• Experience integrating ServiceNow with enterprise data platforms.
• Knowledge of ServiceNow REST APIs or integration mechanisms.
• Experience with cloud data platforms and modern data architecture.
• Knowledge of data governance, metadata management, and data quality.
• Experience with Git and CI/CD practices.
• Experience working in Agile/Scrum environments.
• Strong troubleshooting and analytical skills.