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.