Now you can Instantly Chat with OMKAR!
About Me
Technically sophisticated IT professional with 6 years of experience in Project Development Life Cycle, Design, Development, Implementation, Testing and Supporting for BigData ,Data Warehousing & Data Integration Currently working as Sr. BigData Deve...nd Supporting for BigData ,Data Warehousing & Data Integration Currently working as Sr. BigData Developer with UBS. Proficient in the use of applications like ETL Technologies- Informatica BDM ,Informatica Power Center, IDQ ,Informatica Analyst, Informatica DVO, Oracle PL/SQL and DB Tools. BigData- Hive,Impala,Spark,HDFS Familiar in all the phases of Product Life Cycle Management from migration of application from one version of software to another Experience with CI/CD Applications: GitHub,Jenkins. Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Flat Files, Mainframe Files, XML Files, Excel Files, Oracle, Sybase, SQL Server, Hive and Impala. Excellent work exposure in Automating the Informatica Processes by Informatica Scheduler, and Autosys Automation Tool with JIL Programming. Adept Project Leader at empowering team members with information and required tools for smooth flow of project Exceptional problem solver with expertise in resolving critical issues by coordinating with multiple application groups Successfully worked on Projects involving ETL with Hive, Informatica BDM.
Show MorePortfolio Projects
Contribute
Role and responsibilities: As a team leader need to verify requirement within the architecture stability. Manage team of 4 people.
Description
Primarily responsible for development of data migration framework to migrate data from 40+ legacy application into strategic platform
Work with team at multiple locations to support development and testing activities
Work with tool Vendor on best practices definition for implementation
Define data quality strategy and data integration strategy for implementation
Define data reconciliation strategy
Co-ordinate dry run and dress rehearsal
Description
Primarily responsible for developing mapplet with business logic which are then used as rules in Informatica Analyst.
Develop Profile and scorecard with reflection of quality of data.
Run Cognos report on results of profile and scorecard.
Work with team at multiple locations to support development and testing activities
Work with tool Vendor on best practices definition for implementation
Define data quality strategy and data integration strategy for implementation
Description
The main purpose of WMA CTB is to enhance existing wealth management product functionality and identifying new business opportunities. As part of the UBS WMA CTB project I have involved into the below modules. Liabilities Prospecting: Focused on New product campaigning. Bureau Trigger Management: Management of data send/receive to/from Credit Bureaus. Mortgage Process Redesign: Re-structuring the Mortgage data collection process.
Show More Show LessContribute
Designed the flow of source mainframe to ODS Implemented ETL Audit Framework on top of ODS Generated report for business users with ETL Statistics.