Sr. ETL Developer

Very Good experience in ETL, Informatica, Snowflake, SQL

Development experience in Spark (Mandatory): Spark Architecture, AQE, PySpark Coding, Coalesce and

Repartition functions

Development experience in Hadoop (Mandatory): Hadoop/Hive, Big Data Fundamentals

Development experience in SQL Queries and Hive (Most Important and mandatory): Window functions

and its variations, Complex Query Execution, SQL joins

Experience in using Snowflake, SnowSQL, Snowpipe and PySpark

Data Integration & ETL Development Design, develop and maintain ETL processes

using Informatica PowerCenter

Develop and optimize data mapping

Data synchronization strategies

Data Analysis & Reporting Analyse data requirements and develop data

pipelines to support reporting and analytics.

Create and manage reports, dashboards, and

data visualizations in Salesforce to provide

insights into data trends and performance

metrics.

Data Quality & Governance Implement data validation rules and data

quality checks to ensure the integrity of data

within Salesforce and other integrated

systems.

Develop and enforce data governance

policies and procedures to maintain high data

quality standards.

Testing & Troubleshooting Conduct thorough testing of ETL processes,

data integrations, and data migrations to

ensure accuracy and reliability.

Troubleshoot and resolve data-related issues,

including integration errors and data

discrepancies.

Documentation & Training Document technical specifications, data

integration workflows, and ETL processes.

Provide training and support to end-users and

stakeholders on data management practices

and tools.

Continuous Improvement Stay updated with the latest Salesforce and

Talent Fulfillment Group JD Format

Informatica features and best practices.

Recommend and implement improvements to

data integration and management processes

based on feedback and industry trends.

Certifications, Good to have Informatica PowerCenter or Informatica Cloud

certification.

Salesforce Administrator or Developer