15/06 ankita sharma
Technical Recruiter at Pacific

Views:410 Applications:27 Rec. Actions:Recruiter Actions:0

Informatica Developer - ETL/Power Center (8-16 yrs)

Bangalore Job Code: 455894

We have a job opportunity for you with CMMI Level 5 Company

Job title : Informatica Developer

Experience : 8+Years

Position : C2H

Location - Bangalore

Notice Period : 30 days(Max)

Job Details :

1. Design & Develop Enterprise Data Warehousing / Enterprise Data Lake solutions using Informatica PowerCenter

2. 7+ years- experience on building Enterprise Data Warehouse/Data Lake with strong hold on Data Analysis and profiling

3. Translate Business requirements into conceptual, logical, and physical data models

4. Practical understanding of Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables

5. Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation

6. Implement slowly Changing Dimensions - Type I, II & III as per Business need

7. Ability to debug complex SQL queries, reverse engineer and rewrite processes for optimum performance. Advanced knowledge of SQL, including the ability to write stored procedures, triggers, analytic/windowing functions, and tuning.

8. Advanced knowledge of ETL, including the ability to read and write efficient, robust code, follow or implement best practices and coding standards, design/implement common ETL strategies (CDC, SCD, etc.), and create reusable/maintainable jobs

9. Solid background in database systems (such as Oracle and SQL Server) along with strong knowledge of PL/SQL and SQL

10. Create LLD/STM documents, develop, test, and deploy data integration processes

Kindly acknowledge this mail so that we can share your profile to our client.

Name :

Contact Number/ alternate number :

Date of Birth :

CTC :

In Hand Salary :

Expected CTC :

Notice Period : 

Current Location : 

Current Company :

Designation :

Reason For Job Change :

Total Years Of Experience : 

Women-friendly workplace:

Maternity and Paternity Benefits

Add a note
Something suspicious? Report this job posting.