Shruti Garg Email & Phone Number

Pune, Maharashtra, India

SQL Developer | Talend DeveloperJob Responsibilities:Implement ETL logic from on-prem systems and SSIS packages to Talend for loading data into Snowflake reporting tables.Use Talend to load data from Oracle, SQL Server, Excel, and flat files into Snowflake.Develop Talend ETL jobs with various transformation logics.Prepare understanding, design, and mapping documents based on client requirements.Create unit test cases and deployment checklists, and upload documents to ServiceNow tickets.Collaborate with QA team to review test cases and address raised bugs.Monitor Talend job schedules using TAC (Talend Administration Center).Track sprints in Azure DevOps.Prepare design documents, run books, and turnover documents.Coordinate and conduct user acceptance tests with clients.

Pune, Maharashtra, India

Job Responsibilities:Design ETL job to extract data from source and load into Azure Data Lake.Validate data in the landing area against the source.Develop ETL jobs for applying transformations and loading data into Snowflake data warehouse.

Pune, Maharashtra, India

Job Responsibilities:Developed Talend ETL jobs to extract data from diverse sources (Oracle, MySQL, SFTP, FTP) and load it into Azure Data Lake.Designed and implemented an ETL audit framework for tracking pre-job and post-job activities.Conducted research and provided solutions for known issues.Assumed ownership of source systems, validating data and establishing rules to identify and resolve data issues.Loaded data from Azure Data Lake (utilizing various file formats) into the Enterprise Data Warehouse (EDW).Created stored procedures, tables, history tables, views, and T-SQL code, employing SQL joins to generate client reports.Addressed and resolved bugs identified during UAT.