Sr. Software Engineer

\nAnalysis of Functional, System and Technical Business Requirements.\nAnalyzing entire software development lifecycle to better understand the requirement before development process.\nWorking with Oracle Data Integrator 12c for Extraction, Loading and Transformation of Data from Source Application to Data Warehouse.\nDesign and implement ETL pipelines using Databricks (PySpark, Delta Lake, SQL) to process structured and semi-structured data from multiple sources.\nCreate and manage bronze, silver, and gold layers in the Delta architecture to enable incremental and historical data processing.\nIntegrate Databricks with Azure Data Lake / S3 for scalable storage and optimized data access.\nImplement Unity Catalog for fine-grained data governance, lineage tracking, and access control.\nAutomate job runs, notebook scheduling, and parameterized pipelines using Databricks Workflows.\nTune Spark jobs for optimal performance and monitor using cluster metrics and execution logs.\nDevelop Packages, Scenarios using Interfaces, Mappings and Variables in ODI\nCustomize ODI Knowledge Modules.\nCreate and Deploy Pipelines using Jenkins, Bitbucket.\nTest CI/CD pipelines.\nUse APIs to push data into external applications like CRM, Qualtrics, Alvaria.\nDevelop and Enhance Data warehouse.\nDevelop PL/SQL programs to transform data needed for Analytics.\nDesign and develop Oracle APEX applications for self-service data access, analytics, and operational dashboards.\nIntegrate Oracle APEX with RESTful APIs and ORDS for real-time data interactions with external systems.\nImplement AI-powered assistants within APEX using OCI GenAI or Cohere APIs for conversational data analysis and insights.\nBuild interactive pages, forms, and charts to visualize data warehouse metrics and data quality KPIs.\nDevelop dynamic PL/SQL backend logic for APEX applications to handle validations and business rules.\nCommunicate with BI and Analytics team to develop data models.\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: \nSr. Software Engineer\n3. Wages Offered: \n$168000.00 - $168001.00 per year\n4. Period of Employment: \n11/10/2025 to 11/09/2028\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. ⁠ ⁠\nhttps://tinyurl.com/bdcvvbn7\n