Application Support Analyst - Informatica
- Reuters
- 3 - 8 years
- Hyderabad
- 2 months ago
- Email to a friend
- Report this job
Job Description
About the role:
In this opportunity as Application Support Analyst, 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.Collaborate with stakeholders such as business teams, product owners, and project management in defining roadmaps for applications and processes.
- Drive continual service improvement and innovation in productivity, software quality, and reliability, including meeting/exceeding SLAs.
- Thorough understanding of ITIL processes related to incident management, problem management, application life cycle management, operational health management.
- Experience in supporting applications built on modern application architecture and cloud infrastructure, Informatica PowerCenter/IDQ, Javascript frameworks and Libraries, HTML/CSS/JS, Node.JS, TypeScript, jQuery, Docker, AWS/Azure.
About You:
You're a fit for the role of Application Support Analyst - Informatica if your background includes:
- 3 to 8+ 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.
- 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
- Thousand Coffees Thomson Reuters caf networking.
Job Classification
Industry: Advertising & MarketingFunctional Area / Department: IT & Information SecurityRole Category: IT SupportRole: IT Support - OtherEmployement Type: Full timeContact Details:
Company: Thomson ReutersLocation(s): Hyderabad
Keyskills: Application Support TypeScript Java jQuery Docker XML JavaScript HTTP HTML Informatica ETL Performance Tuning
Similar positions
Reuters
About KBL:\n\nKirloskar Brothers Limited (KBL) is a world-class pump manufacturing company with expertise in engineering and the manufacture of systems for fluid management. Established in 1888 and incorporated in 1920. KBL is the flagship company of the $ 2.1 billion Kirloskar Group. The marke...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in