Informatica Developer

5 months ago

Horsham, United States Saxon Global Full time
Client: United Health Group
Title: Informatica ETL Developer
Duration: 6 Month Contract to Hire

  • This role is for a mid-level candidate, not a senior candidate. Any candidates that are sent above the rate of $60/hr will be rejected right away.
  • Candidates must be able to convert with no current or future sponsorship requirements.
Location: Horsham, PA (occassional on-site; once a week or bi-weekly)
  • Will consider 100% remote candidates in EST or CST however they will interview any local candidates prior to remote only candidates. Will only consider remote options if they don't find what they need locally.
Apex Systems is looking for an experienced Informatica ETL Developer to join an existing team's Data Warehouse team. Experience with Informatica PowerCenter along with some experience with Informatica Intelligence Cloud (IICS) is desired along with a strong passion for writing complex queries in an Oracle Datawarehouse environment.

Day to Day Responsibilities
  • Data profiling and analysis, test data governance
  • Conduct ETL / DW, Test Repository Gold Copy optimization, troubleshooting , debugging, Maintenance of Data Masking mapping & workflows.
  • Develops complex data extracts, applications and ad-hoc queries using DB/ & ETL Tools: Informatica Power Center and/or Informatica Cloud.
  • Work with the project team (both technical and business) to establish data requirements from all upstream data sources, ensures requirements are accurate and clearly understood by those participating in the project
  • Designs, develops, and implements solutions that exemplify modern data & software engineering practices
  • Reuses and/or develops for reuse complex components or capabilities to solve complex problems and needs, enhances system design/architecture to simplify and improve resiliency in system interactions and dependencies
  • Anticipate emerging customer needs and develops cost friendly innovative solutions to meet them - Incorporates business objectives when evaluating processes to remove redundancies and waste, considers the customer experience, business impact and solution objective when managing risks and development and design of solution, Work on Proof of Concepts for Big Data and Data Science
  • Maintains current perspective on technology trends, applying that to personal and team capability growth. Implement strategies directed at acquiring data and promoting the development of new insights across the business
  • Sorts through large amounts of data to assess for relevancy, seeks out multiple sources to gather information
  • Identifies cause and effect relationships between known and unknown variables
  • Develop tools, techniques, and metrics, and dashboards for insights and data visualization
  • Support practices, policies and operating procedures and ensures alignment to departmental objectives and strategy
  • Identifies applicable security/data standards when reviewing requirements and recommends controls to ensure compliance, Pro-actively monitors adherence of assigned systems to recommended security settings
  • Help define acceptance test objectives, test cases, and assist in system and integration testing
  • Build solid relationship with IT operational leaders to ensure connectivity to the business
  • Define best practices and standards for analyzing and processing data. Contribute to technical documentation of specifications and processes
  • Collaborate with teammates, stakeholders, and other teams to identify and address systems problems, provide input on current and new designs and resolve issues
  • Implements and continuously improves agile software delivery, code management, and operations practices.
Experience/Skills Requirements
  • Computer Science Bachelor's degree or equivalent.
  • 3+ years of ETL Development experience with Informatica PowerCenter
  • 3+ years of experience working with relational databases (ORACLE, DB2), Writing Complex SQL Queries
  • 3+ years of experience with data warehouses/marts, relational database architecture, design, and development
  • 1+ years of Python experience (used for test data management automation)
  • 2+ years of Unix scripting experience
  • 1+ years of experience with Informatica Intelligence Cloud (IICS)
  • Experience working in projects with agile/scrum methodologies
  • Research, writing, and communication skills
  • Ability to work in a team-oriented, fast-paced Agile environment managing multiple priorities
Nice to Have Skills
  • Healthcare Industry experience
  • Developing & implementing scalable cloud solutions to match the businesss changing needs
  • Experience with Business intelligence Tools e.g. MicroStrategy & Tableau for data mining, data profiling
  • Experience in complex projects with division or company-wide scope
  • Experience in Java application deployments, CI/CD pipeline , development experience in Java and knowledge of micro service architecture
  • Knowledge of Apache Kafka, and micro-service is a plus
  • Exposure & some experience in the following technologies
    • DevOps
    • Kafka

