PNH
Brand Yourself for New Opportunities
  • One-Click Apply to Jobs
  • Set Your Job Alerts
  • Personalized Job Recommendations
  • Resume Builder
  • Give Assessments and Earn Profile Badges
  • Track Your Job Applications
Logo

Snowflake + Informatica Consultant

Pyramid IT Consulting
Logo
Nov 10, 2024
Logo2 Applied

6 -12 Yrs

Experience

Full-time

Job type

Oct 27, 2025

Expiry

Bachelor's Degree

Qualification

2200000 -2700000 INR

per year

Chennai

Location

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

Job Description

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.

Are you hiring?
Where exciting companies meet our developer community.
Get in front of our Talent collective more 20k developers and our audience of more than 100k curious minds in tech