| Data Engineer (Advanced SQL, ETL) -- Once in a week in office || Ann Arbor, MI at Ann Arbor, Michigan, USA |
| Email: [email protected] |
| From: Yashwant Singh, DMS Visions Inc [email protected] Reply to: [email protected] Hi, Hope you are doing well, Please find the job description given below and let me know your interest. Position: Data Engineer (Advanced SQL / ETL) (Hybrid) Location: Ann Arbor, MI Once/week in office Duration: 12+ Months Job Description: Data Engineer (SQL query optimization / Talend / SQL Server) SQL Query/optimization experience, writing and optimizing SQL queries ( ADVANCED) including Common Table Expression (CTE) Working on-prem with SQL Server DB is a must! Azure is just a plus! Experience in Data Warehouse Environment Interview Process: 1st round - 30 minute call 2nd round - 60 minute deep technical dive with hands-on SQL test Job Description The data engineering specialist will primarily focus on development of large volume information ingestion and transformation. This position is responsible for orchestrating data interfaces into (and out of) our Enterprise Data Warehouse using Talend, SQL, Python and other data engineering solutions. Qualifications Understanding and Hands-on experience with key technologies (SQL, ETL, Data modeling, data processing) Strong SQL skills with Relational DBMS technology - SQL Server- SQL Server experience, writing and optimizing SQL queries (Advanced) 2-4 yrs Hands-on experience with ETL tools - Talend is preferred. Informatica or DataStage will also work as long as candidate has solid Java backend experience. Good understanding and expertise in relational database concepts and data processing concepts Experience in handling multiple data formats (Delimited file, JSON, XML etc.) Nice to have Kafka Azure ( Data Lake) Databricks Exp working with customer/consumer data Salesforce Market Cloud CDP - customer data platform Marketing, HR, supply chain Exp working with vendor UKG (HR, payroll & workforce management provider) Knowledge of CRM, MDM, HR Reporting and Business Intelligence a plus General Responsibilities Design and develop ETL (Talend) / SQL / Python based processes to perform complex data transformation processes. Design, code, and test major data processing features, as well as work jointly with other team members to provide complex software enhancements for the enterprise data storage platforms (RDBMS and No-SQL platforms). Build Data Integration solutions to handle batch / streaming / IoT data on ETL, Big-Data platforms. Develop and Deliver changes in the Enterprise Data Warehouse according to Data Warehousing best practices. Gather requirements and construct documentation to aid in maintenance and code reuse in accordance with team processes and standards. Monitor scheduled jobs and improve reliability of ongoing processing Monitor, measure, and enhance ways to improve system performance. Ability to multi-task deliverables and manage them in an efficient manner. If you are interested, please share your updated resume and suggest the best number & time to connect with you Thanks & Regards, Yashwant Singh US IT Recruiter, DMS VISIONS Inc. 9726455050 | dmsvisions.com/ [email protected] 4645 Avon Lane, Suite 210, Frisco, TX 75033 Keywords: database information technology Michigan Texas |
| [email protected] View all |
| Tue Jan 09 23:55:00 UTC 2024 |