ETL/Informatica Developer

$85,800 - $185,800/Yr

CGI - Pittsburgh, PA

posted 3 months ago

Full-time - Mid Level
Pittsburgh, PA
Professional, Scientific, and Technical Services

About the position

As a Senior ETL Informatica Developer, the candidate will be responsible for designing, developing, and maintaining complex ETL (Extract, Transform, Load) solutions using Informatica PowerCenter. Leveraging expertise in data integration and Informatica tools, the candidate will collaborate with cross-functional teams to analyze business requirements, design data integration workflows, and implement scalable and efficient ETL processes. This role requires a deep understanding of data management principles and the ability to work with large datasets effectively. The candidate will engage in various tasks including ETL development, data analysis, performance optimization, application design, and metadata management. They will be expected to write complex queries, stored procedures, and Oracle functions, while also tuning performance to ensure efficient data processing. The role involves managing large amounts of data and may require scripting skills, although scripting is considered a nice-to-have. In addition to technical skills, the candidate must possess strong communication and documentation skills, as they will be required to report on their findings and collaborate with other team members. A solid background in the banking domain is advantageous but not mandatory. The position offers an opportunity to work in a dynamic environment where the candidate can contribute to innovative solutions and grow their career within a leading IT and business consulting firm.

Responsibilities

  • Design, develop, and maintain ETL solutions using Informatica PowerCenter.
  • Collaborate with cross-functional teams to analyze business requirements.
  • Design data integration workflows and implement ETL processes.
  • Perform data analysis and optimize performance of ETL processes.
  • Manage metadata and ensure data quality throughout the ETL lifecycle.
  • Write complex SQL queries and stored procedures for data manipulation.
  • Utilize CA7 scheduling tool for job scheduling and monitoring.
  • Document processes and maintain clear communication with team members.

Requirements

  • Minimum of 6 years of Informatica ETL development experience.
  • Strong background in Oracle database management.
  • Experience with Informatica PowerExchange and PowerCenter.
  • Proficient in SQL, Shell scripting, and UNIX/Linux commands.
  • Experience in building data integration between systems and applications.
  • Strong data analysis skills and experience in data warehousing.
  • Very strong programming and debugging skills.
  • Experience with CA7 scheduling tool is essential.

Nice-to-haves

  • Scripting skills (e.g., Python, Shell) are a plus.
  • Strong banking domain knowledge is beneficial.

Benefits

  • Competitive base salaries.
  • Eligibility to participate in an attractive Share Purchase Plan (SPP) with company matching.
  • 401(k) Plan and Profit Participation for eligible members.
  • Generous holidays, vacation, and sick leave plans.
  • Comprehensive insurance plans including medical, dental, vision, life, and disability coverage.
  • Back-up child care support.
  • Pet insurance and Member Assistance Program.
  • 529 college savings program and personal financial management tools.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service