Informatica Lead Consultant

Innova Solutions

7 - 12 years

15 - 30 Lacs

Hyderabad

Posted:3 months ago| Platform:

Apply

Skills Required

Unix Powercenter Snowflake Oracle Informatica Powercenter

Work Mode

Hybrid

Job Type

Full Time

Job Description

Role & responsibilities : Candidate should be Immediate Joiner Lead Level Exp Must Informatica Powercenter, Snowflake, Oracle, Unix are Mandatory Skills Only Hyd (GAR-Kokapet) location (Hybrid - Mode) Key Responsibilities : •Design and implement scalable data storage solutions using Snowflake •Writing SQL queries against Snowflake, developing scripts to do Extract, Load, and Transform data. •Write, optimize, and troubleshoot complex SQL queries within Snowflake •Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, Time travel, Cloning, Optimizer, Metadata Manager, data sharing, stored procedures and UDFs. •Develop and maintain ETL processes using Informatica PowerCenter •Integrate Snowflake with various data sources and third-party applications •Experience in Data Lineage Analysis, Data Profiling, ETL Design and development, Unit Testing, Production batch support and UAT support. •Involve SQL performance tuning, Root causing failures and bifurcating them into different technical issues and resolving them. •In-depth understanding of Data Warehouse, ETL concepts and Data Modelling. •Experience in requirement gathering, analysis, designing, development, and deployment. •Good working knowledge of any ETL tool (preferably Informatica powercenter, DBT) •Should have proficiency in SQL. •Have experience in client facing projects. •Have experience on Snowflake Best Practices. •Should have experience working on Unix shell scripting. •Good to have working experience in python

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific 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.

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.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Innova Solutions

IT Services and IT Consulting

Atlanta Georgia

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Informatica Lead Consultant