ETL Developer

\nMapping and cleansing Raw data from external systems Used SQL Server Integration Services (SSIS) as an ETL Tool and created packages for the extraction of data from disparate sources (SQL Server, Flat Files, Excel Source files, XML Files, etc.) and loaded the data into target tables by performing data validation and cleansing using various transformations.\nBuild scalable, fault-tolerant batch and real-time data pipelines to power internal applications, operational workflows, and business intelligence platforms.\nCreate and maintain documentation of data interface specifications, Data Mappings, Transformation Rules, Business Decisions, and migration processes to be available to business/Product owners and IT teams.\nEnsure data quality by re-defining ETL process validation, metadata maintenance, data integrity validation process, quality standards, monitoring standard, and audit and reconciliation processes.\nSolve technical problems, simple and complex, in a lean and efficient manner.\nExtract, transform, and load data using data staging and SSIS.\nCreating SSRS reports.\nRead different formats of source raw files like Excel, CSV, Fixed and XML and transform them as per product needs.\nAnalyzing existing platform ETL scripts/transformations and applying them in SSIS data pipelines. \nException handling and debugging skills, including RAW files come from different sources (must analyze RAW sources, map them, and transform as per product needs.)\nSupport migrating data pipelines successfully to the new platform.\nSupport daily queries from source data to schedule job refresh for Enterprise Reference Data.\n

Labor Condition Application (ETA Form 9035 & 9035E) filed with the United States Department of Labor, Office of Foreign Labor Certification for a H-1B non-immigrant worker with the following details:\n1. Number of H1B non-immigrant workers included in LCA: \n1(One)\n2. Job Position: \nETL Developer\n3. Wages Offered: \n$103200.00 - $103201.00 per year\n4. Period of Employment:\n 09/11/2024 to 09/10/2027\n5. Locations where H1B non-immigrant worker will work:\n1)382 Boston Tpke Suite 201, Shrewsbury, Massachusetts 01545\nComplaints alleging misrepresentation of material facts in the Labor Condition Application and/ or failure to comply with the terms of the Labor Condition Application may be filed with any office of the Wage & Hour Division of the United States Department of Labor.\nThe verification of Labor Condition Application (ETA Form 9035 & 9035E) will be available for all to review.\n\nhttps://us-west-2.graphassets.com/AhL7j39r8QqrJYMwlDWAYz/kzeX1XgRQVGeZ5VDHo75\n