Technology Lead | Database Administration | Teradata Administration

IMCS Group Inc

Peoria, IL

Apply

JOB DETAILS

SKILLS

AWS Lambda, Acceptance Testing, Amazon Simple Notification Service (SNS), Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Architectural Design, Architectural Services, Automation, Best Practices, Business Analysis, Call Centers, Cloud Computing, Code Reviews, Coding Standards, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Customer Support/Service, Data Management, Data Modeling, Data Quality, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Design Document, DevOps, Diversity Recruiting, Documentation, Ecosystems, Emerging Technology, Enterprise Architecture, Failover, Finance, Fortune 500 Customers, Git, GitHub, Health Information Technology, IBM WebSphere DataStage, Identify Issues, Incident Management, Integration Testing, Knowledge Transfer, Low-Level Design, Mentoring, NCR Teradata, Offshoring, Performance Tuning/Optimization, Problem Solving Skills, Process Improvement, Production Support, Project/Program Management, Python Programming/Scripting Language, Quality Assurance, Requirements Management, Root Cause Analysis, SQL (Structured Query Language), Scalable System Development, Security Architecture, Service Level Agreement (SLA), Simple Queue Service (SQS), Snowflake Schema, Software Engineering, Source Code/Configuration Management (SCM), Stored Procedures, System Integration (SI), Technical Leadership, Technical Strategy, Technical/Engineering Design, Testing, Unit Test

LOCATION

Peoria, IL

POSTED

30 days ago

Company Description: IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs. IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical. We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients.

Description: POC: Sam Chavez

ATTENTION ALL SUPPLIERS!!!

READ BEFORE SUBMITTING
" UPDATED CONTACT NUMBER and EMAIL ID is a MANDATORY REQUEST from our client for all the submissions
" Limited to 1 submission per supplier. Please submit your best.
" We prioritize endorsing those with complete and accurate information
" Avoid submitting duplicate profiles. We will Reject/Disqualify immediately.
" Make sure that candidate's interview schedules are updated. Please inform the candidate to keep their lines open.
" Please submit profiles within the max proposed rate***
" Please make sure to TAG the profiles correctly if the candidate has WORKED FOR *** as a SUBCON or FTE.
MANDATORY: Please include in the resume the candidate s complete & updated contact information (Phone number, Email address and Skype ID) as well as a set of 5 interview timeslots over a 72-hour period after submitting the profile when the hiring managers could potentially reach to them. PROFILES WITHOUT THE REQUIRED DETAILS and TIME SLOTS will be REJECTED.

Job Title: Technology Lead | Database Administration | Teradata Administration -- Senior Data & Integration Engineer/Designer/Architect
Work Location & Reporting Address: Peoria, IL 61630 (Onsite-Hybrid. Will consider candidates willing to relocate to client s location)
Contract duration: 12
MAX VENDOR RATE: *** per hour max
Target Start Date: 05 May 2026
Does this position require Visa independent candidates only? Yes

Must Have Skills:
SnapLogic
AWS
Python
Snowflake
DataStage

Nice to Have Skills:
GitHub CI/CD integration

Detailed Job Description:
Design Responsibilities
Solution & Technical Design
1.Translate business requirements into scalable, maintainable, and secure technical designs across DataStage, SnapLogic, AWS, Python, and Snowflake ecosystems.
2.Create high-level and low-level design documents covering data flows, mappings, process orchestration, and integration patterns.
3.Develop data models, transformation logic, and interface specifications for batch, real-time, and event-driven pipelines.
4.Ensure designs align with enterprise architecture standards, security guidelines, and best practices.
5.Collaborate with product owners, analysts, and architects to finalize solution design and validate technical feasibility.

Senior Development Responsibilities
Hands-on Development & Implementation
1.Build and enhance ETL/ELT pipelines in IBM DataStage, SnapLogic, and Python.
2.Develop scalable Snowflake SQL, stored procedures, and performance-optimized ELT logic.
3.Implement AWS services (Lambda, S3, SNS, SQS, IAM, CloudWatch,Cloudformation, EventBridge) as part of cloud-native data pipelines.
4.Code reusable frameworks, utilities, and components to accelerate team productivity.
5.Conduct peer code reviews, mentor team members, and establish coding standards.

Quality & Delivery
1.Perform unit testing and support integration/UAT activities.
2.Optimize workflows for performance, cost-efficiency, and maintainability.
3.Ensure version control, CI/CD integration, and documentation are consistently maintained.
4.GitHub CI/CD integration

Production Support & Issue Resolution Responsibilities
Incident & Problem Management
1.Serve as the point for any production issues across DataStage, SnapLogic, Snowflake, AWS, and Tidal.
2.Responsible for analyzing and fixing production issues in any system.
3.Analyze root causes, identify systemic issues, and propose permanent fixes.
4.Develop automated monitoring, alerting, using Python/AWS.

Stability & Reliability
1.Work closely with operations teams to ensure SLAs, uptime, and performance thresholds are met.
2.Improve recovery processes, failover mechanisms, and operational resiliency.
3.Troubleshoot orchestration and scheduling issues in Tidal Enterprise Scheduler.

Architecture Input & Technical Leadership Responsibilities
Architecture Contributions
1.Provide architectural guidance for new integrations, data warehouse initiatives, and migration projects.
2.Recommend best practices for cloud adoption, pipeline modernization, and platform evolution.
3.Contribute to reference architectures, standards, reusable patterns, and decision frameworks.

Strategic Technology Guidance
1.Evaluate emerging tools and technologies in data engineering, integration, cloud, and orchestration.
2.Champion automation, observability, data quality, and performance optimization initiatives.
3.Collaborate with enterprise architects and infrastructure teams to ensure future-proof design choices.

Cross-functional Collaboration Responsibilities
1.Work with QA, business analysts, and project managers to enable smooth delivery.
2.Assist and collaborate with offshore teams to ensure alignment, effective knowledge transfer, and smooth delivery across time zones.
3.Communicate technical concepts clearly to both technical and non-technical stakeholders.

Tools & Technology Scope
1.ETL/ELT: IBM DataStage, SnapLogic
2.Cloud: AWS (Compute, Storage, Serverless, Orchestration, IAM, Monitoring)
3.Data Warehouse: Snowflake
4.Programming: Python, SQL
5.Scheduling: Tidal Enterprise Scheduler
6.Other: Git, CI/CD tools, DevOps pipelines, monitoring platforms

Minimum Years of Experience:
10+ years

Certifications Needed:
None

Top 3 responsibilities you would expect the Subcon to shoulder and execute:

Interview Process (Is face to face required?)
Virtual

Any additional information you would like to share about the project specs/nature of work:

EEOC Disclaimer: IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company.

About the Company

IMCS Group Inc

Resume Resources

Free Resume Templates Free Resume Builder