Required Skills : Informatica PowerCenter and some exposure to IICS PL/SQL Oracle Unix Shell Scripting
Basic Qualification :
Additional Skills : Contract to Hire
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :Contract to Hire
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :No
Candidate must be authorized to work without sponsorship :Yes
Interview times set :Yes
Type of project :Development/Engineering
Master Job Title :ETL Developer
Branch Code :Philadelphia

  • Informatica Developer Lead

    4 days ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    We are seeking an experienced Informatica Developer Lead to join our team at Saxon Global. As a key member of our Informatica development team, you will be responsible for leading the design, implementation, and testing of ETL processes using Informatica PowerCenter and PowerExchange.The ideal candidate will have 8+ years of experience in data warehousing...

  • Sr Informatica Developer

    5 months ago

    Horsham, United States Saxon Global Full time

    Client: United Health Group Title: Senior Informatica Developer Location: Horsham, PA (2 days' on-site is strongly preferred - if they can't find a local candidate they will consider East Coast candidate within 2-3 hours of Horsham, PA who can come in for major milestone meetings) Duration: Long Term Contract (right to hire for candidate who can...

  • Informatica Data Integration Specialist

    1 week ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    Are you looking for a challenging role that utilizes your skills in data transformation and migration? Saxon Global is seeking an experienced ETL Developer to join our team's Data Warehouse team. We are looking for a mid-level candidate with 3+ years of experience in ETL Development using Informatica PowerCenter.The ideal candidate will have experience...

  • ETL Developer Expert

    2 weeks ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    About the RoleWe are seeking an experienced ETL Developer to join our team in Philadelphia. This is a great opportunity to work with a dynamic company and contribute to the success of our Data Warehouse team.Job DescriptionThis is a mid-level position, requiring strong skills in Informatica PowerCenter, relational databases (ORACLE, DB2), and data...

  • Senior Database Developer

    2 weeks ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    Senior Database Developer - Horsham, PAThis Senior Database Developer position requires a strong background in SQL, Python, and Java development, as well as experience with Informatica and/or SSIS (ETL). The ideal candidate will have a bachelor's degree in Computer Science or a related field and 2-3 years of progressive post-baccalaureate experience in data...

  • Data Scientist

    4 weeks ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    Data Engineer Job DescriptionWe are seeking a skilled Data Engineer to join our team at Saxon Global in Horsham, PA. As a Data Engineer, you will be responsible for building and automating several applications within the data warehouse. Your core skills should include strong SQL experience, as well as proficiency in Python and Java. Experience with...

  • Data Transformation and Migration Expert

    4 days ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    About the JobSaxon Global is hiring an ETL Developer to work on our Data Warehouse team. As an ETL Developer, you will be responsible for data profiling and analysis, test data governance, and conducting ETL/DW, Test Repository Gold Copy optimization, troubleshooting, debugging, maintenance of Data Masking mapping & workflows.You will develop complex data...

  • Senior Data Engineer

    3 days ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    Saxon Global seeks an experienced Senior Data Engineer to lead our Informatica development efforts. This is a long-term contract position with the opportunity to convert to a full-time role.The ideal candidate will have 8+ years of experience in data warehousing and ETL, with a strong background in Informatica PowerCenter and PowerExchange. They will be...

  • Data Engineering Specialist

    2 weeks ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    Data Engineering SpecialistWe are seeking a highly skilled Data Engineering Specialist to join our team in Horsham, PA. This is a contact-to-hire role with excellent long-term growth opportunities.Responsibilities include building and automating applications within the data warehouse using strong SQL experience. Additionally, the ideal candidate will have...

  • Data Engineer

    5 months ago

    Horsham, United States Saxon Global Full time

    They need to be within 1-2 hours drive form Horsham, PA - the will need to be able to come on-site a few times a month' potentially once a week. Client: United Health Group Title: Data Engineer Location: Horsham, PA *** They need to be within 1-2 hours drive form Horsham, PA - the will need to be able to come on-site a few times a month'...

  • Enterprise Data Engineer

    3 weeks ago

    Horsham, Pennsylvania, United States Saxon Global Full time

    Enterprise Data EngineerWe are looking for an experienced Enterprise Data Engineer to join our team in Horsham, PA. This is a challenging role that requires a strong background in SQL, Python, and Java development, as well as experience with Informatica and/or SSIS (ETL).As an Enterprise Data Engineer, you will design, develop, and maintain large-scale data...

  • Salesforce Administrator

    2 weeks ago

    Horsham, United States FIRSTRUST SAVINGS BANK Full time

    Salesforce Administrator Location US-PA-Horsham Job ID 2024-2536 Positions 1 Objective As a member of the Enterprise Solutions Team, the primary responsibilities of the Salesforce Administrator are the management, optimization, and support of our FirstCLASS platform (powered by Salesforce) and its related platform apps including but not limited to:...

  • Salesforce Administrator

    1 month ago

    Horsham, United States FIRSTRUST SAVINGS BANK Full time

    Salesforce Administrator Location US-PA-Horsham Job ID 2024-2536 Positions 1 Objective As a member of the Enterprise Solutions Team, the primary responsibilities of the Salesforce Administrator are the management, optimization, and support of our FirstCLASS platform (powered by Salesforce) and its related platform apps including but not limited to:...