Talent.com
This job offer is not available in your country.
Senior Data Engineer

Senior Data Engineer

USEReadytiruchirappalli, tamil nadu, in
10 days ago
Job description

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.
  • Create a job alert for this search

    Senior Data Engineer • tiruchirappalli, tamil nadu, in