Etl Developer

Job Summary Sr.

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

About Mphasis

Mphasis applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to Mphasis and is reflected in the Mphasis’ Front2Back™ Transformation approach. Front2Back™ uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. Mphasis’ Service Transformation approach helps ‘shrink the core’ through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. Mphasis’ core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients.