Associate Technical Consultant
teradata india pvt ltd
Total years of experience :14 years, 3 Months
• Understanding the Functional Requirement, developing ETL processes.
• Understand the received DA Specifications.
• Identifying and logging issues, if any with respect to DA Specifications.
• Development of the Informatica mappings, Bteq scripts, Fast Export scripts and TPT scripts for the DA Specifications received.
• Unit testing of the developed Informatica mappings, Bteq scripts, Fast Export scripts and TPT scripts.
• Review of the developed Informatica mappings, Bteq scripts, Fast Export scripts and TPT scripts.
• Performed end to end testing of developed objects and reported defects using remedy.
• Kept track of execution, Unit test cases and defects for smooth functioning.
• Developing mapping and workflow objects in informatica
• Creating Transformations and Mappings using Designer Tool set of Informatica.
• Performance tuning using push down optimization technique at informatica level.
• Error handling and debugging using Informatica Debugger.
• Preparing Unit Test Specification Requirements.
• Perform daily job of batch monitoring.
• Analyze business queries (raised through tickets and incidents) and provide strategic resolutions to clients.
• Analyze Informatica objects for performance improvements ( Using PDO).
• Willingly learnt Control-M Scheduler tool basics with the desire to compete with the team standards and project targets.
• Responsibly completed project deliverables with optimized and accurate practices maintaining quality and timeline
• Deep analysis of client requirements with few additional reformatting requirements.
• Proper documentation of ETL Runbook to enhance usability of Application Support guide.