GIDEON ROTICH

Am a Professional ETL developer with 12 + years in proven history of optimizing data workflows and enhancing data quality and accuracy across various platforms. Known for strong team collaboration and consistent delivery of high-quality results, with expertise in SQL, data warehousing, and problem-solving.

www.linkedin.com/in/gideon-rotich-b171a0335

• Developed a company-wide data migration project at Tyson achieving a flawless transition with 100% zero data loss.
• Optimized ETL Processes though performance Tuning techniques that improved data migration speed process by 36%.
• Supervised and managed a team of six developers and accomplished accomplished a 5 mouths project within 3.5 months .
• Boosted data accessibility to reporting team access and insights with robust ETL pipelines.
• Optimized performance and scalability through (petitioning approach) workflow performance tuning and process enhancement.
• Streamlined team collaboration and knowledge sharing by mentoring and developing documentation.
• Reduced manual effort by developing automated processes. Hence saving company >$ 415k in annual fee towards salaries to manual labor.
• Enhanced data quality and accuracy through validation checks and frameworks.

• SQL Expertise: I can write complex SQL queries for extracting, transforming, and loading data, including using joins and sub queries.
• ETL Tools Proficiency: Am are proficient in using Informatica and SSIS specialized tools to streamline data integration and transformations.
• Data Modeling & Warehousing: A strong understanding of data modeling principles e.g., star schema, snowflake schema and dimensions is crucial for designing efficient data storage and retrieval systems within a data warehouse context.
• Automation: This comes handy to me on repetitive tasks and has created custom solutions for complex data manipulation without manual process.
• Data Quality Management: Ability to implement data validation and cleansing processes to ensure data accuracy, completeness, and consistency, which is vital for reliable analytics.
• Performance Tuning: Ability to optimize ETL processes for handling large volumes of data efficiently, eliminating bottlenecks during ETL process.
• Database & Big Data Technologies: Familiarity with relational databases i.e Oracle, SQL Server and big data technologies like Hadoop and Spark.
• Structured documentation: Am adept at documenting processes, providing clear updates, and following up on commitments, ensuring stakeholders are consistently informed and expectations are managed effectively.