Job Title: Senior Data Engineer
A senior data engineer will have the opportunity to work with a well-established team that focuses on transferring and provisioning data across various platforms. This role involves working on meaningful ETL initiatives using the latest cloud technologies, offering flexibility through a hybrid work model.
Key Responsibilities:
* Develop and implement efficient data pipelines using Informatica Cloud and SSIS.
* Maintain data movement between SQL Server, Snowflake, and S3 storage to create centralized datasets.
* Design and optimize MS SQL stored procedures, views, and existing code based on evolving business needs.
* Ingest data from various sources including SQL databases, CSV files, and APIs.
* Build datasets and reports in Tableau by collaborating closely with stakeholders.
* Define reporting requirements and deliver actionable insights to business users.
Requirements:
* Expertise in ETL development with Informatica Cloud and SSIS is required.
* Advanced SQL skills across MS SQL Server and Snowflake are necessary.
* Experience with S3 storage integration for data centralization is preferred.
* Ability to ingest and process data from diverse external sources is essential.
* Proficiency in Tableau report development and stakeholder engagement is required.