Ashok Kumar

Experience

• 

  Wipro

  Nov 2010 - Nov 2013

  Etl Developer

  Responsibilities include designing the documents which is based on the requirement specifications. Done extensive testing and wrote queries in SQL to ensure the loading of the data. Perform unit testing at various levels of the ETL. Developed and implemented the coding of Informatica Mapping for the different stages of ETL. Fixed the invalid mappings and troubleshoot the technical problems of the database. Debug the sessions by utilizing the logs of the sessions. Developed and implemented the UNIX shell script for the start and stop procedures of the sessions. Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure(plsql), packages, triggers, UNIX. Managed and compile documentation for all ETL processes. Created detailed process flow designs and drafts high-level Standard Operation Procedures. Performed Informatica Administration tasks. Performed tuning for PL and SQL procedures, Views, and Informatica objects. Designed and implements the error handling strategy for ETL team. Monitored data warehouse month-end loads to ensure successful completion.Equipped with good knowledge on Banking & financial solutions since was working in Investment banking platform.Worked on EOL(End of Life) migration activities.Worked on complete software development life cycle (SDLC) starting from information strategy planning, requirement analysis, design, development, coding, testing, debugging and implementation to production support. Show less

• 

  Wipro

  Feb 2015 - Sept 2016

  • Extensive experience with Banking & Finance and Securities domain.• Expertise in Informatica PowerCenter 9.x/8.x/7.x extracting data from Oracle, DB2 and Sybase databases.• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources• Strong ability to analyze source systems and business requirements, identify and document business rules, design Informatica solution for the business requirements.• Extensively worked in development of Informatica Mappings and Informatica Workflows.• Experience with Informatica Advanced Techniques – Dynamic Caching, Parallel Processing to increase Performance throughput.• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.• Experience in creating and using Stored Procedures, Functions, Triggers, Views, Synonyms, and Packages in Oracle 11 g/10 g/9i.• Involved in Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.• Skilled in Unix and knowledge of Shell Scripting.• Experience in scheduling of ETL jobs using Autosys and Crontab.• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.• Experience in the full-cycle software development including requirements gathering, prototyping, and proof of concept, design, documentation, implementation, testing, maintenance and production support.• A highly motivated self-starter and a good team-player with excellent verbal and written communication skills. Show less

  • Senior Etl Developer

    Nov 2013 - Sept 2016

  • Senior Etl Developer

    Feb 2015 - Jul 2015
• 

  Wells Fargo

  Sept 2016 - May 2017

  Technology Specialist

  Extensive experience with Banking & Finance and Securities domain.• Expertise in Informatica PowerCenter 9.x/8.x/7.x extracting data from Oracle, DB2 and Sybase databases.• Extensive experience in Extraction, Transformation and Loading of data using Informatica from heterogeneous sources• Strong ability to analyze source systems and business requirements, identify and document business rules, design Informatica solution for the business requirements.• Extensively worked in development of Informatica Mappings and Informatica Workflows.• Experience with Informatica Advanced Techniques – Dynamic Caching, Parallel Processing to increase Performance throughput.• Extensively involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading. Show less

• 

  ITC Infotech

  May 2017 - Dec 2021

  Lead Consultant
• 

  Fidelity International

  Dec 2021 - now

  Technical Specialist