This site uses cookies. To find out more, see our Cookies Policy

Informatica ETL Developer in Hoboken, NJ at ConsultNet

Date Posted: 5/21/2019

Job Snapshot

Job Description

Title:  Informatica ETL Developer
Location:  Hoboken, NJ
Duration:  6+ months

Job Summary:

The ETL developer will work as part of the Project Work Stream team. They will have strong data processes and integration experience to contribute toward the success of our technology initiatives. The role will primarily be responsible for implementing ETL processes using a variety of source data on multiple data warehouse implementations supporting multiple products. They will participate in the in requirements definition, solution development and the implementation phases of data warehouse and reporting projects. They will create and maintain ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows), etc.  
  • Designs, develops, automates, and supports complex applications to extract, transform, and load data.
  • Ensures data quality.
  • Develops logical and physical dataflow models for ETL applications.
  • Codes, tests, implements, and automates complex processes.
  • Plans and conducts ETL unit and development tests; monitors results and takes corrective action.
  • Translates data access, transformation, and movement requirements into functional requirements and mapping designs.
  • Designs automation processes to control data access, transformation, and movement.
  • Ensures source system data availability and update accessibility, data integrity, restart ability, and error handling.
  • Investigate, analyze, and resolve complex technical problems related to system functions, environment, and procedures.
  • Identifies and manages interfaces, service levels, standards, and configurations.
Other Functions
  • Participates in the overall development process via architecture guidance, design and code reviews, and estimation and planning assistance
  • Performs other related duties as required
Required Knowledge, Skills, And Abilities
  • Experience with Informatica Power Center designing and developing complex ETL packages.
  • Strong preference for Candidate with experience working with Informatica Cloud Data Integration platform (IICS) for ETL & other such data processing applications.
  • Ability to work with Oracle, SQL Server or Postgres databases. Experience with writing and debugging complex SQL queries.
  • Experience in working on ETL development with API based integration around Salesforce & other such Cloud platforms is a big plus.
  • Ability to document and troubleshoot problems and effectively communicate with business and technical team members at all levels
  • Ability to manage multiple tasks simultaneously
  • Expertise in one or more of the following areas: Informatica Power Center, Informatica Cloud Data Integration, Informatica Data Quality.
  • Experience in writing and debugging complex SQL queries
  • Experience in DW multi-dimensional modeling
  • Extensive experience in query and database access tools, relational databases, technical troubleshooting, database design, data warehousing, application testing, system testing, implementation, and application development tools.
  • Must be a self-starter and can operate independently with minimal supervision as well as work closely with our team and very comfortable with working alongside senior leader in the group.
  • Strong analytical, communication and interpersonal skills.
  • Excellent and proven collaboration skills
  • Demonstrated financial and operational integrity.
  • Understanding of the Project Delivery Framework and SDLC
  • Understanding of Waterfall and Agile Project Management Methodology
  • Mapping capabilities (systems, processes, etc.) to requirements to ensure that department/project needs/goals are met.
  • Strong meeting facilitation skills.
Excellent interpersonal and communication skills; Strong analytical skills and detail oriented;
Ability to multitask a must – ex. Being on top of many things at one time.  
Excellent problem-solving skills; Professionally assertive and collegial
Proficient in Microsoft Office applications (Access, Excel, PowerPoint), and at least an understanding of financial applications.
Stable career history - Strong willingness and desire to perform in a fast-paced environment!
Be a part of the ConsultNet difference. As a leading national provider of IT staffing and solutions, ConsultNet delivers exceptional services to startup, midmarket and Fortune 1000 companies across North America. Since 1996, we've partnered with clients to create rewarding opportunities for our consultants, successfully building teams that have surefire results.
In the past two years alone, we have placed more than 1,500 consultants in contract, contract-to-hire, or direct placement opportunities. We understand communication is key to finding the right job that matches your skills and career goals. For us, it's not just the work that we do; it's how we do the work. Our breadth of offerings extends to multiple IT positions in major markets throughout the country, see more at