Senior ETL Informatica Specialist

We are seeking an experienced Data Integration Operations Support Engineer Lead with a strong background in data integration and data quality tools from Informatica.

Key Responsibilities:

• 10+ years of experience in ETL platform administration with experience spread across Informatica PowerCenter and Informatica cloud (IICS) as well as AWS Glue and Snowflake Data Platforms.
• 8+ years of experience in dealing with multiple databases DB2, Oracle, Sql Server, etc.
• 4+ years of cloud data platform experience.
• 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.
• 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, Power Exchange 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/task flow 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.
• 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.
• Familiarity with application support models and working in 24*7 support environment using ITIL processes.
• 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.

Requirements:

• 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 8 years of experience in Informatica Platform Administration.

About This Role:

This is a leadership position that requires a high level of expertise and technical knowledge. As a seasoned professional, you will be responsible for overseeing the design, implementation, and maintenance of data integration solutions using Informatica tools.

What We Offer:

We offer a dynamic and challenging work environment that provides opportunities for growth and development. Our team is passionate about delivering high-quality solutions that meet the needs of our customers.