Informatica Administrator JD\:
Essential skills\: Very strong technical skills, Process compliance, Professional English & general communication skills. Exposure to international customers & willingness to work in a global setting.
· Candidate should have minimum of 4-6 years of experience in Informatica in handling end-to-end PowerCenter and IICS administration activities.
· Ensure that the Informatica suite is up-to-date with upgrades when appropriate apply
· Experience in Installation and Configuration of IICS Application Integration Components and process objects in Cloud
· Experience in Architecture Assessment, Capacity Planning, System Architecture Design for High Availability and Load Balancing/Grid Configuration of Informatica
· Responsible for monitoring performance and uptime of the Informatica ETL jobs – Using Informatica Cloud and Power Center · Experience in Informatica cloud administrator activities like Code migration, User Management, and Connection Management to setup of interfacing systems such as – SAP HANA, Amazon Redshift, Amazon S3, Salesforce, DataCenter, MySQL and Oracle.
· Ability to handle multiple projects and assignments simultaneously and effectively in a cross-functional team environment
· Ability to troubleshoot, modify, and enhance shell Scripts/Playbooks for regular maintenance activities, upgrades, and feature requests.
· Ability to determine the root cause of problems and create alternative solutions that resolve the problems in the business's best interest.
· Informatica jobs performance tuning & Advisory to Development team
· Strong knowledge of Shell scripting & Python
· Strong knowledge of RESTAPI
· Tableau experience is a PLUS
Roles and Responsibilities\:
· Environment alerts monitoring and maintains Informatica application infrastructure.
· Troubleshoot and resolve platform issues.
· Provide support for incidents and address user queries. Debug and solve production issues.
· Root Cause Analysis for ETL job failures/Data issues raised by business
· Service now Ticket handling and problem ticket analysis
· Handle day-to-day Informatica powercenter/IICS migration tasks
· Documenting processes, as well as backing up and archiving data.
· Software Installation & apply Hotfix.
· Implement security protocols and procedures to prevent potential threats.
· Automation of manual admin activities
· Handling multi-node environment and cluster solution for high availability and Load balancing
· Configuring SSL and TLS certificates into environments
Bonuses
· Informatica Certification(s)\: Informatica Cloud, PowerCenter Data Integration and Data Quality
· Experience with Informatica Cloud, Informatica Grid, and/or Informatica Big Data
· Understanding of core AWS services like EC2, S3, IAM, and VPC.
· Familiarity with the AWS console and basic command-line tools (AWS CLI).
· Familiarity with data processing concepts like ETL/ELT pipelines. Basic experience with Python or Scala for data manipulation.
· Experience with data processing frameworks like Apache Spark or AWS Glue. Understanding of data warehousing concepts and data quality practices.
· Familiarity with data sharing mechanisms like S3 Sharing and Redshift Sharing. Sharing using Lake formation. sharing between accounts, regions
· Basic understanding of data warehousing concepts and querying languages like SQL.
· Basic understanding of AWS serverless services like Lambda, Step Functions, AWS Glue and Redshift Serverless.
· Experience with CI/CD pipelines for automating infrastructure and code deployment.
· Knowledge of cloud monitoring and logging services like CloudWatch.
· Understanding of data lineage and data quality tools.
Minimum Qualifications\:
· Bachelors or/and Master degree in computer science or related discipline