AGILAN S.

AGILAN S.

ETL Developer

Chennai , India

Experience: 2 Years

AGILAN

Chennai , India

ETL Developer

6857.15 USD / Year

  • Immediate: Available

2 Years

Now you can Instantly Chat with AGILAN!

About Me

2.8+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica Power center. Extremely skilled and experienced Informatica Developer with a strong...

Show More

Portfolio Projects

Description

Time Warner has 4 divisions namely WB (Warner Bros. Entertainment), HBO (Home Box Office), TBS (Turner Broadcasting System) & TW Corp (Time Warner Corporate). Each division has various benefits program for its employees. The purpose of this project is to outsource the benefits administration function to outside vendors.Benefits Reporting Enterprise Wide and Interfaces to Divisional Payroll, Vendors, and Internal System.Reporting on all employee benefits enrollment and changes. Provide interface for vendor enrollment files and divisional payroll deduction files. Contains employee, dependent, company, plan referential data.Understanding the Business requirements, estimating the efforts and technical specifications.Developed ETL mappings using Informatica Powercenter to implement business requirements.Effectively used parameter files to define mapping and workflow variables.Used debugger effectively to find the flaws in the existing mappings.Involved in enhancements and maintenance activities of the data warehouse.Involved in creating and executing unit and integration test plans.Effectively worked on change requirements and deployed to production within scheduled time.Actively involved in successful deployment of code to LiveProduction Support has been done to resolve the ongoing issuesGather requirements from the business and will create requirement/solution documentCreated high-level designs and architectures directions to be used as inputs to detailed designs.Delivered ETL specifications and Detailed Design by developing Informatica mapping designs, Data Integration Workflows and load processes.Develop and implement new jobs using Informatica workflows within the scheduling environment to support daily, monthly, quarterly, and yearly Business Intelligence needsCreated complex mappings using several transformations like Source Qualifier, Expression, Dynamic lookup, Aggregator, Joiner, Sequence generator, Router, Filter, Stored procedure, Sorter and update strategy transformations.Involved in tuning of existing informatica codes in terms of performance improvementDesign, Develop, Test and Implement GECS jobs to trigger informatica workflowsPerformed Integration, system and regression testing and reported the test results to the usersProvide technical solutions to the Queries or Issues of the Business UsersImplemented the project with Higher Quality and With Strict TimelinesApply knowledge of computer capabilities, subject matter, and symbolic logic, and prepare technical documentation to guide end users

Show More Show Less

Informatica ETL Developer

Contribute

As a developer, developed complex workflows and mappings, also provide valuable automation to reduce human effort through informatica codes.

Description

Our project is all about corporate details, we are develping codes to support and handle them

Show More Show Less

Description

The Project has different Modules of Report such as Finance, Inventory and Maintenance. Time Warner Inc. is a global leader in media and entertainment with businesses in television networks, film and TV entertainment and publishing. TWI uses its industry-leading operating scale and brands to create, package and deliver high-quality content worldwide through multiple distribution outlets. This project provides maintenance support to Time Warners Informatica ETL and Business Objects reporting applications. Support, maintenance, major & minor enhancements and upgrades on Informatica ETL, BO Universes, Reports and Crystal Reports.Maintenance (Change Management, Impact Analysis, Estimation)Production Support (Ticket Prioritization, Analysis, Resolution and Documentation)Focusing on frequent interaction with Business users.Analyzing and collecting the requirements for major enhancementsDesign and Development (Estimation of Time, Coding and Testing)Project Management(Planning, Project Execution, Timely status update, Review, Defect Prevention)Finding quick and feasible solution, analyzing the impact, applying the solution, review the results and document the process.Involved in Performance TuningResolving high priority production issues with short period of time.

Show More Show Less