Search by job, company or skills

This job is no longer accepting applications

Job Description

About the job

Job Description

  • Minimum of 8 years of experience in designing and developing ETL processes using Informatica PowerCenter or Informatica Intelligent Cloud Services (CDI, Data Quality, Data Profiling & Operational Insights).
  • Design, develop, and implement ETL solutions using IICS - CDI to extract, transform, and load data from various sources into the data warehouse.
  • Solid understanding of Informatica Cloud REST APIs.
  • Strong understanding of data warehousing concepts, ETL/ELT frameworks, and best practices.
  • Solid experience with SQL and database technologies such as SQL Server, Oracle, etc. (Preferably Azure Synapse) and distributed file systems: HDFS, ADLS, etc.
  • Develop and maintain ETL/ELT mappings, workflows, and schedules using IICS – CDI (Cloud Data Integration) & other orchestration tools.
  • Ensure data quality, integrity, and consistency by performing data validation, cleansing, and enrichment activities.
  • Strong knowledge of SQL and relational database concepts & Semi-structured data such as XML, JSON.
  • Collaborate with stakeholders to gather requirements and design ETL processes using IICS and Databricks.
  • Develop, test, and maintain ETL workflows that are efficient, scalable, and reliable.
  • Perform data profiling, data mapping, and data modeling to ensure data quality and integrity.
  • Troubleshoot any issues that may arise during the ETL process and provide timely resolution.
  • Work with other teams to ensure that ETL processes integrate effectively with other systems and applications.
  • Create and maintain technical documentation for ETL processes, including process flow diagrams, data lineage, and metadata.
  • Knowledge of Databricks, Spark, and related technologies.
  • Proficiency in Python/Scala to build data processing pipelines.
  • Experience with version control tools such as Git and follow CICD practices.
  • Experience in leading a team of developers.
  • Excellent communication and interpersonal skills.
  • Strong problem-solving and analytical skills.
  • Ability to work in a fast-paced environment and manage multiple projects simultaneously.
  • Experience in Agile software development methodology.

Preferred Certifications

  • Informatica Cloud Data and Application Integration R38, Professional Certification.
  • AZ-900: Microsoft Azure Fundamentals.
  • DP-900: Microsoft Azure Data Fundamentals.
  • DP-203: Data Engineering on Microsoft Azure.
  • Databricks Certified Data Engineer Associate.

More Info

Job Type:
Industry:
Function:
Employment Type:

About Company

Why Chubb Business Services India
Here are some reasons to join us:
• You will be joining a group of diverse and driven professionals trained to succeed in today’s insurance landscape.
• We provide the opportunity to cultivate a robust career; we accommodate your growth and development even as we expect you to make meaningful contributions to our company.
• We offer competitive compensation and benefit programs. We pride ourselves in being a meritocratic company that rewards the best talent.
• We seek to create an inclusive environment where employees of different cultures and backgrounds can thrive.

Our company and culture
Chubb Business Services India focuses on building strong capability in the areas related to technology, CAT modeling, risk management, actuarial services and advanced analytics. The culture we would like to establish would align with the core principles of the organization as outlined below with the desire to transform and grow together.

Our culture reflects a commitment to craftsmanship and as craftspeople, we adhere to certain ideals:

• A Can-Do Attitude – we are optimistic about our future and we have an enthusiasm to serve our customers and business partners with utmost speed and energy. We approach our work with passion – people want to live their lives with meaning. We have a shared vision to build something great – to serve society and leave the world a little better place because we’ve been here.
• Excellence in All We Do – we hold ourselves to exacting standards of technical proficiency. Customers can count on us to pay claims fairly and quickly. Agents and brokers can rely on us for attention to detail and help them build their businesses
• Constant Improvement – we are a learning organization. We are constantly searching for ways to improve our craft. We relentlessly pursue data-driven insights to drive better, smarter decision-making – our portfolio management efforts, for example.
• Global Reach and Local Expertise – we apply our craft locally all around the world. We appreciate differences in culture, history and geography. And this enables us to adapt accordingly to best serve diverse customers, markets and distribution.

Job ID: 107286787

Similar Jobs

Hyderabad, India

Skills:

virtual networks snowflake ARM TemplatesKafkaSpring BootMicroservicesNosqlRDBMSDockerElasticsearchJavaHibernateGraphqlSqlDevopsGitGradleAzure AdSparkRest ApisAzureKubernetesInfrastructure as CodeApplication GatewayEvent HubCI CDHDInsightAKS

Hyderabad, India

Skills:

UnixOracle Sql ServerToscaPerlUcdDatabricksInformaticaSqlHarnessGitHub ActionsTeradata

Hyderabad, India

Skills:

Ab InitioGrafanaLinuxOcpPostgreSQLSQL ServerUnixSplunkAutosysDynatraceGoogle CloudAppdynamicsshell scriptingAWSPrometheusOraclePythonKubernetesBashAzureDockerControl-MTeradataGDEKornShellMetadata HubConduct IT

Hyderabad, India

Skills:

SqlKubernetesKafkaClickHouseAI coding assistantsJavaScript or TypeScript with React or AngularObservability tooling

Hyderabad, India

Skills:

AlgorithmsCGcpdata structuresAzureVirtualizationCloud ComputingAWSTeradata databaseAI proficiencySQL JoinsQuery Optimization techniques

Beware of Scammers

We don’t charge money for job offers