Cajetan Okoye
Chicago,IL
Summary
Experienced Data Engineer specializing in SSIS ETL development, data pipeline design, and data warehousing. Proven track record in leveraging SQL Server Integration Services (SSIS) to enhance data management and analysis. Skilled in transforming complex data into actionable insights with a focus on optimizing data delivery and scalability. Achieved a 30% improvement in data integrity and a 25% increase in processing efficiency, driving business growth by developing and implementing innovative SSIS ETL solutions and best practices.
Overview
6
6
years of professional experience
Work History
Data Engineer
Illinois Tool Works Inc. (ITW)
2021.09 - 2024.03
- Developed and maintained Batch ETL/ELT processes using SQL Server and SSIS, ensuring high performance and best-in-class standards.
- Created and optimized complex SQL queries and stored procedures for data processing and analysis.
- Designed and built data pipelines for ODS, Staging, Data Warehousing, and Data Marts, achieving a 25% increase in processing efficiency.
- Implemented data warehouse solutions using Star Schema and Snowflake Schema for reporting and analytical applications.
- Managed data processing and query optimization using TSQL, enhancing performance by 30%.
- Implemented audit, balance, and control mechanisms in data solutions, ensuring data accuracy and reliability.
- Utilized Python Pandas libraries to process semi-structured data sets, loading them into SQL Server DB.
- Employed data modeling techniques using tools like Erwin and Visio, improving data integrity by 20%.
- Led peer reviews and ensured data quality in data warehouse and downstream data marts.
- Configured, deployed, and maintained CI/CD pipelines using GitLab, Python, and shell scripts, automating routine tasks and reducing manual intervention by 40%.
Data Engineer/ETL Developer
Peoria Public Schools
2020.10 - 2021.10
- Transformed business requirements into technical specifications and created comprehensive documentation.
- Designed and implemented data models, databases, and data warehouses, increasing query performance by 25%.
- Developed custom scripts and utilized SSIS and Talend Open Studio for ETL processes, handling data from various sources including Oracle, SQL Server, and Teradata.
- Implemented data migration strategies, reducing maintenance costs by 50%.
- Managed code deployments and provided technical support for backend systems, enhancing system reliability.
- Applied advanced query optimization techniques to improve database performance and reduce latency.
Data Modeler
Liberty Steel & Wire
2019.06 - 2020.10
- Developed logical and physical data models ensuring compliance with governance standards, leading to a 20% improvement in data integrity.
- Analyzed business needs to create conceptual data models and data flows.
- Provided technical support for ETL processing using SSIS, reducing ETL errors by 30%.
- Collaborated with software engineering teams to resolve advanced customer issues and optimize data accuracy through efficient data model design.
Data Analyst
Holy Cross Hospital
2018.08 - 2019.06
- Produced monthly reports using advanced Excel spreadsheet functions.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Used statistical methods to analyze data and generate useful business reports.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Utilized advanced query optimization techniques to enhance database performance and reduce latency issues during high-traffic periods.
Education
Bachelor of Science - Computer And Information Sciences
University of Illinois At Urbana-Champaign
Champaign, IL05.2018
Skills
- SQL Server
- SSIS
- Talend Open Studio
- Advanced SQL
- Data Pipeline Design
- Data Warehousing
- ETL Development
- Data Modeling
- Relational Databases
- Big Data Processing
- Python
- Git
- TSQL
- Data Integrity Validation
- Database Programming and SQL
- Data Analysis
- Data Migration
- Google Cloud Platform
- Data Proc & Dataflow
- Airflow
- Hadoop
- Spark Framework
- BigQuery
- Business Intelligence
- Tableau
- Google Cloud Storage (GCS)
- Apache Beam
- Oracle SQL
- Apache Spark
- NoSQL Databases
Timeline
Data Engineer
Illinois Tool Works Inc. (ITW)
2021.09 - 2024.03
Data Engineer/ETL Developer
Peoria Public Schools
2020.10 - 2021.10
Data Modeler
Liberty Steel & Wire
2019.06 - 2020.10
Data Analyst
Holy Cross Hospital
2018.08 - 2019.06
Bachelor of Science - Computer And Information Sciences
University of Illinois At Urbana-Champaign
Similar Profiles
Lisa ThomasLisa Thomas
Environmental Health & Safety Manager at ITW Illinois Tool WorksEnvironmental Health & Safety Manager at ITW Illinois Tool Works
Kuo JessieKuo Jessie
Admin Executive at ILLINOIS TOOL WORKS INC. INSTRON TAIWAN BRANCHAdmin Executive at ILLINOIS TOOL WORKS INC. INSTRON TAIWAN BRANCH
Matthew McGillivaryMatthew McGillivary
Sales Development Specialist at Illinois Tool Works Inc, Traulsen RefrigerationSales Development Specialist at Illinois Tool Works Inc, Traulsen Refrigeration