Sr. ETL/ELT Developer II

Useready

8 - 13 years

7 - 12 Lacs

Kolkata Mumbai New Delhi Hyderabad Pune Chennai Bengaluru

Posted:1 day ago| Platform:

Apply

Skills Required

Performance tuning Cloud computing Data modeling XML Javascript Informatica Oracle Adobe JIRA Python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Position Responsibilities:

As a part of the Data Warehouse Team, implement technology improvements to Grand Circle s 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.
Bachelors degree required.

More Jobs at Useready

BI Platform Admin

Mohali, Gurugram, Bengaluru

5 - 8 yrs

INR 12 - 16 Lacs

BI Platform Admin

Mohali

10 - 15 yrs

INR 10 - 15 Lacs

Data Engineer – Snowflake & Python

Pune, Gurugram, Bengaluru

3 - 5 yrs

INR 8 - 11 Lacs

Data Engineer – Snowflake & Python

Mohali, Gurugram, Bengaluru

3 - 6 yrs

INR 9 - 13 Lacs

Data Engineer - Snowflake & Python

Mohali, Pune

3 - 5 yrs

INR 7 - 11 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start JavaScript Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.