• Around 7 years of experience in the IT / Software Industry possessing strong knowledge in data warehousing technology with skill set of Informatica and Oracle • Experience in all the phases of Data warehouse life cycle involving design, development & analysis and testing of Data warehouses using ETL • Capable of analyzing the business requirements and creating functional design documents to design mapping, mapplet, workflow and sessions in Informatica 6.0/7.1 • Experience in creating mapping, reusable transformations and mapplet using Firstlogic and performing Firstlogic administration • Developed scheduling jobs in Informatica and monitored the same using the workflow monitor • Practical understanding of the Database schemas like Star Schema and Snow Flake Schema used in relational and dimensional modelling. • Strong knowledge of Entity-Relationship concept, Facts and dimensions tables and Slowly changing dimensions • Six sigma certified (Green Belt Certification) • Experience in writing Unix Shell scripts • Handling of database management activities for new releases using Oracle • Experience in writing database scripts such as SQL queries ,PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized views and Triggers • Strong knowledge in the Software Development Life Cycle working in CMM Level 5 Company. • Efficiently handling the data fixes and other support work on time • Quick learning, sound communication, interpersonal skills and client interaction abilities complement the technical abilities • Excellent analytical/ communication skills and good team spirit • Strong commitment towards quality, experience in ensuring compliance to coding standards and review process
SKILLS
Informatica Tools: Informatica 6.0 / 7.1 (Designer, Server Manager, Workflow Monitor, Repository Manager), Other Tools: TOAD, First logic, Informatica Match Consolidate, Informatica ACE, Informatica IACE, Guide Post Languages: C, C++, Java, Visual Basic, SQL/PL-SQL Database: Oracle Operating Systems: Windows, Unix
EDUCATION
Master of Science in Information Technology.
Certifications
See above
CONTACT DETAILS
You must be logged in and have a current resume access subscription. Login or Register »