ETL Informatica SQL Developer / Script Writer

As a key member of the Software development team, you will be responsible for the delivery of high quality, reliable, sustainable software to satisfy technical designs for the customer solutions. This role is high paced and requires self-discipline to work remotely and meet delivery schedules.

  • Support production incidents for enterprise data warehouse
  • Troubleshoot and resolve complex application issues as needed
  • Work closely with teams to turn technical project requirements into functioning code
  • Develop enhancements to applications using leading software principles
  • Experience in uncovering requirements, conceptualizing solutions, and developing a framework for implementation of a data warehouse, data mart, or data web on at least one other project or work assignment
  • Working knowledge of fundamental concepts, practices, and procedures of data warehousing
  • Experience with data extraction, manipulation, and cleansing tools
  • Knowledge of database design, with emphasis on data warehousing, OLAP, star schemas or reporting cubes
  • Knowledge of software development and database structures
  • Develop, test and implement software components
  • Define and document requirements and develop supportable application solutions to automate business processes
  • Collaborate with end-users, business analysts, and systems analysts to determine features, requirements and solution design
  • Adhere to industry standard established design, coding, naming and standards
  • Participate in code reviews and apply corrections as required
  • Adhere to change control processes
  • Write/revise documentation including operations and user guidelines
  • Gather and drive stakeholder requirements and product vision through the planning, analysis, development, and testing phases
  • Possess a thorough understanding of the data, sources of data, and relationships of data

Minimum Criteria

  • 8+ years database data warehouse development role
  • Extensive knowledge of data warehousing, data marts and concepts
  • Informatica 9.6+ including functional experience with PDO (push down optimization)
  • Expert knowledge of SQL Server, Oracle
  • Ability to write complex SQL Statements for ETL/ELT processing
  • Functional experience with Unix Shell Scripting
  • Hands on Netezza/Teradata/Exodata/GreenPlum (including tools and utilities) experience desirable
  • Excellent oral and written communication skills
  • Work well independently and remote
  • Ability to collaborate effectively and work as part of a team
  • Strong attention to detail
  • Or an equivalent combination of education, training and experience
  • Expert knowledge of Object-Oriented Programming, ETL tools such as DataStage, and/or other package software applications
  • Proficiency with Microsoft suite of tools
  • Problem-solving skills and proven record of working well in a team environment
  • ETL Specific: Expert knowledge/experience in DataStage, AIX and Korn Shell scripting
  • Health Insurance experience desirable

Education Requirements

  • Bachelor’s degree in STEM
  • BA/BS in Computer Science or related field, or an equivalent combination of education and/or experience, preferred


Apply