45 Bluebyte Technologies Jobs
Informatica Consultant - Snowflake DB (6-12 yrs)
Bluebyte Technologies
posted 1mon ago
Key skills for the job
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.
Functional Areas: Software/Testing/Networking
Read full job description5-8 Yrs