a. Expert level experience working on design, development, delivering software and support.
b. Expert knowledge Application design including frontend and backend experience with particular focus in system integrations.
c. Experience with Salesforce or similar platform as a source PaaS and ability to integrate it as a data source for legacy systems
d. Expert knowledge Database design: entity relationship model, database schema design
e. Advanced proficiency writing complex queries from large data sources or multiple data sources and using tools to optimize SQL Server query performance
f. Designing and implementing data retention rules
g. Advance proficiency writing complex ETL's (SSIS packets) using C# which include logging, error messaging, and reporting for large data.
h. Advanced proficiency with SQL Server administration and writing SQL queries and ETL's.
i. Strong development skills with hands on experience and troubleshooting skills.
j. Experience developing and working knowledge of .NET and SQL development languages, environments and tools including Visual Studio 2015 or later, Data Tools, C#, SQL Server 2014 or later, T-SQL.
k. Strong understanding of the software development cycle and experience with agile delivery.
l. Strong written and verbal communication skills.
m. Proven ability to deliver products with highest quality and on time.
Roles and Responsibilities
The Application Developer will design and develop integrated solutions. These include, but are not limited to:
a. Analyze existing data sources to design stage migration database.
b. Design and develop optimized ETLs from existing sources to stage migration database.
c. Design and develop full stack software integrations and solutions with and within PaaS offerings (especially Salesforce).
d. Centralized APIs and interfaces.
e. Core development delivery processes, such as deployment and package delivery.
f. Experience in data migration and application development and integration with PaaS, COTS, SaaS and custom solutions and developing their interfaces to other solutions.
g. Design and build databases for data warehouse or data marts from multiple sources with built-in retention rules.
h. Design and build transaction databases for new solutions or replacement solutions.
i. Re-engineer and optimizing existing databases, applications, or ETL's (SSIS packets) using C# for large and for various confident categories of data. Additional Duties
a. Review COTS, SaaS, PaaS or custom solution and LCB current application portfolio to design, develop and implement an application architecture model.
b. Serve as the expert for assessing, informing, guiding, and teaching technologies in decisions related to technology investments for the project.
c. Apply Agile methods and advanced technical knowledge to evaluate and develop a solution (applications, interfaces and relational databases), and execute quality assurance testing and performance.
d. Identify, build, and guide others in consistent and sustainable application development architecture which will provide efficiencies and reduced rework on new and existing software applications.
e. Provide user training and knowledge transfer to WSLCB technical support staff.
a. Experience in evaluating and maintaining customizations for PaaS set release pipelines and proactively ensuring system functionality is not impacted.
b. Experience in evaluating SQL and translating into SOSL/SOQL and/or developing SOSL/SOQL from requirements
c. Experience in developing custom Apex, Visualforce pages, and other Lighting Experience components