Lead Technical Consultant
Current- Working with Enterprise team to build overall architecture and build data models.- Implement projects requiring CDC (Change Data Capture), PowerExchange, Data Quality analysis, Data profiling, Data Cleansing and metadata management - Work with business to understand Business Requirements and prepare Technical Specification, Data Modeling, Design document, data flow diagram, use cases and test approach documents.- Understand requirements from Functional and Technical specifications and help team to understand the business use cases.- Design and construct ETL (Extract, Transform, Load) processes on Oracle Exadata/Teradata/SQL Server using Informatica. - Solve complex user requirements using Informatica transformations. Apply different approaches and constructing best possible solution for underline business requirements.- Create Informatica mappings using transformations such as the Source qualifier, HTTP, Java, Web Service Consumer, Normalizer, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy.- Identify performance bottlenecks and optimize respective databases and processes for performance improvement. Experienced in analyzing query logs and explain paths. - Preparing technical business solution strategy/approach using ETL technologies and present it to Design Review Board for their approvals.- Modeling and Implementing FACT tables and Slowly Changing Dimension(SCD2) tables.- Providing Support to production job down scenarios and resolving issues quickly.
