Datastage ETL Developer JobsCafe.com Job Description B] Job Description – Data Warehousing ETL Developer
Job Responsibilities:
Design and develop ETL applications to populate the data warehouse and dependent data marts.
Review and participate in design, development, testing and implementation of the data warehouse applications.
Produce detail technical documentation for all phases of the data warehouse.
Follow software development standards and procedures.
Extensive ETL development experience and ETL tool utilization.
Provide on-going support of existing warehouse as well as continually re-evaluate current processes and techniques for increased efficiency and Maintainability.
Ensure completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements.
Maintain an awareness of existing, new and emerging data warehouse technologies.
Provide detailed estimates of time for each phase of the software development efforts.
Develop test plans and test applications at the unit level.
Proficiently apply appropriate methodologies to support the creation and maintenance of business objects universe and reports to support customer Requirements, ensuring the integrity of data and data feed, identifying relationships between data.
Excellent communication, interpersonal and team building skills.
Minimum Job Qualifications
Experience in design, development, testing and implementation of data warehouse projects using Dimensional Modeling techniques.
Expert in all aspects of managing data warehouse applications: requirement analysis, formulating/evaluating alternatives for data acquisition and access, data quality analysis, operations and training.
Expert in ETL Ascential DataStage, 7.* or 8.* versions.
Skilled with defining and formulating durable and reusable dimensional data models and Star schema data structure designs using ERwin for analysis and reporting.
Strong understanding of data warehouse technologies/best practices: data acquisition (ETL), data quality, managed query/reporting.
Extensive experience in using Relational databases i.e. Oracle 10g/9i, and its utilities (SQL, PL/SQL, SQL* Loader etc). Hands on experience in Writing, testing and implementation of Oracle database triggers, PL/SQL Packages, Procedures and functions. Experience in indexing, SQL performance tuning and optimization techniques.
Experience in writing UNIX Shell scripts.
Knowledge of production support activities.
Knowledge of ERP systems such as Oracle Application and Siebel Application is a plus.
Experience in using one of the Business Intelligence tools (Business Objects experience is a plus).
Preferable Job Qualifications
BS Computer Science or related discipline, or equivalent work experience.
Minimum 4-8 yrs of experience in developing data warehouse applications.
Note:
1. The relevant experience in ETL tool utilization should be atleast 3-4 yrs
2. Currently the existing data warehousing technology in Y! is Data Stage. [so the candidate should be excellent in Data Stage]
3. The candidate should know unit testing [basic level]
4. The candidate’s preparation should be in
1. Ascential DataStage, Business Objects is a plus.
2. Preferably Oracle 10g. Even 9i is okay.
3. Should be very good in SQL technologies.
5. Years of experience can be relaxed for an “outstanding candidate”.
6. Check out the JD fully. There may be some basic questions in other technologies also which are mentioned in the JD.
Regards,
Raju
racle 11i multi-org implementation will be a plus.
Post your Resume in Shine for more Matching Jobs - Click here to Register Today!Desired Profile 1. Ascential DataStage, Business Objects is a plus.
2. Preferably Oracle 10g. Even 9i is okay.
3. Should be very good in SQL technologies.
Competencies
Technical
BI Tools : DataStage, BO Data Integrator, MicroStrategy, Cognos, Cognos PowerPlay Transformer
Middle – Ware : UNIX Shell Scripting
Code Base : SQL, PL/SQL, c
Databases : Oracle, DB2/UDB
Operating Systems : Win. XP, Win. Server 2003, UNIX (AIX and Sun Solaris)
Others : Control – M
Functional
Management and Leadership: Estimation, Work Allocation, Scheduling and Tracking for daily project activities.
Business Domains : Insurance – Automobile
Banking – Retail Card Services
Human Resources
Telecom
Languages
Speak : English, Hindi, Telugu, Tamil, Kannada
Read : English, Hindi, Telugu
Write : English, Hindi, Telugu
Education & Certifications
Electronics and Communication engineering from JNTU, Anantapur in 2005
IBM Certified Solution Developer -- WebSphere IIS DataStage Enterprise Edition V7.5
Experience 4 - 7 Years
Industry Type IT-Software/ Software Services
Role Software Developer
Functional Area Application Programming, Maintenance
Location Bengaluru/Bangalore
Keywords Datastage, PL / SQL, Unix
If you meet the above mentioned criteria, apply online
How To Apply- If you have not registered in Naukri.Com
Click here to Post Your FREE Resume
OR
If you have registered in naukri.com, click here
Yahoo Software Recruits IT Graduates