Expertise in data warehouse Design, Development and Implementation and Data migration projects using IBM Websphere 7 & 8 Good understanding of Datastage Designer and Director – Strong knowledge of Datastage fundamentals like ‘Server/Parallel Job’, ‘Sequence’ etc. Extensively worked in Data Extraction, Transformation and Loading from Source to Target System using Datastage Analyze, Design, implement and lead development processes against high-volume data sources. Deep knowledge of database principles and of dimensional and normalised modelling concepts. Proven experience in logical and physical and dimensional data modelling, physical database design and performance optimisation.
Strong Experience in Star-Schema Modeling, Snowflake Schema Modeling, Understanding of the concept of Data Marts In-depth knowledge of different stages of Datastage like transformer, lookup, joiner etc. Good knowledge of Data Warehousing fundamentals and the ability to analyze a data model– should have good understanding of facts and dimension tables and different data models.
Should have thorough knowledge of unix shell scripting and different commands in unix. Should have good knowledge of Autosys scheduler Running unix script thorough autosys.
Fact, dimension tables and Data modeling using Erwin tool. Strong experience with DataStage Enterprise Edition/Parallel Extender (Orchestrate) for parallel processing as part of ETL conversion process integrating multiple source systems.
Experienced in integration of various data sources like Oracle, DB2, SQL, XML, Flat files Worked extensively on SQL, PL/SQL, Packages, Procedures, Functions and Triggers. Experience in Performance Tuning of SQL statements, stored procedures and functions.
Actively involved in using Business Objects, Control, Quality Center and Quality stage. Strong analytical, diagnostic and troubleshooting skills and ability to work in a dynamic, team-oriented environment.
In depth understanding of systems development lifecycle (SDLC), application development Methodology and enterprise data warehouse and BI principles. Requirements Infosphere Datstage Lead Experience: 5 - 10 Years Industry Type: IT Software, Software Services Role: Team Lead/ Technical Lead Functional Area: DBA, Datawarehousing Education: UG - Any Graduate - Any Specialization PG - Post Graduation Not Required Compensation: INR 8,00,000 - 12,00,000 P.
A Location: Hyderabad / Secunderabad, Pune Keywords: Datstage Lead, ETL Datastage, Infosphere Datastage, IBM Websphere Contact: Survey # 14, 5th Floor Jayabheri Silicon Towers Madhapur Road, Kondapur HYDERABAD,Andhra Pradesh,India 500032 Telephone: 91-40-39991999 Email: [Click Here to Email Your Resum] Website: http://www.semanticspace.
com
(less)
