Logo
Snowflake + Informatica Consultant

Full-time

icon

Verified

Appsierra Group
Logo

4.4

Logo

33 Applied

Logo
back

Chennai, Tamil Nadu, India

student

Bachelor's Degree

student

2200000 - 2700000 Lakh / year INR

student

6 - 12 Yrs

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.

Key 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

Company Details

company

Appsierra Group

People & Technology Combined

About

company

Noida, Uttar Pradesh, India

linkedintwittertwitter