Informatica Consultant - Snowflake DB

Experience : 6 to 12 years Job Description : Primary Skills : SQL : - 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 PowerCenter. - 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. 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. Qualifications : - Bachelor's degree in Computer Science, Information Technology, or related field years of experience in data engineering or related roles. - Strong problem-solving skills and attention to detail. - Excellent communication and teamwork skills. Key Responsibilities : - Data Integration : Design and develop ETL processes using Informatica to load data into Snowflake from various sources. - Snowflake Management : Optimize Snowflake databases, ensuring data integrity, security, and efficient storage. - Data Modeling : Collaborate with data architects to design and implement scalable data models in Snowflake. - Performance Tuning : Monitor and enhance the performance of ETL processes and Snowflake queries. - Data Quality : Implement data validation and quality checks to ensure accurate data processing. - Documentation : Create and maintain documentation for ETL processes, data models, and integration workflows. - Collaboration : Work closely with data analysts, business stakeholders, and IT teams to understand data requirements and provide support. - Troubleshooting : Identify and resolve data-related issues and bottlenecks in the ETL process. Qualifications : - Bachelor's degree in Computer Science, Information Technology, or a related field. - Proven experience with Snowflake and Informatica, including designing and implementing ETL workflows. - Strong SQL skills and experience with data warehousing concepts. - Familiarity with cloud platforms (e.g., AWS, Azure) is a plus. - Excellent problem-solving skills and attention to detail. - Ability to work independently and collaboratively in a team environment. Skills : - Proficiency in Informatica PowerCenter or Informatica Cloud. - Experience with Snowflake data warehouse architecture and SQL. - Knowledge of data modeling techniques and data governance best practices. - Strong communication skills, with the ability to convey technical concepts to non-technical stakeholders. (ref:hirist.tech)

Location: chennai, IN

Posted Date: 11/21/2024