Sebin Jose
Bangalore
Summary
Results-driven ETL Developer with a strong background in Informatica and Snowflake, previously contributing to data optimization at Hudson’s Bay Company. Demonstrated success in streamlining data workflows and enhancing integrity, leveraging SQL analysis to resolve complex issues. Adept at problem-solving and fostering collaboration in fast-paced environments, with a focus on delivering high-quality data solutions. Career goals include continued growth in data engineering and contributing to innovative projects.
Overview
6
6
years of professional experience
Work History
ETL Developer/Support Executive
Hudson’s Bay Company
Bangalore
09.2023 - Current
- Streamlined data flow and validated system architecture during Axway migration for improved efficiency.
- Developed automated workflows in Informatica 10.2 to aggregate data from DB2, Oracle, and Mainframe systems into Snowflake.
- Enhanced data processes through automation and architecture improvements for better performance.
- Extracted and ingested sales and inventory data into Snowflake from different data sources using this data Business Intelligence generated actionable business insights through MSTR and Tableau reports.
- Identified and resolved data issues (duplicates, invalid/missing data) by backtracking to source systems and implementing permanent fixes.
- Managed priority tickets and data loads and ensured timely resolution/completion within SLA.
- Automated and scheduled workflows to meet business requirements for report generation.
- Proficient in Data Engineering tools like Airflow, Automic, and Airbyte, and BI reporting with MSTR.
Informatica Developer
Infinite Computer Solutions
Bangalore
02.2023 - 09.2023
- Client Company: Medica.
- Project: Migration of TIBCO BW applications to Informatica.
- Modules: Involved in the migration of enrollment applications wherein we process the enrollment update requests to update the subscription details of the members.
- Responsible for code migration from TIBCO to Informatica.
- Developed workflows after interpreting Tibco code and formulating corresponding design document and integrated user feedback into improved workflow designs.
Informatica Developer/Support Executive
TATA Consultancy Services
Chennai
07.2019 - 02.2023
- Client Company: Hudson's Bay Company.
- Assisted in migrating data from Teradata to Snowflake architecture, ensuring smooth transfer and system integration and ensured accurate data transfer between Teradata and Snowflake, maintaining data integrity.
- Optimized SnowSQL queries and applied PDO strategies to enhance data performance.
- Extracted sales and inventory data from DB2, Oracle, Postgres, and Mainframe systems, loading it into Snowflake data warehouses to generate business reports using MSTR and Tableau for key insights.
- Delivered data within SLA, ensuring timely and accurate feedback to reporting tools.
Education
B.Sc - Mathematics
BVM Holy Cross College Cherpunkal
Kottayam05.2019
Higher secondary - SSLC
Little Flower Senior Secondary School Karuvanchal
Kannur05.2016
Skills
- Informatica PowerCenter
- Snowflake Analytics Expertise
- SQL Data Analysis
- Teradata data warehouse
- Oracle
- Unix shell scripting
- Mainframe scheduling
- Automic Scheduling
Accomplishments
- Received Spot Award for exceptional dedication and significant contributions to team success
Timeline
ETL Developer/Support Executive
Hudson’s Bay Company
09.2023 - Current
Informatica Developer
Infinite Computer Solutions
02.2023 - 09.2023
Informatica Developer/Support Executive
TATA Consultancy Services
07.2019 - 02.2023
B.Sc - Mathematics
BVM Holy Cross College Cherpunkal
Higher secondary - SSLC
Little Flower Senior Secondary School Karuvanchal
Similar Profiles
Trevor LargeTrevor Large
Senior Analyst, Major Home Fashion at Hudson’s Bay CompanySenior Analyst, Major Home Fashion at Hudson’s Bay Company
Everett YeeEverett Yee
Lead Customer Experience Associate at Hudson’s Bay Company (HBC)Lead Customer Experience Associate at Hudson’s Bay Company (HBC)
Fernando AmadorFernando Amador
Consultant, Sales Representative and Clerical at The Hudson’s Bay CompanyConsultant, Sales Representative and Clerical at The Hudson’s Bay Company
Parminder SinghParminder Singh
Loss Prevention Supervisor at Hudson’s Bay CompanyLoss Prevention Supervisor at Hudson’s Bay Company
Muskan JainMuskan Jain
Associate – Bid Management at Subex Ltd.Associate – Bid Management at Subex Ltd.