Informatica ETL Specialist

2 weeks ago


Plano, Texas, United States Insight Global Full time

JOB OVERVIEW

Insight Global is seeking an ETL/Informatica Specialist to support a major financial institution. The ideal candidate will possess expertise in Informatica, ETL processes, and Informatica Cloud Services (ICS). This role involves designing, developing, maintaining, and testing software solutions while collaborating with both the development team and business stakeholders to ensure effective delivery and implementation of application solutions within an agile framework. A hands-on approach is essential, with the ability to create ETL packages utilizing Informatica PowerCenter.

KEY RESPONSIBILITIES

  • Engage in the ETL design process for new or modified mappings and workflows, preparing detailed technical specifications.
  • Develop ETL mappings, mapplets, workflows, and worklets using Informatica PowerCenter 10.x, along with necessary documentation.
  • Design and construct integrations that support standard data warehousing structures, including type-2 dimensions, aggregations, and star schemas.
  • Conduct source system analysis as needed.
  • Collaborate with Database Administrators and Data Architects to strategize and implement effective data partitioning in the Enterprise Data Warehouse.
  • Manage version control of the ETL repository and associated code as required.
  • Load and transform data from diverse external sources into relational databases using Informatica.
  • Handle complex transformations, including XML processing, XML parsing, Java, and HTTP transformations, while designing SCD type-2 workflows.

ESSENTIAL SKILLS AND EXPERIENCE

  • Proficiency in Informatica PowerCenter 10.x, Oracle 11g/12c SQL/PLSQL, and AutoSys.
  • Familiarity with version control tools.
  • Experience in ETL development.
  • Knowledge of Informatica Cloud Services (ICS).
  • Preferred experience with a major financial institution.

