Senior-Level Data Engineer- Chicago, IL- Local only

Hello Folks,

 

Hope you are doing great!

 

This is Himank Jani from ApTask.

 

We have urgent requirements with one of our client’s, please review the job description below and let me know if you have any relevant candidates on your bench, Kindly share.

 

The candidate should not be submitted to Hexaware within last 3 months.

Need Minimum 8+ Years Experienced Candidates

 

Role: ETL SSIS Developer

Location: Chicago, IL (Local Candidates needed)       

Client: Hexaware

No. of positions: 2

 

Job Description

Primary Skills: Data warehousing, ETL, SSIS, Data model, MSBI and Python

 

Responsibilities:

• Bachelors with 7+ or Masters with 5+ experience in Computer Science, Engineering, Math or other quantitative field.
• 7+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class standards offering high performance.
• 7+ experience writing and optimizing SQL queries and stored Procedures for Data Processing and Data Analysis.
• 7+ years of Experience in designing and building complete data pipelines, moving and transforming data for ODS, Staging, Data Warehousing and Data Marts using  SQL Server Integration Services (ETL) or other related technologies.
• 7 + years' experience Implementing Data Warehouse solutions (Star Schema, Snowflake schema) for reporting and analytical applications using SQL Server and SSIS ,or other related technologies.
• 5+ years' Experience with large-scale data processing and query optimization techniques using TSQL.
• 5+ years' Experience with implementing audit, balance and control mechanism in data solutions
• 3+ year experience with any source control repos like GIT, TFVC or Azure DevOps , including branching and merging and implement CICD pipelines for database and ETL workloads.
• 2+ experience working with Python Pandas libraries to process semi structured data sets, and load them to SQL Server DB.
• Strong understanding of DW concepts including 3NF and Dimensional data models.
• 5+ years' experience with  Data Modeling techniques in Data Warehousing projects using any tool like Erwin, Visio, ER studio.
• Has in-depth knowledge of ETL Design Patterns, Optimal Data Flow mechanisms and SQL development best practices.
• Perform peer reviews and take ownership of the data processes to ensure quality of data in data warehouse, downstream data marts.
• Experience working on Banking and Financial domain is preferred.
• Experience with mentoring team members, guide them to follow best practices.
• Must be self-directed and have excellent initiative and organization skills.

 

 

 

Regards,

 

Himank Jani

Technical Recruiter

ApTask is a global, diversity certified staffing and recruiting company that specializes in IT, finance and accounting, and blockchain developer placements.

 

Fintech Consulting LLC DBA ApTask  

Connect: 732 466 7258 | himankj@aptask.com

Address: 120 Wood Ave South, Iselin, NJ 08830 

|  |  ||  

For any questions or assistance please send an email to help@aptask.com

 

Candidate Data Collection Disclaimer:

At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.

 

If you have any concerns or queries about your personal information, please feel free to contact our recruitment team at businessexcellence@aptask.com.

 

This e-mail and any attachments may be confidential, proprietary or legally privileged. Any review, use, disclosure, distribution or copying of this e-mail is prohibited except by or on behalf of the intended recipient. If you received this message in error or are not the intended recipient, please delete or destroy the e-mail message and any attachments or copies and notify the sender of the erroneous delivery by return e-mail. It shall not attach any liability on the sender or ApTask or its affiliates. Any views or opinions presented in this email are solely those of the sender and may not necessarily reflect the opinions of ApTask or its affiliates.