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
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..