22/05 Vinod
HR Recruiter at ADi Consultancy Services

Views:270 Applications:12 Rec. Actions:Recruiter Actions:1

Module Lead - ETL Developer (8-10 yrs)

Mumbai Job Code: 66679

We have Urgent opening for Module Lead - (ETL Developer)

JD for Module Lead - (ETL Developer)

Position : Module Lead - (ETL Developer)

Experience : 8 to 10 Yrs

Job Location : Mumbai

Educational Qualification:

1. Any Engineering Graduate i.e BE / B.Tech / BCA / MCA / M.Tech / ME

Technical skills -

- Must have 4+ years experience working in MS SQL Server.

- Extensive knowledge of T-SQL language.

- Knowledge of stored procedure writing, triggers, query optimization, and indexes.

- Create complex analytic queries on large data sets.

- Knowledge of database performance tuning techniques.

- Must have 3+ years experience working on Informatica ETL.

- Strong experience in the Analysis, design, development, testing and implementation of Business Intelligence solutions using data warehouse and ETL.

- Strong experience in Extraction, Transformation and loading (ETL) data from various sources into data warehouse and data marts using informatica power center.

- Experience building ETL architecture and source to Target mapping to load data into data warehouse.

- Creating mapping documents to outline data flow from sources to targets.

- Extracted the data from the flat files into the staging area and populated onto data warehouse.

- Experience working in various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

- Experience in creating and scheduling the batches.

- Experience in various transformations like Source Qualifier, Joiner, Lookup, Filter, Expression and Update Strategy.

- Tuned the Informatica mappings for optimal load performance.

- Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.

- Experience of migrating data to Salesforce would be an added advantage

Experience

- Around 8-9 years of IT experience.

- Past experience with Tier 1/Tier 2 IT companies will be an added advantage

If you interested please forward your CV.

Mention Your:
CTC :
Notice Period:

ETL OR Informatica OR Cognos Tool Exp:

This job opening was posted long time back. It may not be active. Nor was it removed by the recruiter. Please use your discretion.

Women-friendly workplace:

Maternity and Paternity Benefits

Add a note
Something suspicious? Report this job posting.