About the Role:
* We are seeking a highly skilled Senior Data Engineer to lead our ETL processes using Informatica Cloud and SSIS.
* As part of our team, you will be responsible for managing data movement between SQL Server, Snowflake, and S3 storage to create centralized, reusable datasets.
* You will also develop, optimize, and triage MS SQL stored procedures, views, and existing code based on evolving business requirements.
* In addition, you will ingest data from various sources including SQL databases, CSV files, and APIs.
* You will work closely with stakeholders to design and build datasets and reports in Tableau.
* Your expertise in ETL development with Informatica Cloud and SSIS will enable us to drive meaningful insights through our reporting initiatives.
Key Responsibilities:
* Design and implement efficient ETL processes using Informatica Cloud and SSIS
* Develop and maintain high-quality MS SQL stored procedures, views, and existing code
* Ingest and process data from diverse external sources, including SQL databases, CSV files, and APIs
* Collaborate with stakeholders to design and build datasets and reports in Tableau
* Lead reporting initiatives, partnering with business users to deliver actionable insights
Requirements:
* Strong expertise in ETL development with Informatica Cloud and SSIS
* Advanced SQL skills across MS SQL Server and Snowflake
* Experience with S3 storage integration for data centralization
* Proven ability to ingest and process data from diverse external sources
* Proficient in Tableau report development and stakeholder engagement
What We Offer:
* A dynamic work environment with opportunities for growth and development
* The chance to work on cutting-edge ETL initiatives using the latest cloud technologies