RRemoteville

How Remoteville checks and expires listings

Artmac logoArtmac

Senior ETL Development Lead

Skills
Informatica PowerCenterSQL scriptingOracle DBNetezzaTeradataData warehousing
Role

What the job involves

The main requirements, responsibilities and hiring steps.

Requirements

  • More than 10 Years of work experience
  • Experience in Technology Consulting is important
  • Responsible for the day-to-day development process and overseeing the implementation of the technical design
  • Develop a deep understanding of systems and processes to extract insights from existing data leveraging rigorous project management discipline to ensure the highest possible quality of delivery while managing team capacity
  • Conduct business due diligence activities to identify analytics opportunities for transformation
  • Should be willing to work Afternoon Shifts (1:30 pm to 10:30 pm IST) (only for offshore)
  • Traveling within and outside of India on a short-term or long-term basis (only for offshore)
  • Ability to manage high volume and high complexity data projects across multiple delivery locations in a virtual environment with excellent client communication skills
  • Strong problem-solving and conceptual thinking abilities
  • Ability to work in a fast-paced and deadline-driven environment and mentor team members
  • Health Care Domain Experience Is Mandatory
  • Expert in Informatica PowerCenter, SQL scripting (Stored Procedure, Triggers, Cursors, Functions), and Oracle DB
  • Complex SQL - Very Strong in SQL, data profiling and data analysis
  • ETL Design Document – The candidate must have strong experience in creating design documents for a minimum of 3 to 4 years
  • Strong in ETL design, performance tuning, and index optimization
  • Netezza or Teradata – Candidate must have experience in Netezza OR Teradata database
  • Informatica Development – The candidate must have strong experience and knowledge of end-to-end Data warehousing concepts with hands-on exp in development
  • Good Knowledge of Denodo and Tidal would be a huge plus
  • Good Knowledge of Unix Shell scripting, JIRA, and Confluence
  • Good knowledge of IBM Infosphere MDM
  • Designing the Data transformation process, exceptions handling, job scheduling
  • Deploy, Run, and Debug the ETL engine running the scripts built by the ETL Engineering team

Nice to have

  • Strong problem-solving and conceptual thinking abilities
  • Health Care Domain Experience

Day to day

  • Oversee the day-to-day development process and implement technical designs
  • Extract insights from existing data and ensure the highest quality of delivery while managing team capacity
  • Conduct business due diligence to identify analytics opportunities for transformation