Jais Jose Email & Phone Number

Toronto, Ontario, Canada

Client - Manulife1)Engineered a comprehensive data warehouse solution, specializing in extracting, transforming, and loading data from diverse sources into star/snowflake schema architectures.2)Designed, built, automated, and optimized intricate ETL/ELT processes using PL/SQL and equivalent technologies, ensuring efficient data flow and system performance.3)Conducted thorough root cause analyses and implemented effective solutions for system failures, utilizing an internal defect tracking tool to generate detailed error reports and ensure swift resolution.4)Collaborated closely with cross-functional teams to decipher business requirements from non-technical stakeholders, translating them into precise technical specifications and actionable data plans to drive project success.5)Developed and implemented complex procedures, packages, views, and scripts for data denormalization, extraction, cleansing, and loading, facilitating streamlined data operations and integrity.6) Executed seamless data migration and integration initiatives across diverse platforms, ensuring data consistency and continuity across the organization.7)Demonstrated strong SQL skills, proficient in optimizing data processing scripts and tuning complex queries to enhance system performance and scalability.8)Successfully led teams in driving process development initiatives, leveraging technical expertise in data warehousing, ETL/ELT automation, and SQL optimization to achieve organizational goals effectively.

Client- Electronic Arts1)Understood mapping requirements and successfully implemented a data warehouse solution for Electronic Arts, ensuring seamless data flow from diverse sources to targeted destinations.2)Managed Extract, Transform, Load (ETL) processes involving Salesforce, flat files, and relational databases, utilizing Informatica stages such as transformer, sort, joiner, remove duplicate, and sequential file to integrate and transform data effectively.3) Facilitated smooth code migration from development to various testing environments, while establishing job parameters, stage variables, and parameter sets for enhanced job maintenance and scalability.4)Enhanced system performance by meticulously tuning queries and optimizing Informatica jobs, resulting in improved data processing efficiency and reduced execution times.5)Diligently resolved data and code defects within stipulated timelines, ensuring minimal disruption to project timelines and deliverables.6)Developed comprehensive test cases and executed rigorous testing protocols to validate data integrity and system functionality, ensuring high-quality deliverables.7)Maintained meticulous version control, process documentation, and revisions, facilitating streamlined project management and compliance with organizational standards.

Information Technology

Bachelor Of Technology - Btech, Electronics And Telecommunication

Hsc, Information Technology