Data Integration Administrator - Vice President position available at Mitsubishi UFJ Financial Group (MUFG), with a strong background in Data Integration Technologies. The selected colleague will work at an MUFG office or client sites four days per week and work remotely one day. The ideal candidate will have a deep understanding of data integration, data quality and big data processing engines on Cloud Native and Cloud agnostic platforms.
Requirements
- Install, configure and manage enterprise data integration platforms Informatica and AWS Glue in AWS cloud environments and in on-premises infrastructure.
- Perform critical role in migration of code base from one Data Integration platform to another.
- 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, data stage, Apache Spark.
- Experience with working on big data processing platforms like Apache Spark, building ETL code using Apache pyspark.
- Good understanding of benefits/limitations offered by each platform and migrations paths offered by different vendors.
- Work closely with multiple development teams, enterprise architects to perform third party tools assessment and participate in evaluation/comparison of offering, capability of each tool etc.
- Lead effort to Lift & shift/Replatform/Refactor of on premises Data Integration tools like Informatica PowerCenter to Cloud Native/Cloud agnostic platforms.
- Experience in leading team of Onshore/Offshore teams for data integration products.
- Experience in leading large data migration, product upgrade projects within enterprise.
- Participate in knowledge sharing, educating, and creating documentation with onshore/offshore teams.
- Work with Development and architecture groups to design and deliver data integration and workflow framework that provides data integration, data quality functionalities using different data integration tools from multiple vendors.
- Participate in architecture discussions, influence product roadmap, and take ownership and responsibility for new projects.
- Maintain and support existing platforms and evolve to newer technology stacks and architecture.
- Implement and enforce security best practices for Data Integration Platforms with ‘Secure by Design’ principles.
- Ensure compliance with relevant regulations and internal policies through proper configuration and auditing.
- Create and maintain comprehensive documentation for infrastructure designs, procedures, and configurations using Confluence and Jira.
- Provide support and troubleshooting assistance to other team members and stakeholders as needed.
Benefits
- Comprehensive health and wellness benefits
- Retirement plans
- Educational assistance and training programs
- Income replacement for qualified employees with disabilities
- Paid maternity and parental bonding leave
- Paid vacation, sick days, and holidays