Informatica Developer in Charlotte, NC at Signature Consultants

Date Posted: 6/17/2020

Job Snapshot

Job Description

Informatica Developer Summary:

Signature Consultants is seeking a Informatica Developer for an opportunity in Charlotte, NC. The individual selected for this role will be experienced in Informatica and possess strong Oracle and data warehousing skills as well as be well versed in the Agile software development lifecycle methodology. The developer will be a member of an Agile scrum team and will work closely with an on-shore product lead and developers as well as off-shore developers and testers. The developer will participate in all relevant Agile ceremonies; some after hours support in the form of validating deployments and troubleshooting production issues may be required. This position typically requires 5 - 7 years of relevant experience.

Required Skills:

  • ETL Development using Informatica PowerCenter v10x
  • Experience with working with data sets from multiple sources (Flat Files, Oracle, Netezza, Teradata, SQL Server, etc.)
  • Experience with complex transformations including Update Strategies, Unions, Routers, Normalizers, and custom calculated fields
  • Slowly Changing Dimensions
  • UNIX shell scripting
  • Data Warehousing concepts
  • Star/Snowflake schemas
  • Dimensional tables (Type 1, Type 2)
  • AutoSys
  • Strong verbal and written communication skills
  • Strong problem solving skills
  • Ability to collaborate with the team but also independently recommend and deliver solutions to complex use cases
  • Ability to meet deadlines with attention to detail and accuracy
  • The ideal candidate will be 'naturally curious' with an inclination towards evaluating contemporary tools and technologies in support of continuously improving the platform.

Required Skills:

  • 5+ years' experience in Informatica PowerCenter (9x/10x)
  • 5+ years' experience in a large Data Warehouse environment
  • 5+ years' experience in Oracle
  • 4+ years' experience in complex data architecture solutions comprising the various phases of planning, design and implementation
  • 2-3 years' experience with various scripting languages, preferably Python
  • 2-3 years' experience with scheduling tools such as Autosys, TIDAL etc.

Desired Skills:

  • ETL experience with Oracle Exadata and Informatica PowerCenter
  • Experience working at financial institutions in the global banking and markets domain

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.