Remoteville

Remote Senior ETL Development Lead Job in United States Artmac

Senior ETL Development Lead Artmac
Informatica PowerCenter SQL scripting Oracle DB Netezza Teradata Data warehousing
United States


Digital,Consulting & Managment
35+ employees
B2BConsultingSaaSTechnology


Role


Who you are

  • 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

Desirables

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


What the job involves

  • 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

Share this job

Hide company

More jobs at Artmac

Company


Company mission

Artmac provides Digital, consulting and Management IT services to clients globally - As your trusted partner, let’s reimagine how your business gets done. Merging your vision and our expertise, we help you achieve powerful results.It’s our mission to help our customers achieve success. That can only be accomplished through strong, lasting relationships. Artmac offers a wide array of solutions for a range of key verticals and horizontals.Starting from the strategy consulting right through to implementing IT solutions for clients. We provide solutions for a dynamic environment where business and technology strategies converge. As partners to conceptualize and realize technology driven business transformation initiatives. With a world-class infrastructure and a global network, Artmac offers a wide array of solutions for a range of key verticals and horizontals..



Company benefits

  • Remote work
  • Opportunities for travel
  • Work in the Health Care domain


Company values

  • Artmac provides Digital, consulting and Management IT services to clients globally - As your trusted partner, let’s reimagine how your business gets done. Merging your vision and our expertise, we help you achieve powerful results.It’s our mission to help our customers achieve success. That can only be accomplished through strong, lasting relationships. Artmac offers a wide array of solutions for a range of key verticals and horizontals.Starting from the strategy consulting right through to implementing IT solutions for clients. We provide solutions for a dynamic environment where business and technology strategies converge. As partners to conceptualize and realize technology driven business transformation initiatives. With a world-class infrastructure and a global network, Artmac offers a wide array of solutions for a range of key verticals and horizontals..


Company HQ

Atlanta
;