Cloud ETL/Data Analyst - Des Moines, IA - Georgia IT Inc.
Des Moines, IA
About the Job
Cloud ETL/Data Analyst
Location: Des Moines, IA
Duration: Contract
Rate: DOE
US citizen and those authorized to work in the US are encouraged to apply. No sponsorship available for this contract to hire job.
Required:
Location: Des Moines, IA
Duration: Contract
Rate: DOE
US citizen and those authorized to work in the US are encouraged to apply. No sponsorship available for this contract to hire job.
Required:
- BS/BA degree and 5+ years of experience developing data warehouse solutions required; or equivalent levels of relevant education and experience.
- Data Warehouse Development & Design Experience
- Experience writing Source To Target mapping documents for ETL/ELT logic
- Experience with SQL and Python
- Experience working on ELT Technologies like Informatica
- Cloud Data Warehousing experience on AWS and any MPP Databases like Teradata, Snowflake, Exasol, Redshift etc.
- Strong understanding of scientific data and translating them to SQL Logic to load the data to our Cloud Data Warehousing platform.
- Develop ETL Mappings using SQL, Informatica, AWS, MPP Databases like Teradata, Exasol, Snowflake, Redshift or others.
- Ability to drive the Source to Target Mapping Specifications process
- Drive the understanding/validation of data
- Client/Mitigate/Validate problematic data and communicate with Source Teams and Data Warehouse Team
- Develop Data Migration solutions for disparate data sources
- Define and communicate cleaning and filtering requirements on data sources
- Identify integration points of new data sources with existing data and define integration mappings
Source : Georgia IT Inc.