Strong development experience in Informatica PowerCenter 9.6.1 or above. Excellent knowledge on Informatica platform as a whole and the integration among different Informatica components and services.
Experience in Referential data and metadata management is a good plus. Good understanding of data governance principles.
Familiar with RDBMS like Oracle and SQL Server, understanding the data modeling, and excel in PL-SQL. Assist in the identification, planning, implementation, and support of various Finance initiatives and support business-critical analysis
Familiar with RDBMS like Oracle and SQL Server, design and understanding the data modeling, and SQL experience involving multiple, complex queries
Analyze highly complex business requirements, design and write technical specifications to design or redesign complex ETL solutions.
Perform detailed data analysis to understand the source system data
Review physical Database objects including staging, materialized views, indexes and convert the same in ETL
Manage and improve PL / SQL code that automates monitoring of data extracts complex financial data
Responsible for the development / modification and Implementation of Informatica jobs and ETL processes for Data Marts
Hands on experience in Design, Development, Build & Test activities in Informatica
Understanding of the SDLC, good practices and experience with different development and change management tools
Experience in troubleshooting of Informatica jobs and addressing production issues like performance tuning and enhancement
Knowledge on Unix / Linux, Shell Scripting will be an added advantage
Experience with big data and analytics systems : Python, Tableau, SparkSQL, PowerBI, etc. is a plus
Strong Knowledge of Financials’ core business or semiconductor industry functions is preferred
Ability to be flexible and adjust plans quickly to meet changing business needs and to be able to work with the remote teams