ETL Informatica Developer

3 days ago

Pittsburgh, United States Synechron Full time

Job Title: ETL Informatica Developer (PowerExchange)

Location: Pittsburgh, PA or Dallas, TX

Contact: gorav.sharma@synchron.com


Job Summary: We are seeking an experienced ETL Informatica Developer with specialized experience in PowerExchange to join our data management team. The candidate will be responsible for designing, developing, and maintaining efficient and reliable data extraction, transformation, and loading (ETL) processes. They should have a strong understanding of Informatica PowerCenter along with PowerExchange to handle real-time data integration and bulk data movement.


Key Responsibilities:

  • Design and develop ETL workflows and mappings using Informatica PowerCenter and PowerExchange.
  • Work with business analysts and data architects to translate business requirements into technical specifications.
  • Extract data from various source systems using PowerExchange, ensuring high data quality and integrity.
  • Implement complex business logic within Informatica to meet data transformation and processing needs.
  • Monitor and optimize ETL processes to ensure performance and reliability.
  • Provide support for ETL processes, including troubleshooting, performance tuning, and problem resolution.
  • Collaborate with cross-functional teams to resolve data-related technical issues and to implement continuous improvement practices.
  • Document ETL processes, create data dictionaries, and develop standard operating procedures for ETL-related activities.
  • Stay current with new technologies and techniques in ETL and data integration.
  • Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications.
  • Engage in L1/L2 support as needed and provide on-call support for critical ETL jobs.


Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, or a related field.
  • Minimum of 3-5 years of experience with Informatica PowerCenter and at least 2 years of experience with Informatica PowerExchange.
  • Strong understanding of ETL concepts, data structures, and methodologies.
  • Proficiency in SQL and experience working with relational databases like Oracle, SQL Server, etc.
  • Experience with real-time data integration and CDC (Change Data Capture) techniques using PowerExchange.
  • Familiarity with data warehousing concepts and dimensional modeling.
  • Ability to write high-performance, reusable, and reliable code.
  • Strong problem-solving skills and ability to work in a fast-paced environment.
  • Excellent communication and collaboration skills.
  • Experience with other Informatica products such as IDQ, MDM, or IICS is a plus.
  • Knowledge of additional data integration tools or programming languages is beneficial.


We can offer you:

  • A highly competitive compensation and benefits package
  • A multinational organization with 55 offices in 20 countries and the possibility to work abroad
  • Laptop and a mobile phone
  • 10 days of paid annual leave (plus sick leave and national holidays)
  • Maternity & Paternity leave plans
  • A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
  • Retirement savings plans
  • A higher education certification policy
  • Commuter benefits (varies by region)
  • Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
  • On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
  • Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
  • Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms
  • A flat and approachable organization
  • A truly diverse, fun-loving and global work culture


