Share this Job

ETL Engineer

Apply now »

Date: Aug 21, 2021

Location: Guadalajara, JAL, MX

Company: NTT DATA Services

Req ID: 128040 

NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a ETL Engineer to join our team in Guadalajara, Jalisco (MX-JAL), Mexico (MX).

Job Description

Hashmap advises, architects, selects, and implements solutions for clients so that they may efficiently run their businesses, with a focus on data analytics in the Cloud.
These service areas span IoT, Solution Architecture, data engineering, analytics, AI, ML, and DevOps. 
We are looking for a Data Engineer (ETL) with 1 to 5 years of work experience with at-least 2-3 implementation project experience,  to join our growing Hashmap team of data professionals.
The hire will be responsible for expanding and optimizing our data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams.
The ideal candidate will be well versed in SQL, Data Warehousing principles & practices, and the use of ETL Tools on-premises and potentially in cloud.
The Data Engineer (ETL) will support our software developers, database architects, data analysts, and data scientists on

data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.
They must be quick learners, self-directed and comfortable supporting the data needs of multiple teams, systems, and products.
The right candidate will be excited by both green-field and large-scale migration projects - learning and using new tools - and ready to drive their personal growth.

Major Duties & Responsibilities

Develop, construct, test and maintain ETL/ELT architectures

Work with Architects to ensure development work aligns with business requirements

Data acquisition and ingestion for ETL data pipelines.

Utilize ETL tools e.g. Informatica or DataStage or Fivetran or, dbt or, Matallion to build and deploy data ingestion and transformation pipelines.
One or more ETL tools will be used for the purpose of constructing ETL pipelines in the cloud.

Use enterprise orchestration tools e.g. CA7 or Control M etc. for scheduling ETL jobs.

Migrate ETL to ELT paradigm for data pipelines.

Translate ETL from Source to Target documentation and from one ETL tool to another.

Will be responsible for conversion and/or development of ETL packages

Identify ways to improve data reliability, efficiency and quality

Deliver updates to stakeholders based on analytics

Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution

Analyze & translate functional specifications & change requests into technical specifications

Develop, test & implement program logic

Translate business needs into end user applications

Other Hashmap responsibilities:

Must be an good communicator in terms of status and raising issues that might impact projects to either project or account management

While not engaged, work on internal projects and learning exercises to

Extend your technical knowledge and skills by working with standard stack and new tools

Work on internal tech aimed to help build new technical practices

Participation is encouraged to assigned training and obtain certifications as identified by the ITT department and/or Hashmap Professional Growth Manager

Skill Sets for Role:

Soft Skills Required:

High level of personal initiative and energy

Very good verbal and written communication english skills

Capable of working autonomously with minimal oversight

Willing to raise issues to Hashmap or client management as required, clearly defining the issue and potential solutions

Common sense approach to problems

Capable of adapting written processes when required and capturing improvements to the process for later review

Ability to adapt to a fast paced environment with high tolerance to change management

Comfortable in working in a virtual environment (i.e. conference calls)

Self motivated, autonomous, curious and analytical and results oriented in nature

Technical Skill Sets (Mandatory):

Experience with implementing (developing and deploying ) ETL solutions using technologies such as Informatica, Talend, Pentaho, Datastage, SSIS etc. into Oracle exadata, Netezza or Teradata. Either one or more of the representative technologies (a combination thereof) is required.

Good working experience using SQL (2-4 years)

Sound experience around data warehousing fundamentals

e.g. Star schema, slowly changing dimensions, change data capture, late arriving foreign keys, data pipeline parallelism, optimized target load strategies etc.

Experience gathering and tracking requirements

Highly analytical and curious

Demonstrated problem solving skills

Ability to influence internal and external teams

Confident and demonstrate strong leadership

Ability to adapt to a fast paced environment with high tolerance to change management

Results oriented, self motivated, autonomous and comfortable in working in a virtual environment (i.e. conference calls)

Knowledge of the following would be an asset:

Open source contributions of any sort

Experience with cloud data warehouses – Snowflake, AWS Redshift, Azure Synapse, or Google BigQuery experience

Experience with a variety of different technologies;, Fivetran, Matillion, dbt

Nice to have, at least one project where they implemented the full cloud data pipeline documented on their resume

Data cataloging and governance techniques

Strong Agile methodology knowledge

Drive for continuous process improvement

Travel Expectations:

Remote position - no travel is expected on a regular basis

About NTT DATA Services

NTT DATA Services is a global business and IT services provider specializing in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. We are part of the NTT family of companies, a partner to 85 % of the Fortune 100.

NTT DATA Services is an equal opportunity employer and will consider all qualified applicants for employment without regard to race, gender, disability, age, veteran-status, sexual orientation, gender identity, or any other class protected by law.

Job Segment: Consulting, Database, Oracle, Data Warehouse, Business Intelligence, Technology