About the role
Job Description
Job Summary – Sr. ETL Developer (Data Analyst)
Exp - (5-10 yrs).
Location: Bangalore
Technical Skills:
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 certification
is preferred.