No report generating or Data Warehousing background needed.
Want experience with online transactions.
XML not needed but highly desirable.
Write complex SQL Server stored procedures
SSIS package experience.
Trouble-shooting problems and taking corrective action.
Some C# knowledge is nice.
Codes and performs unit and integration testing of software to ensure proper and efficient execution and adherence to business and technical requirements- Codes, tests, and debugs new software or makes enhancements to existing software- Writes programs according to specifications from higher level staff or business analysts- Develops technical documentation- Resolves in a timely manner problems that arise with existing production applications to ensure the efficient and proper functioning of application components- Collaborates with technical staff to learn and understand software problems- Generates a variety of complex and periodic reports and/or data through database management, data administration and data extraction techniques- Provides general system users and management with system analysis and feedback- Influences system design by identifying and recommending design and requirements needs for software enhancements- Mentors and coaches less experienced staff- Maximizes the efficiency of the various software systems by implementing, monitoring, testing and auditing new software programs- Analyzes and resolves computer related problems by coordinating with in‐house personnel to diagnose and fix operational difficulty, as well as consulting, advising and training on specialized features and functions- Follows established configuration/change control processes
Academic/Experience/Competency:BA/BS in Information Technology, Computer Science, related field or equivalent work experience.- Advanced capability in software construction, testing, infrastructure, configuration and operating standards- Advanced corporate knowledge, and understands how a change would affect multiple applications- Advanced ability to make recommendations/decisions in application and program design, standards and program enhancements- Advanced ability to utilize system traces and debugging tools for problem/issue resolution- Advanced ability to analyze and model business functions, processes and information flow within or between systems- Advanced ability to provide guidance and mentoring on programming practices and techniques to individuals and cross‐functional teams- Advanced knowledge of software design, construction, programming trends, programming and scripting languages in multiple application and data management systems- Advanced ability to work with users at all levels to define system requirements, design and system topologies to meet operational needs and system performance objectives
Business Experience:- 5 plus years experience with major DBMS- 5 plus years experience with coding, testing and design- 5 plus years experience with software development methodologies.
Daily Tasks Performed Create/Modify SQL Server /packages including SSIS/Stored Procedures/Handle error conditions* Database tables design based transactional and analytical requirements* Create complex queries* Design and develop an end to end ETL and reporting solutions to load/store data and provide analytics for business users (for analytics purposes we are looking to design tables, populate data, and create queries when needed)* Schduel processes and reports* Trouble shoot production issues affecting database issues, performance issues, and answer/investigate data issues * Work with DBA on reviewing design and attain DBA approval* Attend various meetings with project team * Create and execute SQL statements and perform complex data analysis* Responsible for documenting technical flows, context diagrams, sequence diagrams, and design
El Segundo, CA, 90245