I am working on Informatica 9 & 10 as ETL Developer & Support Engineer and also in few ETL migration projects, where I grabbed huge knowledge and faced all kind of possible scenarios that could allow me to work in an efficient way in stipulated time to give deliverables with Zero errors.I have worked on implementing concepts like SCD, Incremental load logic using various components available. I have also done performance tuning on various scenarios by tweaking buffer & block size, by developing efficient mapping, by using Pushdown Optimisation & Partitions to improvise the performance.
Regards to SQL, I have wrote SQL logics for complex mappings for a better performance. And also in one of the projects, we executed ETL through Shell scripts where I have developed SQL codes, based on which the complete ETL runs. I have written SQL using advanced concepts such as Common Table Expressions, Analytical functions, Pivoting, hierarchical queries etc.,
On database administration side , I have worked on relational databases like SQL server & Oracle, on creating users, authorising permissions, creating all databases objects like tables, views, indexes, materialised views, procedures etc.,
With these experiences, I would able to complete this project on stipulated time with maximum accuracy.