Services
Prepare yourself
Create job-winning resumes and cover letters
Find a job
Search, apply and prepare for the job you want
Grow your career
Powerful tools for change and promotion
We find the job and apply for you
Find out how
Resume Builder
Quickly build a powerful resume
Resume Examples
See resumes that get interviews
Cover Letter Builder
Show motivation and personality
Cover Letter Examples
Explore the cover letters that work
Expert Writing Services
Hire an expert to write for you
Free Resume Review
Learn if your resume is good enough
Career Advice
Read the blog and learn how to win
CV Builder
Quickly build a powerful CV
Resume Builder
Job Search
Auto Apply
Career Advice
Log In
Sign Up
Back
Jobs
Chennai, TN, IN
AppSierra
Snowflake + Informatica Consultant
Chennai, TN, IN
Contract
6 months ago
Save Job
Apply
Create job alert
Summary
Work Timing: 12 PM to 9 PM
Work Days: 5 Days In-Office (Week)
Location: Only Chennai based candidate
Roles & Responsibilities
Experience – 6 to 12 years
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.
Sql
Required Primary Skills:
Advanced proficiency in SQL for data manipulation and querying.
Experience with complex SQL queries, stored procedures, and performance tuning.
Informatica
Hands-on experience with Informatica Power Center.
Proficiency in designing, developing, and deploying ETL processes using Informatica.
Knowledge of Informatica Cloud Data Integration (CDI) is a plus.
Aws
Strong understanding of AWS services such as S3, Redshift, RDS, Lambda, and Glue.
Experience in setting up and managing data pipelines on AWS.
Familiarity with AWS security best practices.
Snowflake:
Experience with Snowflake data warehouse solutions.
Proficiency in Snowflake SQL and performance optimization.
Knowledge of data loading and unloading using Snowflake utilities.
Secondary Skills
Data Warehousing:
Understanding of data warehousing concepts and methodologies.
Experience with other data warehousing tools and technologies.
Python/Java
Basic to intermediate knowledge of Python or Java for data processing and automation tasks.
Data Visualization
Familiarity with data visualization tools such as Tableau, Power BI, or QuickSight.
Big Data Technologies:
Knowledge of big data technologies like Hadoop, Spark, or Kafka.
DevOps
Experience with CI/CD pipelines and version control systems like Git.
Understanding of containerization tools like Docker and Kubernetes.
How strong is your resume?
Upload your resume and get feedback from our expert to help land this job
Get a free resume review
How strong is your resume?
Upload your resume and get feedback from our expert to help land this job
Get a free resume review
MORE JOBS LIKE THIS
Infosys
Save job
ETL/DWT Test Lead
Chennai, TN, IN
5 days ago
Virtusa
Save job
ETL QA
Chennai, TN, IN
6 days ago
Striim
Save job
Principal Software Engineer - Data Integration
Chennai, TN, IN
6 days ago
Infosys
Save job
ETL Testing
Chennai, TN, IN
7 days ago
See more jobs