About the role
Job Overview
MUFG Bank is looking for experienced Data Integration Operations Support with a strong background in Data Integration Technologies. The ideal candidate will have a good understanding of data integration and data quality tools from Informatica. Candidate should also have proficiency in AWS services for Data Integration like AWS Glue, AWS Lambda, Step functions etc.
Data Integration Operations Support Engineer:
Platform Management:
· Expertise in Informatica Administration tasks including Installation, Configuration of domains, Code Promotions/ Migrations, managing users, groups, associated privileges, performing backups and restore for domain components for Informatica tools.
- Familiarity with application support models and working in 24*7 support environment using ITIL processes
· Hands-on experience in developing ETL mappings, workflows and providing production support for critical data warehouse environments
· Hands-on experience in administration and supporting Informatica’s PowerCenter, Data Quality, Informatica Webservices, PowerExchange and Informatica Cloud(IDMC) and DVO etc.
· Familiarity with various inter-related tools for version control like Bitbucket, GitHub and scheduling tools like AutoSys.
· Hands-on Experience in setting up the security for Informatica environments/domains
· Hands-on in implementing several reusable scripts which include Informatica service Monitoring, Backups, Generic workflow/taskflow start script, server monitoring scripts.
· Hands-on Experience in various performance tuning activities which includes identifying the potential bottle necks and thereby tuning ETL code for best performance.
· Expertise in UNIX shell scripting, communicating with server using pmcmd/pmrep.
- Experience in setting up Informatica application Infrastructure like .profiles, parameters, environment variables etc.
- Experience in raising service requests with Informatica for resolving any product related issues
- Hands-on Experience in migrating various complex applications between environments and to Production using Informatica’s deployment groups, folder/XML migration
- Hands-on Experience in creating TNS/odbc entries and DB2 entries.
- Hands-on Experience in implementing automated reusable scripts across environment which includes - Monitoring of INFA Services, CPU/Memory, volume group/SAN, Network, backups like domain/repository etc.
· Hands on Experience working with AWS services including Glue, S3, EKS, Data Pipeline, Step functions and establishing connectivity to AWS services like RDS from Informatica, Apache Spark.
· Experience with working on big data processing platforms like Apache Spark, building ETL code using Apache pyspark.
Collaboration & Teamwork:
· Participate in knowledge sharing, educating, and creating documentation with onshore/offshore teams.
· Proven strength in trouble shooting, problem solving, coordination and analysis
· Maintain and support existing platforms and evolve to newer technology stacks and architecture.
Documentation and Support:
1. Create and maintain comprehensive documentation for infrastructure designs, procedures, and configurations using Confluence and Jira.
2. Provide support and troubleshooting assistance to other team members and stakeholders as needed.
- Familiarity with creating various best practices documents for coding standards, migration best practices etc.
Qualification for Data Integration Operations Support Engineer:
· Bachelor’s degree in computer science, Information Technology, or related field; or equivalent work experience.
· Familiarity with Informatica tools.
· Familiarity with AWS cloud services, including Glue, S3, EKS, Data Pipeline, Step functions, RedShift, Amazon EMR.
· Strong problem-solving skills and the ability to work independently as well as in a team environment.
· Excellent communication skills, both written and verbal, detail-oriented with strong organizational and documentation skills.
· At least 4 years of experience in Informatica Platform Administration.