Epicareer Might not Working Properly
Learn More
R

ETL Informatica Developer

Salary undisclosed

Apply on


Original
Simplified

ETL Informatica Developer

Contract: W2 Only

Responsibilities:

  1. Design and Develop ETL Processes:

    • Work closely with business analysts and stakeholders to understand data integration requirements.
    • Design, develop, and implement ETL processes using Informatica PowerCenter to extract, transform, and load data from various sources to the target systems.
  2. Data Mapping and Transformation:

    • Perform data mapping and transformation based on business rules and requirements.
    • Ensure data quality and integrity throughout the ETL process.
  3. Performance Tuning:

    • Optimize ETL processes for performance and scalability.
    • Identify and resolve performance bottlenecks in the data integration workflows.
  4. Collaboration and Communication:

    • Collaborate with cross-functional teams including data architects, database administrators, and business analysts to ensure successful delivery of data integration solutions.
    • Communicate effectively with team members and stakeholders to gather requirements and provide project updates.
  5. Documentation:

    • Create and maintain comprehensive documentation for ETL processes, data mappings, and transformation logic.
    • Ensure that documentation is up-to-date and aligns with best practices.
  6. Testing and Validation:

    • Conduct unit testing and support user acceptance testing for ETL processes.
    • Troubleshoot and resolve issues identified during testing phases.

Qualifications:

  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • Proven experience as an ETL Developer using Informatica PowerCenter.
  • Strong understanding of data warehousing concepts and principles.
  • Proficiency in SQL and relational databases.
  • Experience with performance tuning and optimization of ETL processes.
  • Excellent problem-solving skills and attention to detail.
  • Strong communication and interpersonal skills.

Preferred Skills:

  • Informatica PowerCenter Certification.
  • Experience with other ETL tools and technologies.
  • Knowledge of data modeling concepts.
  • Familiarity with Big Data technologies (Hadoop, Spark).
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