Job details for
Consultant, Senior ETL/Informatica Engineer

Consultant, Senior ETL/Informatica Engineer

Job Info

Category: Data
Company Description: Leading global provider of data, news and analytics
Salary: Highly Competitive, Depending on Experience
Position Type: Contract
Job Number: 10874

Job Description

Are you a hands-on Senior ETL architect and developer who is excited to tackle the challenges that come with working on large volumes of diverse data with complex business rules? A key objective of this role is for you to help is to build an enterprise level data analytics platform using industry standard concepts against our Data Warehouse, Data Lake, and Big Data environments. Are you excited to innovate in an environment that combines traditional warehouse technologies, MPP databases and Hadoop?

In order to be successful:

  • You should have a working knowledge of industry standard Data Infrastructure (e.g. Warehouse, BI, Analytics, Big-Data, etc.) tools with the goal of providing end users with analytics at the speed of thought.
  • You should be proficient at developing, architecting, standardizing and supporting technology platforms using Industry leading ETL solutions.
  • You should thrive in building scalable, high throughput systems that process more than 10 billion data points a day.
  • You must have strong communication, presentation, problem-solving, and trouble-shooting skills.
  • You should have experience with agile BI & ETL practices to assist with the interim Data preparation for Data Discovery & self-service needs.
  • You should be highly motivated to drive innovations company-wide.

You'll need to Have:

  • 5+ years of experience in ETL tools. Specific expertise in implementing Informatica in an Enterprise environment is a plus.
  • Advanced SQL capabilities are required. Knowledge of database design techniques and experience working with extremely large data volumes is a plus.
  • Strong understanding of data warehousing methodologies, ETL processing and dimensional data modeling.
  • Demonstrated experience and ability to work with business users to gather requirements and manage scope.
  • Experience programming in a Linux/UNIX environment including shell scripting.
  • Programming experience in Python.

We'd love to see:

  • Experience with large database and DW Implementation (20+ TBs)
  • Understanding of VLDB performance aspects, such as table partitioning, sharding, table distribution and optimization techniques
  • Experience working in a big data environment with technologies such as Hadoop, Spark, and HIVE.
  • Programming experience, including Java, C++, ksh
  • Knowledge of reporting tools such as QlikSense, Tableau, Cognos



Andiamo is an Equal Opportunity Employer

Andiamo provides equal employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Andiamo complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

All qualified candidates are encouraged to apply by submitting their resume as an MS word document including a cover letter with a summary of relevant qualifications, highlighting clearly any special or relevant experience.
Alex  Nevins

Alex Nevins

Technology Recruiter & Account Manager

Contact Recruiter

17 State Street, 8th floor
New York, New York 10004

Please Note: All inquiries will be treated with the utmost confidentiality. Your resume will not be submitted to any client company without your prior knowledge and consent.

Contact Us