S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

  • ETL Informatica Developer

    3 days ago

    Pittsburgh, United States Synechron Full time

    Job Title: ETL Informatica Developer (PowerExchange)Location: Pittsburgh, PA or Dallas, TXContact: gorav.sharma@synchron.comJob Summary: We are seeking an experienced ETL Informatica Developer with specialized experience in PowerExchange to join our data management team. The candidate will be responsible for designing, developing, and maintaining efficient...

  • ETL Informatica Developer

    2 days ago

    Pittsburgh, Pennsylvania, United States Synechron Full time

    About the RoleWe are seeking an experienced ETL Informatica Developer with specialized expertise in PowerExchange to join our data management team at Synechron.Key ResponsibilitiesDesign and Develop ETL Workflows: Utilize Informatica PowerCenter and PowerExchange to design and develop efficient and reliable ETL processes.Collaborate with Business Analysts:...

  • ETL Developer

    3 weeks ago

    Pittsburgh, United States Mastech Digital Full time

    Role: ETL Informatica Developer Location: Pittsburgh, PA (Hybrid) Job Type: Full time/ Permanent roleResponsibilities: • ETL Development • Data Analysis • Performance Optimization • Application design/Data Modeling • Metadata Management • Database skills – writing complex queries, stored procedures, Oracle functions, Performance tuning •...

  • ETL Developer

    3 weeks ago

    Pittsburgh, United States Mastech Digital Full time

    Role: ETL Informatica Developer Location: Pittsburgh, PA (Hybrid) Job Type: Full time/ Permanent roleResponsibilities: • ETL Development • Data Analysis • Performance Optimization • Application design/Data Modeling • Metadata Management • Database skills – writing complex queries, stored procedures, Oracle functions, Performance tuning •...

  • Informatica Application Development

    2 months ago

    Pittsburgh, Pennsylvania, United States Solve IT Strategies, Inc. Full time

    Solve IT Strategies is looking for an Informatica Application Development. This role is 100% remote.The Main Responsibilities of a person are:Responsible for analysis, design, programming, testing and implementation for new and existing Informatica application software, and production support for Informatica systems with medium complexity.• This is an...

  • Informatica Application Development

    2 weeks ago

    Pittsburgh, United States Solve IT Strategies, Inc. Full time

    Job DescriptionJob DescriptionSolve IT Strategies is looking for an Informatica Application Development. This role is 100% remote.The Main Responsibilities of a person are:Responsible for analysis, design, programming, testing and implementation for new and existing Informatica application software, and production support for Informatica systems with medium...

  • Informatica Application Development Specialist

    2 weeks ago

    Pittsburgh, Pennsylvania, United States Solve IT Strategies, Inc. Full time

    Job DescriptionSolve IT Strategies, Inc. is seeking a skilled Informatica Application Development Specialist to join our team. This is a 100% remote position.Main Responsibilities:As an Informatica Application Development Specialist, you will be responsible for:Analysis, design, programming, testing, and implementation of new and existing Informatica...

  • Informatica Application Development Specialist

    2 weeks ago

    Pittsburgh, Pennsylvania, United States Solve IT Strategies, Inc. Full time

    Job DescriptionSolve IT Strategies, Inc. is seeking a skilled Informatica Application Development Specialist to join our team. This is a 100% remote position.Main Responsibilities:As an Informatica Application Development Specialist, you will be responsible for:Analysis, design, programming, testing, and implementation of new and existing Informatica...

  • ETL Developer

    4 weeks ago

    Pittsburgh, United States Tata Consultancy Services Full time

    Roles and Responsibilities ETL Tools: Experience with one or more ETL tools like Informatica PowerCenter, Microsoft SSIS (SQL Server Integration Services), Talend, Pentaho, or Apache NiFi is critical. Databases: A strong understanding of relational databases (such as MySQL, Oracle, and SQL Server) and knowledge of SQL is essential. Experience with NoSQL...

  • ETL Developer

    4 weeks ago

    Pittsburgh, United States Tata Consultancy Services Full time

    Roles and Responsibilities ETL Tools: Experience with one or more ETL tools like Informatica PowerCenter, Microsoft SSIS (SQL Server Integration Services), Talend, Pentaho, or Apache NiFi is critical. Databases: A strong understanding of relational databases (such as MySQL, Oracle, and SQL Server) and knowledge of SQL is essential. Experience with NoSQL...

  • ETL Developer

    4 weeks ago

    Pittsburgh, United States Tata Consultancy Services Full time

    Roles and Responsibilities ETL Tools: Experience with one or more ETL tools like Informatica PowerCenter, Microsoft SSIS (SQL Server Integration Services), Talend, Pentaho, or Apache NiFi is critical. Databases: A strong understanding of relational databases (such as MySQL, Oracle, and SQL Server) and knowledge of SQL is essential. Experience with NoSQL...

  • Informatica Developer

    2 weeks ago

    Pittsburgh, United States Saxon Global Full time

    Experience Required: Overview of Responsibilities: -5-8 years of Informatica PowerCenter Experience -Experience with Informatica MDM tool is good to have -Should be able to take source to target mappings and be able to code independently. -Should be able to understand the scope of the work and ask clarifications and escalate to the right leads in case of...

  • Informatica TDM Developer

    2 months ago

    Pittsburgh, United States Diverse Lynx Full time

    Role : Informatica TDM Developer Location : Pittsburgh, PA (Onsite) Duration: Full-time Job Description Skill: Informatica TDM Developer 6+ Years of experience. Informatica with TDM(Test Data Management). Expert level knowledge of Informatica TDM tool. Extensive hands-on experience with all TDM concepts including data profiling,...

  • Informatica TDM Developer

    2 weeks ago

    Pittsburgh, United States Diverse Lynx Full time

    Role : Informatica TDM Developer Location : Pittsburgh, PA (Onsite) Duration: Full-time Job Description Skill: Informatica TDM Developer 6+ Years of experience. Informatica with TDM(Test Data Management). Expert level knowledge of Informatica TDM tool. Extensive hands-on experience with all TDM concepts including data profiling,...

  • Informatica Application Developer

    10 hours ago

    Pittsburgh, PA , USA, United States Solve IT Strategies, Inc. Full time

    Informatica Application Development OpportunitySolve IT Strategies, Inc. is seeking a skilled Informatica Application Development professional to join our team.Main Responsibilities:Design, develop, test, and implement new and existing Informatica application softwareProvide production support for Informatica systems with medium complexityRequirements:3-5...

  • Informatica TDM Developer

    1 day ago

    Pittsburgh, Pennsylvania, United States ApTask Full time

    About ApTaskApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management.Job...

  • Informatica TDM Developer

    2 months ago

    Pittsburgh, United States ApTask Full time

    About Client: The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong...

  • Informatica TDM Developer

    22 hours ago

    Pittsburgh, Pennsylvania, United States Diverse Lynx Full time

    About the RoleWe are seeking a highly skilled Informatica TDM Developer to join our team at Diverse Lynx LLC. As a key member of our organization, you will be responsible for designing, implementing, and maintaining data management solutions using Informatica TDM.Key ResponsibilitiesData Profiling and Analysis: Develop and implement data profiling and...

  • Senior Informatica TDM Specialist

    2 weeks ago

    Pittsburgh, Pennsylvania, United States Diverse Lynx Full time

    Position Title : Informatica TDM Developer Work Arrangement : Onsite in Pittsburgh, PA Employment Type : Full-time Job Overview Role Summary : We are seeking a proficient Informatica TDM Developer with a robust background in Test Data Management. The ideal candidate will possess a minimum of 6 years of relevant experience and demonstrate...

  • Data Integration Specialist

    6 days ago

    Pittsburgh, Pennsylvania, United States Tata Consultancy Services Full time

    About the RoleWe are seeking a highly skilled Data Integration Specialist to join our team at Tata Consultancy Services. As an ETL Solutions Developer, you will play a critical role in designing, implementing, and maintaining data integration solutions that drive business value.Key ResponsibilitiesDesign and develop ETL processes using Informatica...