What are the responsibilities and job description for the ETL Engineer position at Computer Task Group, Inc?
OverviewCTG is seeking to fill an ETL Engineer position for our client.Location: New York, NYDuration: Ongoing ContractDuties:Design, build, and maintain ETL pipelines from scratch using Python.Develop efficient, reusable code for data ingestion, cleansing, governance, and reporting.Write and optimize SQL queries, stored procedures, and DB objects across MS SQL, Oracle, DB2, and Postgres.Implement data modeling, schemas, and entity relationships.Develop Airflow DAGs for workflow orchestration.Work with BigQuery, Databricks, Delta Lake, Node.js, JSON, and NoSQL databases.Learn and adopt new cloud-based business apps and tools.Onsite 3 days/week at Amex Tower (NYC metro area).Skills:Python, PySpark, MS SQL (SSIS/SSRS), Oracle PL/SQL, RDBMS, Big Data, ETL/Data Warehousing, Data Analytics, Node.js, JSON, NoSQL, Airflow; familiarity with Spark is a plus.Experience:Independent contributor capable of writing code and ETL pipelines from scratch.Expert in SQL, OOP, data modeling, and big data platforms.Strong analytical and problem-solving skills.Education:Bachelor’s degree in Computer Science, IT, or related field preferred, or equivalent experience.Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.To Apply:To be considered, please apply directly to this requisition using the link provided. For additional information, please contact JoAnn Abramo at JoAnn.Abramo@ctg.com. Kindly forward this to any other interested parties. Thank you!