ETL InformaticaSnowflake Engineer
About The Position
As an ETL Informatica/Snowflake Engineer, you will make an impact by designing, supporting, and optimizing data integration and automation processes across enterprise systems. You will be a valued member of our Data Engineering and Operations team, collaborating with cross-functional teams to ensure seamless data flow and operational efficiency. In this role, you will: Provide hands-on support for Informatica PowerCenter, including monitoring, troubleshooting, ETL development, and code deployment. Optimize and manage SQL Server queries, stored procedures, and indexing for high-performance data operations. Work with Snowflake data warehouse for ETL processes and performance tuning. Utilize Azure cloud services to enhance scalability and reliability of data solutions. Implement DevOps automation for file transfers, compression (zip/unzip), scripting, and secure file movement using tools like MoveIt. Manage job scheduling and outage handling using CA Workload Automation Job Scheduler.
Requirements
- Hands-on experience with Informatica PowerCenter for ETL development and troubleshooting.
- Strong proficiency in SQL Server, including query optimization and stored procedures.
- Experience with Snowflake data warehouse and performance tuning.
- Familiarity with Azure cloud services.
- Knowledge of DevOps tools and automation, including secure file movement and scripting.
- Experience with CA Workload Automation Job Scheduler for job scheduling and outage management.
Nice To Haves
- Ability to streamline ETL processes and improve operational efficiency.
- Strong problem-solving skills and experience in automation for large-scale environments.
- Knowledge of best practices in data security and compliance.
- Experience collaborating with cross-functional teams in a fast-paced environment.
Responsibilities
- Provide hands-on support for Informatica PowerCenter, including monitoring, troubleshooting, ETL development, and code deployment.
- Optimize and manage SQL Server queries, stored procedures, and indexing for high-performance data operations.
- Work with Snowflake data warehouse for ETL processes and performance tuning.
- Utilize Azure cloud services to enhance scalability and reliability of data solutions.
- Implement DevOps automation for file transfers, compression (zip/unzip), scripting, and secure file movement using tools like MoveIt.
- Manage job scheduling and outage handling using CA Workload Automation Job Scheduler.
Benefits
- Medical/Dental/Vision/Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term/Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Professional, Scientific, and Technical Services
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
