Snowflake + Informatica Consultant

Chennai, India

42 applied

Full-time

₹2200000 - 2700000 Lakh/year

6-12 yrs

Posted on: Sep 7, 2025

Skills

Informatica

Informatica Powercenter

Data Visualization

Data Warehousing

Big Data

Snowflake

Aws Glue

Aws Lambda

Aws Cloudwatch

Aws Services

Ci/cd Pipelines

Sql

Docker

Kubernetes

Devops

Work Timing: 12 PM to 9 PM

Work Days: 5 Days In-Office (Week) 

Location: Only Chennai based candidate

Experience – 6 to 12 years

Roles & Responsibilities:

  • Design, develop, and maintain ETL processes using Informatica.

  • Build and manage data pipelines on AWS and Snowflake.

  • Write complex SQL queries to extract, transform, and load data.

  • Optimize and tune SQL queries for performance.

  • Collaborate with data analysts and business stakeholders to understand data requirements.

  • Ensure data quality and integrity across various data sources.

  • Implement data security best practices.

Required Primary Skills:

SQL:

  1. Advanced proficiency in SQL for data manipulation and querying.

  2. Experience with complex SQL queries, stored procedures, and performance tuning.

    Informatica:

    1. Hands-on experience with Informatica Power Center.

    2. Proficiency in designing, developing, and deploying ETL processes using Informatica.

    3. Knowledge of Informatica Cloud Data Integration (CDI) is a plus.

    AWS:

    1. Strong understanding of AWS services such as S3, Redshift, RDS, Lambda, and Glue.

    2. Experience in setting up and managing data pipelines on AWS.

    3. Familiarity with AWS security best practices.

      Snowflake:

    1. Experience with Snowflake data warehouse solutions.

    2. Proficiency in Snowflake SQL and performance optimization.

    3. Knowledge of data loading and unloading using Snowflake utilities.

Secondary Skills:

Data Warehousing:

  1. Understanding of data warehousing concepts and methodologies.

  2. Experience with other data warehousing tools and technologies.

    Python/Java:

    1. Basic to intermediate knowledge of Python or Java for data processing and automation tasks.

    Data Visualization:

    1. Familiarity with data visualization tools such as Tableau, Power BI, or QuickSight.

    2. Big Data Technologies:

    3. Knowledge of big data technologies like Hadoop, Spark, or Kafka.

      DevOps:

      1. Experience with CI/CD pipelines and version control systems like Git.

      2. Understanding of containerization tools like Docker and Kubernetes.

Appsierra Group

Noida, Uttar Pradesh, India

People & Technology Combined