Role: ETL Architect
Location: Chicago, IL (Hybrid)
Hexaware
Data Engineering Tech Lead – Preferred On-shore however if a strong resource can be off-shore.
The key here is that we would like this resource to be a lead and manage the off-shore Data Engineering resources.
Thus if on-shore / near shore would be expected to cover and work with the off-shore resources (meaning really be working their hours).
a. Types of skills would be the very strong general Data Engineering skills similar to the skills that client has communicated earlier. In addition, the resource would be a leader, thus Problem solving, quick learner, strong communicator (Written and oral) and ability to assess resources and train / coach / guide. There is also a need for a level of independence and ability to work in various grey areas toward our architecture.
b. The volume, frequency and breadth of work that comes to the team is large. Being able to delegate and guide and react / plan are crucial.
Responsibilities
- Bachelors with 12+ or Masters with 7+ experience in Computer Science, Engineering, Math or other quantitative field.
- 12+ 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.
- 12+ experience writing and optimizing SQL queries and stored Procedures for Data Processing and Data Analysis.
- 12+ 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.
- 12+ 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
Sagar Bhardwaj
Sr. Technical Recruiter
300 Alexander Park |Suite #200|Princeton , NJ 08540
Office: +1 7324521006 Ext238
Email: [email protected]| URL: http://www.diverselynx.com