DESIRABLE SKILLS AND EXPERIENCE

  • Oracle PL/SQL knowledge.
  • Understanding of Unix concepts.
  • Experience with SDM Adoption / Horizon onboarding tools (e.g., Bit Bucket, Datical, Jenkins).
  • Familiarity with agile best practices.


  • Plano, Texas, United States Insight Global Full time

    JOB OVERVIEWInsight Global is seeking an ETL/Informatica Specialist to support one of our prominent financial sector clients. The ideal candidate will possess expertise in Informatica, ETL processes, and Informatica Cloud Services (ICS). This role involves the design, development, maintenance, and testing of software solutions, working closely with both the...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description Informatica ETL Specialist Contract to Hire PositionLocation: Remote/Hybrid Compensation: Competitive Hourly Rate Position Overview: As an Informatica ETL Specialist, you will play a pivotal role in the Banking & Finance sector, focusing on the development and execution of data integration solutions. This position...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description Informatica ETL Specialist Contract to Hire Position Location: Remote/Hybrid Compensation: Competitive Hourly Rate Position Overview: As an Informatica ETL Specialist, you will play a pivotal role in the development and execution of data integration solutions within the Banking & Finance sector. Your expertise will be...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description Informatica ETL Specialist Contract Type: Contract to Hire Location: Remote/Hybrid Compensation: $68.00 Per Hour Position Overview: Sector: Banking & Finance Work Arrangement: Hybrid (Remote and On-site) Role: Informatica Developer Engagement Duration: 12-18 Months Contract to Hire Essential Qualifications:Proven...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description Informatica ETL Specialist Contract to Hire Position Location: Hybrid Work Environment Compensation: $68.00 Per Hour Position Overview: Sector: Banking & Finance Workplace: Flexible location options available Role: Informatica Developer Contract Duration: 12-18 Months CTH Essential Qualifications:Proven experience...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description Informatica ETL Specialist Contract to Hire Position Location: Hybrid Work Environment Compensation: Competitive Hourly Rate Position Overview: Sector: Banking & Finance Job Title: ETL Informatica Developer Contract Duration: 12-18 Months Essential Qualifications:Proven experience in the design and execution of data...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description Informatica ETL Specialist Contract to Hire Position Location: Hybrid Work Environment Compensation: Competitive Hourly Rate Position Overview: Industry: Banking & Finance Job Title: Data Integration Developer Contract Duration: 12-18 Months Essential Qualifications:Proven experience in the development and execution...


  • Plano, Texas, United States Insight Global Full time

    JOB OVERVIEWInsight Global is seeking an ETL/Informatica Developer to support a prominent client in the financial sector. The ideal candidate will possess expertise in Informatica, ETL processes, and Informatica Cloud Services (ICS). This role involves designing, developing, maintaining, and testing software solutions while collaborating with both the...


  • Plano, Texas, United States Insight Global Full time

    JOB OVERVIEWInsight Global is seeking an experienced ETL/Informatica Developer to support a prominent client in the financial sector. The ideal candidate will possess a strong background in Informatica, ETL processes, and Informatica Cloud Services (ICS). This role involves designing, developing, maintaining, and testing software solutions while...


  • Plano, Texas, United States Purple Drive Full time

    Job Summary: We are seeking an experienced ETL Informatica Production Support Specialist to join our team at Purple Drive.About the Role: As an ETL Informatica Production Support Specialist, you will be responsible for providing technical support and resolving production issues related to Abnitio ETL Informatica AWS. You will work closely with our team to...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description ETL Informatica Developer Contract Type: Contract to Hire Location: Remote/Hybrid Compensation: $68.00 Per Hour Position Overview: Sector: Banking & Finance Work Arrangement: Hybrid model with flexibility Role: Informatica Developer Contract Duration: 12-18 Months Essential Qualifications:Proven experience in the...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description ETL Informatica Developer Contract to Hire Position: Plano, Texas, US Compensation: $68.00 Per Hour Position Overview: Industry: Banking & Finance Work Arrangement: Hybrid (Plano, TX/ Atlanta, GA) Job Role: Informatica Developer Contract Duration: 12-18 Months CTH Essential Qualifications:Proven experience in...


  • Plano, Texas, United States Collabera Full time

    Home Search Jobs Job Description ETL Informatica Developer Contract Type: Contract to Hire Location: Remote/Hybrid Compensation: $68.00 Per Hour Position Overview: Sector: Banking & Finance Work Arrangement: Hybrid (Remote and On-site) Role: Informatica Developer Contract Duration: 12-18 Months Essential Qualifications:Proven experience in the...


  • Plano, Texas, United States TEKsystems Full time

    Position Overview:The role involves crafting application solutions that may utilize a variety of development environments, software, hardware, technologies, and tools. The individual will engage in the design, development, and deployment of intricate applications, frequently leveraging cutting-edge technologies. Collaboration with external developers may be...


  • Plano, Texas, United States Genesis10 Full time

    Genesis10 is currently seeking an ETL Developer with our client in the financial sector. This role is a long-term contract opportunity.Key Responsibilities:Assist in adapting to ongoing regulatory modifications in Americas Regulatory Reporting, with a significant emphasis on ETL Informatica and database development tasks.Design, enhance, troubleshoot,...


  • Plano, Texas, United States Genesis10 Full time

    Genesis10 is seeking a skilled Application Programmer for a long-term contract role within the financial sector.Key Responsibilities:Assist in the adaptation to ongoing regulatory modifications in Americas Regulatory Reporting, with a significant emphasis on ETL Informatica and database development tasks.Design, enhance, troubleshoot, support, maintain, and...


  • Plano, Texas, United States Wipro Full time

    About Wipro:Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) stands as a prominent technology services and consulting firm dedicated to crafting innovative solutions that tackle clients' most intricate digital transformation challenges. We harness our extensive portfolio of capabilities in consulting, design, engineering, operations, and emerging...


  • Plano, Texas, United States Wipro Full time

    About Wipro:Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) stands as a prominent technology services and consulting firm dedicated to crafting innovative solutions that meet the intricate digital transformation demands of our clients. Our extensive portfolio encompasses consulting, design, engineering, operations, and cutting-edge technologies,...


  • Plano, Texas, United States Genesis10 Full time

    Genesis10 is seeking a skilled Application Programmer for a long-term contract opportunity within the financial sector.Key Responsibilities:Assist in adapting to ongoing regulatory modifications in the Americas Regulatory Reporting, with a significant emphasis on ETL Informatica and database development tasks.Design, enhance, troubleshoot, support, maintain,...


  • Plano, Texas, United States Genesis10 Full time

    Job Summary:Genesis10 is seeking an experienced Informatica Developer to join our team in the financial industry. This is a 12+ month contract position that requires strong technical skills and experience with ETL Informatica, Oracle PL/SQL, and Agile methodologies.Responsibilities:Support ongoing regulatory changes in Americas Reg Reporting with a focus on...