Onsite Lead/ Informatica Admin Resume Example

CATMAN is an Online Booking and Movie distribution application for 20th Century FOX which tracks movie releases in theatres across FOX Territories based on which invoicing and Receivables are managed. OCEANS is a Hollywood Software's TDS product. It provides a centralized repository for all theatrical distribution information creating a natural, integrated flow from Planning to Booking, to Gathering and Reporting Grosses, to Billing and Managing Receivables. The OCEANS system will replace the distribution functionality of the current theatrical distribution systems of territories like Mexico, Australia, Spain, Japan, etc.

Owing to performance effectiveness and functional abilities of Netezza, the data was migrated to Netezza from Teradata, the conversion had to be done keeping on mind and in turn manage with its acknowledgements. Custom built ETL processes will provide Interfacing between Oceans and other internal and external theatrical sources/systems.

ROLES & RESPONSIBILITIES

• Analyze the ETL functionalities that were used in Teradata
• Use the Informatica Data Integration platform to extract, transform, and load data
• Develop Informatica mapping designs, suitable to Netezza
• Develop Data Integration Workflows and load processes
• Ensure adherence to locally defined standards for all developed components
• Perform data analysis for both Source and Target tables/columns
• Provide technical documentation of Source and Target mappings
• Worked in Informatica Admin Console to perform administration activities.
• Support the development and design of the internal data integration framework
• Participate in design and development reviews
• Work with System owners to resolve source data issues and refine transformation rules
• Write and maintain unit test cases

Walmart.com is a lot like your neighborhood Wal-Mart store. Wal-Mart features a great selection of high-quality merchandise, friendly service and, of course, Every Day Low Prices. Founded in January 2000, Walmart.com is a subsidiary of Wal-Mart Stores, Inc. The headquarters is on the San Francisco Peninsula near Silicon Valley, where they have access to the world's deepest pool of Internet executive and technical talent.

ROLES & RESPONSIBILITIES 

• Analyzed the source data
• Extracted data from the OLTP system and loaded into the Data warehouse.
• Cleansed the data according to the business requirement and loaded into the Datamart
• Developed Informatica mapping for the ETL process
• Worked in Informatica Admin Console to perform administration activities.
• Tracked and resolved the issues faced in various phases of the project
• Performed Unit Testing and ensured the quality of the data
• Analyzed the report specification and generated reports using Business Objects.

OCEANS is an Online Bookings and Movie distribution Application for 20th Century FOX which tracks movie releases in theatres across FOX Territories based on which invoicing and Receivables are managed. OCEANS is a Hollywood Software's TDS product. It provides a centralized repository for all theatrical distribution information creating a natural, integrated flow from Planning to Booking, to Gathering and Reporting Grosses, to Billing and Managing Receivables. The OCEANS system will replace the distribution functionality of the current theatrical distribution systems of territories like Mexico, Australia, Spain, Japan, etc.

Owing to Oceans functionality, it is necessary to provide up-to-date information from various systems to the application and in turn manage with its acknowledgements. Custom built ETL processes will provide Interfacing between Oceans and other internal and external theatrical sources/systems.

• ROLES & RESPOSIBILITIES


• Analyze the source data
• Use the Informatica Data Integration platform to extract, transform, and load data
• Develop Informatica mapping designs
• Develop Data Integration Workflows and load processes
• Ensure adherence to locally defined standards for all developed components
• Perform data analysis for both Source and Target tables/columns
• Provide technical documentation of Source and Target mappings
• Worked in Informatica Admin Console to perform administration activities.
• Support the development and design of the internal data integration framework
• Participate in design and development reviews
• Work with System owners to resolve source data issues and refine transformation rules
• Write and maintain unit test cases