Experience Inc. Jobs

Advisory Software Engineer with the following duties:1)Design and Develop overall ETL processes and architecture, involved in the development and testing activities using Informatica PowerCenter, Informatica EDC, Informatica Axon, Informatica IDQ / Informatica Intelligent Cloud Services, Azure data factory, data bricks, Microsoft SSIS/SSRS/SSAS and MuleSoft.2)Design, architect and implement an enterprise-level data warehouse, familiarity with ETL /ELT architectures, leveraging multiple sources like XSD, Microsoft Azure SQL, Azure Data Warehouse, and Oracle 11G databases to meet business requirements.3)Extensive experience on Azure Data Factory, Azure Data Lake Storage, Azure Synapse Analytics, Azure Analytical services, Azure HDInsight, Big Data Technologies (Hadoop and Apache Spark), and Databricks.4)Develop ETL, data warehouse, cubes, dashboards, visualization, and reports for Retail sales and inventory analytics using SSIS (SQL Server Integration Services), SSAS (SQL Server Analysis Services) and SSRS (SQL Server Reporting Services)5)Strong experience using Informatica PowerCenter, and Informatica Data Quality. Build Data lineage using Enterprise Data Catalog. Building organization-wide business glossary (assets, policies, relationships, and other facets) and integrating the data quality rules using Informatica Axon.6)Experience with various ETL and Business Intelligence tools and has strong analytical skills, project leadership experience; in-depth applications knowledge; detail-driven; solution oriented with multi-tasking, innovative, planning, and organizational skills7)Collaborate with cross-functional teams to discover opportunities for enhanced decision-making and process improvements.8)Experience in developing complex database objects like Stored Procedures, Functions, Packages, Triggers, Tables, Views, Indexes, Constraints, Synonyms, Materialized Views, and Partition Tables using SQL and PL/SQL.9)Provide the necessary technical specifications, data mappings, and integration processes associated with the developed and maintained solutions to satisfy all company, IT policies, procedures, standards, practices, and guidelines.10)Provide Production support and responsible for overseeing change requests, reviewing and approving them, and ensuring seamless project delivery through effective change management11)Act as liaison with offshore development teamRequirements:Educational Requirements: Bachelor of Science in Computer Science, Information Technology or a related field. Work Experience Requirements: 2 years of experience either in the offered position or Sr. Software Engineer or a related occupation.Skill Set Requirements: 2 years in the following skill set: 1) Informatica Power Center, Informatica IDQ, Informatica EDC, Informatica Axon, Informatica Intelligent Cloud Services, Azure Data Factory, Databricks, Microsoft SSIS, MuleSoft, Azure HDInsight, Azure Data Lake Storage, Azure Synapse Analytics.2) Microsoft SQL Server, Microsoft Azure SQL, Azure Datawarehouse, Oracle Database3)Microsoft SSRS/SSAS4) Azure Functions, Python, PowerShell, Bash/Batch scriptingEmployer will accept any suitable combination of education, training or experience.Job site:The job is currently located in Cranbury, New Jersey. There is a possibility of medium to long term relocation to either Pittsburgh, PA or other unanticipated sites throughout the U.S. The position is 40 hours per week, 9:00 a.m. - 5:00 p.m., Monday-Friday.Please send resume to:Suvarna NikamSVP - Human ResourcesVisionet Systems, Inc.4B CedarBrook DriveCranbury, NJ 08512609) 452-0700 Ext-1132REF: FK