HR Recruiter at ADi Consultancy Services
Views:270 Applications:12 Rec. Actions:Recruiter Actions:1
Module Lead - ETL Developer (8-10 yrs)
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
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
- 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.
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.