An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
Posted over 15 days ago, so the role may have closed. Confirm on the employer's page when you apply, or see similar jobs.
Job Description
- The Data Warehouse Team is seeking an experienced individual to contribute to the technology improvements within Grand Circles Enterprise Data Warehouse environment. You will play a crucial role in the implementation of Snowflake with DBT during the Migration from Oracle to a cloud-based data warehousing solution. Collaborating with various teams, you will design, develop, and optimize ELT processes in the cloud-based Data Warehouse environment. Additionally, responsibilities include developing and maintaining Fivetran data pipelines for smooth data extraction and loading into Snowflake. Utilizing Informatica Power Center, you will implement and enhance ETL programs against the Data Warehouse and Adobe Campaign databases. Your role will also involve technical architectural planning, digital data modeling, process flow documentation, and the design and development of innovative Digital business solutions. You will be required to create technical designs and mapping specifications, working closely with technical staff and business constituents to translate Digital business requirements into technical solutions. Estimating workload and participating in an Agile project team approach is essential. Furthermore, you should possess strong communication skills, the ability to lead, manage, and validate the workload for up to 2 offshore developers, and provide on-call support for the Data Warehouse nightly processing. Active participation in both technology and business initiatives is expected.
The ideal candidate should have a minimum of 8 years of experience supporting Data Warehouse & Data related environments. Proficiency in conducting efficient data integration with other third-party tools and Snowflake, hands-on experience with Snowflake development, and familiarity with cloud-based Data Warehousing solutions are required. Advanced experience in Informatica Power Center (5+ years), the ability to code in Python and JavaScript, knowledge of data governance practices, and data security considerations in a cloud environment are essential. Experience in working with Web services using Informatica for external vendor data integration, handling XML data sources, API Calls, performance tuning ETL Jobs, and Database queries is a must. Additionally, advanced skills in Oracle & Snowflake databases, including packages, procedures, indexing, and query tuning (5+ years), along with a solid understanding of Data Warehouse design theory, dimensional data modeling, and cloud computing architecture are necessary. Familiarity with tools such as Azure DevOps, Jira, TFS (Team Foundation Server), or other similar Agile Project Management tools is preferred. The ability to adapt to change with a fast, flexible, cooperative work style and the capability to reprioritize tasks at a moment's notice is crucial. A Bachelor's degree is required for this role.
Mandatory Skills: Informatica Powercenter, Informatica, ETL, ELT, DBT, Fivetran, Snowflake, Data Warehouse, Adobe Campaign, Python, JavaScript, Azure Devops,
Skills
PythonCloud ComputingDevopsJavascriptWeb ServicesXmlApiOracleCloudDeveloperAdobe CampaignELTInformatica PowercenterFivetranData WarehouseAzure DevopsPythonSnowflakeDBTJavascriptETLInformaticaIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
Similar Jobs
View all
New IT / Software Development & Related roles in All India.
One email a day. Unsubscribe any time.
