As an ETL Developer I have 4.5 years of experience in Extraction, Transformation and Loading (ETL) on Talend and SQL for Data Integration.
⦁ Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses using Talend Data Integration.
⦁ Expert in using different components in Talend.
⦁ Expertise in working with different data sources heterogeneous source systems.
⦁ Good knowledge on implementing SCD Type-1, Type-2 and Type-3.
⦁ Proficiency in Data Warehouse concepts and principles involving Star Schema, Snow Flake modelling, identification of Fact and Dimension tables.
⦁ Having knowledge in Scheduling Talend jobs by using TAC.
⦁ Experience in creating metadata for different databases and files in Talend.
⦁ Knowledge in Talend Admin Centre for Deployment, Scheduling and Monitoring of Talend jobs.
⦁ Analysed the business requirements and built logical data models that describe all the data and relationships between data.
⦁ Preform DML, DDL, DRL operations as per the business requirements.
⦁ Experienced in SQL joins, Nested Queries, Unions, Multi-table joins.
⦁ Resolved production issues by modifying backend code as and when required.
⦁ Testing of code functionality using testing environment.
⦁ Monitored performance and optimized the SQL quires for maximum efficiency.
⦁ Attending Stand-up huddles, Monthly and Weekly status calls and daily defect calls.