Immediate need for a talented Data Engineer IV (Senior Developer Informatica Cloud Migration & Snowflake Optimization). This is a 04+ months opportunity (Remote - EST). Please review the job description below and contact me ASAP if you are interested.
Job Diva ID: 26-09215
Pay Range: $70- $79/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
- (60%) Data Pipeline Migration & Development: Redesign and migrate existing Informatica PowerCenter mappings, workflows, and sessions to Informatica Cloud (IICS) on Azure, ensuring new cloud-based ETL pipelines are efficient, scalable, and maintain data integrity.
- Perform end-to-end development, testing, and validation of migrated components to guarantee quality and reliability.
- (30%) Snowflake Performance Optimization: Leverage Snowflake metadata (e.g. ACCOUNT_USAGE & INFORMATION_SCHEMA views) to identify query performance bottlenecks, optimize warehouse sizing and query design, and implement tuning measures for improved efficiency and cost control.
- Monitor and fine-tune the Snowflake environment for optimal performance and resource utilization.
- (10%) Collaboration & Support Handoff: Work closely with operations partners and cross-functional teams to plan deployment strategies, address operational issues, and ensure a seamless transition of the new data pipelines and Snowflake enhancements to the support team.
- Prepare necessary documentation and knowledge transfer materials for post-migration support and maintenance.
Key Requirements and Technology Experience:
- Key skills: - Must have experience in "Informatica PowerCenter", "Informatica IICS/IDMC", "Snowflake", "SQL", "Azure".
- ETL & Informatica Expertise: 5+ years of experience in data integration / ETL development, with substantial expertise in Informatica PowerCenter (v9.x or higher) for building and maintaining ETL workflows.
- Cloud Migration Experience: Hands-on experience migrating Informatica PowerCenter to Informatica Cloud (IICS/IDMC) on Azure including redesigning ETL pipelines for a cloud-native environment, conducting unit testing, and validating migrated data flows.
- Snowflake Proficiency: Strong proficiency in Snowflake cloud data warehouse, including writing complex SnowSQL queries and using Snowflake s metadata and tools for performance tuning and optimization.
- Snowflake/SnowSQL certification (e.g. SnowPro Core) or equivalent demonstrable experience with Snowflake metadata and query optimization is required.
- Data Management & SQL Skills: Excellent SQL and data modeling skills for data warehouse design and metadata management, with experience in both ETL and ELT patterns.
- Familiarity with performance tuning of SQL queries and ETL processes is expected.
- Communication & Independence: Strong written and verbal communication skills and the ability to work effectively as an individual contributor in a collaborative, team-oriented environment.
- Proven ability to coordinate with stakeholders (e.g. architects, operations/support teams) and work independently to drive projects to completion.
- Azure & Cloud Tools: Experience with Azure cloud services related to data integration and analytics (such as Azure Data Factory, Azure Data Lake Storage, etc.) and general cloud solution architecture experience strongly desired.
- DevOps & CI/CD: Familiarity with DevOps practices for data pipelines, including version control (Git) and CI/CD automation for ETL deployments, is a plus.
- Business Intelligence Tools: Experience with BI/analytics tools (especially Power BI) and understanding of how ETL and data warehouse performance impacts reporting is beneficial.
- Methodologies: Experience working in Agile development teams and comfort with iterative project delivery is preferred.
- Other: Prior experience collaborating with external service providers or globally distributed teams is a plus. Snowflake SnowPro certification (if not already counted in required skills) is a bonus.
Our client is a leading Food and Beverage Manufacturing, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
By applying to our jobs, you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .
Never miss an opportunity! Create an alert based on the job you applied for.
