ETL Developer

WHO WE ARE: Founded in 2007, DTI (Diversified Technology, Inc.) is a successful African American owned IT Consulting/Staffing firm based in Chicago's Loop. WHAT WE DO: We focus on providing delivery, staffing, and supported services such as enterprise integration/implementations including, but not limited to, CRM, EAM, ERP, PMO, and QA. We service clients in SLED (state/local gov't & education), financial services, fortune, public utility, as well as regularly partnering with Big 4 SI partners. Are you a Database Engineer looking for your next contract? If so, we want to speak to you! DTI has an immediate need for a Database Engineer for a 6 Months Contract. Must work on our W2 Job Title: Database Engineer Location: Remote Duration: 6 Months Contract (08/04/2025 to 02/06/2026) Job Description: The services You will provide the Client project team: As a Database Engineer Contractor, you will design, develop, and optimize database systems to support data storage, retrieval, and analysis. Design and construct large relational databases to meet project requirements. Develop and maintain ETL processes to integrate new systems with existing data warehouse structures. Optimize database performance by refining system functionality and ensuring efficient data retrieval. Implement and enforce database security measures to protect data integrity and confidentiality. Perform regular data validation and quality checks to ensure database accuracy and reliability. Primary Skill Required for the Role: Informatica - PowerCenter Level Required for Primary Skill: Expert (10+ years experience) Technical Skills: Positions - Lead ETL Engineer Seeking a candidate with extensive Informatica PowerCenter/IICS development experience and strong hands-on expertise in SQL queries and performance tuning. • Expert-level proficiency in Informatica PowerCenter and IICS for ETL and cloud-native data integration. • Advanced SQL skills for querying, optimizing, and managing Amazon Redshift environments, including expertise in Redshift-specific features. • Strong expertise in data modeling tools (e.g., ER/Studio, Erwin, or Data Vault) and advanced modeling techniques (e.g., star/snowflake schemas, graph-based models). • Proficiency in Python for data manipulation, automation, and analytics (e.g., pandas, NumPy, PySpark, Airflow). • Experience with data visualization and analytics platforms (e.g.,MSTR, Power BI) for delivering actionable insights. • Familiarity with AWS cloud services (e.g., S3, Glue, Lambda, SageMaker) and DevOps tools (e.g., Jenkins, Git) for data pipeline automation Experience: • 10-15 years of hands-on experience with Informatica PowerCenter for designing and implementing complex ETL workflows. • 8+ years in data modeling (conceptual, logical, and physical) for data warehousing, analytics solutions. • 7+ years of experience as a Data Analyst, performing advanced data profiling, analysis, and reporting to support strategic decision-making. • 5+ years of experience with Informatica Intelligent Cloud Services (IICS) for cloud-based data integration and orchestration. • 5+ years of hands-on experience with Amazon Redshift, including advanced schema design, query optimization, and large-scale data management. • 5+ years of hands-on experience with Python for data processing, automation, and integration with ETL, data warehousing, and analytics platforms. Pay rate: $54.54-$63/hr depending on experience Please click on the link below for our company benefits https://docs.google.com/document/d/1q2mHf0U1akaC1ZKC65-VyyG3FrKBGNCahx3WpS2mj7M/edit?usp=sharing DTI is an Equal Opportunity Employer. We do not discriminate based on race, color, religion, sex, gender identity, sexual orientation, national origin, ancestry, age, disability, marital status, veteran status, or any other protected characteristic under Illinois state or federal law. All qualified applicants are encouraged to apply, and employment decisions are based solely on merit, qualifications, and business needs.