ETL Developer - Informatica Powercenter, Snowflake, SQL
Posted Updated
Description
About the Role
The ETL Developer will be instrumental in driving data integration and transformation initiatives. This position requires expertise in various tools and technologies to ensure the effective extraction, transformation, and loading of data into our data warehouse.
What You'll Do
- Design, develop, and maintain ETL processes utilizing Informatica PowerCenter and Snowflake.
- Collaborate with data architects and business analysts to gather data requirements and translate them into actionable technical specifications.
- Construct complex SQL queries for efficient data extraction and manipulation.
- Implement automation and optimize processes using Python and Shell scripting.
- Monitor, troubleshoot, and enhance ETL processes to guarantee data quality and integrity.
- Apply CI/CD methodologies with GitLab for version control and deployment processes.
- Manage data workflows and scripts within Unix/Linux environments.
- Utilize Automic (UC4) for job scheduling and automation tasks.
- Engage with SQL Developer, Toad, and Tora for database management activities and performance optimization.
What We're Looking For
- Proficient in Informatica PowerCenter and Snowflake technologies.
- Strong SQL skills for effective data manipulation and querying capabilities.
- Experience in Python programming and Shell scripting for process optimization.
- Familiarity with Unix/Linux operating systems for managing workflows.
- Solid understanding of ETL methodologies and best practices related to data integration.
- Practical experience with GitLab CI/CD processes for continuous integration and deployment strategies.
- Knowledge of job scheduling tools, specifically Automic (UC4).
- Experience working with SQL Developer, Toad, and Tora for comprehensive database management functions.
Skills
Sign in to read and join the discussion.