Epicareer Might not Working Properly
Learn More
R

ETL - Informatica Power Exchange Specialist

Salary undisclosed

Apply on

Availability Status

This job is expected to be in high demand and may close soon. We’ll remove this job ad once it's closed.


Original
Simplified

Key Responsibilities:

  • Mainframe Data Extraction: Leverage Informatica Power Exchange to extract and integrate data from Mainframe systems, ensuring efficient and reliable data transfer.
  • ETL Architecture: Design and implement detailed ETL architecture, ensuring that it meets business requirements and performance standards.
  • Data Profiling & Analysis: Perform data profiling and in-depth data analysis to identify data patterns, quality issues, and other key insights.
  • Performance Tuning: Optimize data extraction and ETL workflows for improved performance and efficiency.
  • SQL & Database Expertise: Write and maintain complex SQL queries, ensuring optimal interaction with databases for both extraction and transformation purposes.
  • Power Exchange Domain Expertise: Utilize your expertise in Power Exchange to ensure effective data integration and resolve technical challenges within the domain.
  • Collaboration: Work closely with data engineers, architects, and business stakeholders to define technical specifications and ensure the smooth execution of data integration processes.
  • Documentation: Document ETL processes, configurations, and performance optimization strategies for future reference and knowledge sharing.

Qualifications:

  • Bachelor s degree in Computer Science, Information Systems, or a related field.
  • 5+ years of experience working with Informatica Power Exchange in data extraction from Mainframe systems.
  • Strong experience with SQL and database management (e.g., Oracle, SQL Server, DB2).
  • Proven expertise in ETL design and development, particularly with Informatica tools.
  • Experience in data profiling, data quality analysis, and understanding of data governance principles.
  • Skilled in performance tuning of data extraction and transformation processes.
  • Experience working with Mainframe systems is a significant advantage.

Preferred Skills:

  • Experience with data warehousing and big data technologies.
  • Understanding of cloud platforms (AWS, Azure, Google Cloud Platform) for ETL deployment.
  • Knowledge of DataStage, Talend, or other ETL tools is a plus.
  • Ability to work in an Agile environment and collaborate with cross-functional teams.

Soft Skills:

  • Strong analytical and problem-solving skills.
  • Excellent communication skills and the ability to convey technical concepts to non-technical stakeholders.
  • Ability to work independently and as part of a team.
  • Attention to detail and a proactive approach to troubleshooting and optimizing ETL processes.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job