Mid-Senior ETL Informatica Developer- NY/NJ in Hoboken, NJ at Consultis

Date Posted: 7/10/2018

Job Snapshot

Job Description

  • Hard core rolling up sleeves in unit testing, smoke testing, make sure data gets loaded correctly.

Position Summary

We are looking for an ETL Informatica Developer to help elevate Data Meaning to the next level. We are seeking a team player that is motivated to learn and has a hunger to outwork the competition. The position is remote and contract-to-hire.

Key Responsibilities

  • Provide technical expertise and “hands on” participation in creating, maintaining and implementing enterprise data solutions.
  • Design, development, and delivery of data (both real-time and batch) from operational systems/flat files into a staging area, ODSs (operational data stores), Data Warehouse and downstream Data Marts. Expert in Informatica PowerCenter (PowerCenter Web Services Hub experience would be a plus)
  • Troubleshoot, optimize and tune ETL processes
  • Create and execute unit test plans based on system and validation requirements
  • Extensively worked with large databases in production environments
  • Working with various IT teams to analyze data in the data warehouse, data mart or operational systems
  • Review and analyze ETL requirements
  • Develop mapping/sessions/workflows
  • Maintain existing code and fix bugs when needed
  • Work on multiple projects simultaneously. Work independently and as a team lead, be responsible for working with application groups to gather requirements, creating logical data models, designing new database schema or re-use existing structures, determining data movement strategy as well as data availability and recoverability.
  • Adhere to and implement enterprise architecture concepts, principles and data access strategy with project deliverables.
  • Mentor and train other junior Informatica developers
  • Perform other duties as assigned.


  • Bachelor’s degree in Information Systems or Computer Science; MS is preferred
  • 5 years’ experience with development in Informatica
  • Applied experience in data architecture for data driven applications
  • Expert ability to interpret business concepts into data models and physical technical components
  • Experience in the delivery of the physical implementation of enterprise conceptual and logical data model solutions
  • Expert ability to design and develop data access methods and data views
  • Expert ability to design and implement operational data store solutions
  • Excellent communication skills, including technical writing, one on one interactions and the ability to clearly receive and convey information to a broader technical team
  • 5 + years’ experience with Oracle development including high level of expertise in SQL, stored procedures, indexes, partitioning, database design and tuning.
  • 3+ years of experience in designing multidimensional data warehouse structures such as star schemas, cubes etc
  • 2+ years of experience in working with MDM or Data Quality Management tools
  • Data Engineering – PL/SQL and SQL – Expert


  1. Software Engineer Jobs
  2. Project Engineer Jobs