In this opportunity asApplication 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:
- 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 supportingcodeas 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 XMLs, 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, 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.
