Snowflake , SQL(4-6Yrs)-Immediate joiner

4 - 6 years

5 - 15 Lacs

Posted:1 week ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Dear Candidate,

Greetings from 3i infotech!!

We rre looking for Snowflakes with 3-6Yrs years of experience. Experience in Banking Industries and a good understanding of Core Banking systems/flow is preferred.

Key responsibilities

  • Support client needs by delivering Snowflake/Azure jobs and frameworks
  • Support client needs by delivering Various Integrations with third party application
  • Merge, Customize and Deploy data model as per client business requirements
  • Experience working with clients throughout various parts of implementation lifecycle
  • Proactive with Solution oriented mind-set, ready to learn new technologies for Client requirements.

Skills and attributes for success

  • Deliver large/medium DWH programmes, demonstrate expert core consulting skills and

advanced level of Snowflake/Azure knowledge and industry expertise to support delivery to clients

Mandatory Requirements

  • Experience in Snowflake/Azure (Development + Admin) and DWH concepts
  • Experience of atleast 2 end to end DWH Implementation experience.
  • Should have experience in using Python codes in Snowflake/Azure.

Auditing, data quality, etc. Should be able to implement reusability, parameterization,

Workflow design, etc.

  • Integrate with multiple Source / Target (through APIs, Webservices etc.)
  • Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
  • Knowledge of data modelling and ETL design
  • Design and develop complex mappings, Process Flow, Load Plans and ETL scripts
  • Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs,

Agents etc.

  • Packaging components, database operations like Aggregate pivot, union etc.
  • Using ETL mappings, error handling, automation, Load plans, Migration of Objects
  • Design and develop complex mappings, Process Flows and ETL scripts
  • Experience of performance tuning of mappings
  • Ability to design ETL unit test cases and debug ETL Mappings
  • Expertise in developing Load Plans, Scheduling Jobs
  • Experience in Data Migration using SQL loader, import/export

Desirable

  • Strong knowledge of ELT/ETL concepts, design and coding
  • Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
  • Experience in designing and developing Snowflake/Azure objects such as
  • Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions. Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
  • Experience in SQL tuning and optimization using explain plan and SQL trace files
  • Partitioning and Indexing strategy for optimal performance
  • Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
  • Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
  • BFSI functional knowledge is an added advantage.
  • The incumbent should be able to drive Snowflake/Azure Infrastructure related developments.
  • Additional knowledge of complex source system data structures preferably in financial services (preferred) Industry and reporting related developments will be an advantage.

Note

Regards,

Kiran

HR

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

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.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
3i Infotech logo
3i Infotech

IT Services and IT Consulting

Navi Mumbai Maharashtra

RecommendedJobs for You

hyderabad, pune, bengaluru

chennai, bengaluru, mumbai (all areas)