Senior ETL Designer

Headway tek; Town of Texas (WI); Remote; USD 130,000 - 140,000; Full time

Job summary

A leading company in the tech industry is seeking an experienced Data Architect to design and implement ETL/ELT solutions using GCP's data services. The role involves creating data pipelines, ensuring data quality, and developing scalable solutions. Ideal candidates will have strong experience with Informatica and cloud technologies, and will be responsible for data governance and security best practices. This remote position offers a competitive salary and comprehensive benefits.

Benefits

Medical Insurance

Vision Insurance

Dental Insurance

Life Insurance

Disability Insurance

Paid Time Off

Parental Leave

Sick Leave

Qualifications

• Experience in architecting ETL/ELT solutions using GCP's data services.
• Proficiency in designing and developing Informatica mappings and workflows.

Responsibilities

• Architect and implement ETL/ELT solutions using GCP's data services.
• Create efficient data pipelines integrating various data sources.
• Implement data quality checks and validation frameworks.

Skills

Data Governance

Data Quality Checks

Cloud Solutions

ETL Solutions

Data Pipeline Development

Tools

Informatica PowerCenter

GCP

BigQuery

Cloud Composer

Job description

Location : Across USA any Location (Remote)

Rate : 70-75 / C2C

The pay range for this role is $130k - $140k per annum including any bonuses or variable pay, or 75-80 / hr for subcontractors. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance, and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience, and location of the candidate.

Job Description

• Architect and implement ETL / ELT solutions using GCP's data services (Dataflow, Cloud Data Fusion, Dataproc).
• Design and develop Informatica PowerCenter and Informatica Cloud mappings and workflows.
• Create efficient data pipelines integrating various data sources including structured, semi-structured, and unstructured data.
• Implement data quality checks and validation frameworks.
• Work with BigQuery.
• Utilize Cloud Composer (Apache Airflow).
• Implement Dataflow solutions.
• Develop hybrid cloud solutions connecting on-premise Informatica systems with GCP services.
• Create detailed technical specifications and design documents.
• Develop data models and mapping documents.
• Design scalable and maintainable ETL frameworks.
• Implement best practices for data governance and security.