Application Support Analyst - IPC

Do you have experience in IT Services? Are you passionate about the chance to bring your experience to a world- class company that is market-leading for both content and technology? If yes, we are looking for you!

Join our team in Mexico Ctiy, and be part of our Service Management team. Thomson Reuters is transforming how it supports the technology Products and Platforms delivered to customers and employees.

The Service Management function is transforming into a truly global, data- and standards-driven organization, employing best-in-class tools and practices across all disciplines of Technology Operations, including service monitoring, support and incident response, automated ops, change and configuration management as well as supplier/vendor and asset management. This will drive ever-greater stability and consistency of service across the technology estate as we drive towards optimal Customer and Employee experience.

About the role

In this opportunity as an Application Support Analyst - IPC, you will:

• 5 YOE experienced Informatica Developer and Support will be responsible for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Have Knowledge in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
• Should have experience in creating ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
• Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
• Should be able to perform source system analysis as required.
• Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
• Implements versioning of the ETL repository and supporting code as necessary.
• Develops stored procedures, database triggers and SQL queries where needed.
• Implements best practices and tunes SQL code for optimization.
• Loads data from SF Power Exchange to Relational database using Informatica.
• Works with XML's, XML parser, Java and HTTP transformation within Informatica.

About You

You're a fit for the role of Application Support Analyst - IPC if your background includes:

• Experience in Integration of various data sources like Oracle, SQL Server, DB2 and Flat Files in various formats like fixed width, CSV, Salesforce and excel Manage.
• Have in depth knowledge and experience in implementing the best practices for design and development of data warehouses using Star schema &
• Snowflake schema design concepts.
• Experience in Performance Tuning of sources, targets, mappings, transformations, and sessions
• Carried out support and development activities in a relational database environment, designed tables,
• procedures/Functions, Packages, Triggers and Views in relational databases and used SQL proficiently in database programming using SNFL