Senior Data Engineer

Designation : Senior Data Engineer

Location : India(Remote)

Roles and Responsibilities :

As a part of the Data Warehouse Team, implement technology improvements to Enterprise Data Warehouse environment.

In this role, you will be a key contributor to the implementation of Snowflake with DBT, as part of our Migration from Oracle to a cloud-based data warehousing.

Collaborate closely with cross-functional teams to design, develop, and optimize ELT processes within a cloud-based Data Warehouse environment.

Develop and maintain Fivetran data pipelines to ensure smooth data extraction and loading from various source systems into Snowflake.

Implement and enhance ETL programs using Informatica Power Center against the Data Warehouse and Adobe Campaign (Neolane) databases.

Contribute to technical architectural planning, digital data modeling, process flow documentation and the design and development of innovative Digital business solutions.

Create technical designs and mapping specifications.

Work with both technical staff and business constituents to translate Digital business requirements into technical solutions.

Estimate workload and participate in an Agile project team approach.

Proven individual contributor and team player with high communication skills.

Ability to lead, manage & validate workload for up to 2 offshore developers.

Provide on-call support of the Data Warehouse nightly processing.

Be an active participant in both technology and business initiatives.

Position Requirements & Qualifications :

At least 8 years of experience supporting Data Warehouse & Data related environments.

Conduct efficient data integration with other-third party tools and snowflake.

Hands on experience with snowflake development.

Familiarity with cloud-based Data Warehousing solutions, particularly Snowflake.

Advanced experience required in Informatica Power Center (5+ Years).

Ability to code in Python, JavaScript.

Knowledge of data governance practices and data security considerations in a cloud environment.

Experience in working with Web services using Informatica for external vendor data integration.

Experience in working with number of XML data sources & API Calls

Solid experience in performance tuning ETL Jobs & Database queries

Advanced Oracle & Snowflake database skills including packages, procedures, indexing and query tuning (5+ years).

Solid understanding of Data Warehouse design theory including dimensional data modeling

Working experience with cloud computing architecture.

Experience in working with Azure DevOps, Jira, TFS (Team Foundation Server) or other similar Agile Project Management tool.

Ability to thrive in change by having a fast, flexible, cooperative work style and ability to reprioritize at a moment’s notice.

Bachelor's degree required.