Application Support Analyst - Informatica & DSXI
Job Description
Application Support Analyst - Informatica & DSX
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 - Informatica & DSX, you will:
Experience on Informatica support. The engineer will be responsible for supporting Informatica Development, Extractions, and loading.
Fixing the data discrepancies and take care of performance monitoring.
- 3 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
- 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
#LI-LJ1
What’s in it For You?
Hybrid Work Model: We’ve adopted a flexible hybrid working environment (2-3 days a week in the office depending on the role) for our office-based roles while delivering a seamless experience that is digitally and physically connected.
Flexibility & Work-Life Balance: Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities, whether caring for family, giving back to the community, or finding time to refresh and reset. This builds upon our flexible work arrangements, including work from anywhere for up to 8 weeks per year, empowering employees to achieve a better work-life balance.
Career Development and Growth: By fostering a culture of continuous learning and skill development, we prepare our talent to tackle tomorrow’s challenges and deliver real-world solutions. Our Grow My Way programming and skills-first approach ensures you have the tools and knowledge to grow, lead, and thrive in an AI-enabled future.
Industry Competitive Benefits: We offer comprehensive benefit plans to include flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs, and resources for mental, physical, and financial wellbeing.
Culture: Globally recognized, award-winning reputation for inclusion and belonging, flexibility, work-life balance, and more. We live by our values: Obsess over our Customers, Compete to Win, Challenge (Y)our Thinking, Act Fast / Learn Fast, and Stronger Together.
Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually and opportunities to get involved with pro-bono consulting projects and Environmental, Social, and Governance (ESG) initiatives.
Making a Real-World Impact: We are one of the few companies globally that helps its customers pursue justice, truth, and transparency. Together, with the professionals and institutions we serve, we help uphold the rule of law, turn the wheels of commerce, catch bad actors, report the facts, and provide trusted, unbiased information to people all over the world.
About Us
Thomson Reuters informs the way forward by bringing together the trusted content and technology that people and organizations need to make the right decisions. We serve professionals across legal, tax, accounting, compliance, government, and media. Our products combine highly specialized software and insights to empower professionals with the data, intelligence, and solutions needed to make informed decisions, and to help institutions in their pursuit of justice, truth, and transparency. Reuters, part of Thomson Reuters, is a world leading provider of trusted journalism and news.
We are powered by the talents of 26,000 employees across more than 70 countries, where everyone has a chance to contribute and grow professionally in flexible work environments. At a time when objectivity, accuracy, fairness, and transparency are under attack, we consider it our duty to pursue them. Sound exciting? Join us and help shape the industries that move society forward.
As a global business, we rely on the unique backgrounds, perspectives, and experiences of all employees to deliver on our business goals. To ensure we can do that, we seek talented, qualified employees in all our operations around the world regardless of race, color, sex/gender, including pregnancy, gender identity and expression, national origin, religion, sexual orientation, disability, age, marital status, citizen status, veteran status, or any other protected classification under applicable law. Thomson Reuters is proud to be an Equal Employment Opportunity Employer providing a drug-free workplace.
We also make reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs in accordance with applicable law. More information on requesting an accommodation here.
Learn more on how to protect yourself from fraudulent job postings here.
More information about Thomson Reuters can be found on thomsonreuters.com.
Company Information
Location: Toronto, Canada
Type: Hybrid