ETL Developer Location: Wilmington DE
Length: 1 year with the option to extend Interview process: Phone then onsite Software Design, Programming and Unit Testing • Strong database (Oracle) skills including database design, development (packages, functions, procedures) • Strong data warehousing and OLTP system knowledge from database/ETL development perspective. • Database code performance tuning skills required • Designing software modifications from supplied requirements and design specifications using agreed standards and tools, achieving well-engineered results that follow the agreed implementation level software architectures. • Taking responsibility for the design, coding, testing, and documentation (as defined by the SDLC process) of particularly large, complex or mission critical software programs. • Proposing options and preparing cost estimates to enable the business area to make informed decisions • Adhere to all BCUS standards, Policies and governance practices. • Assume ownership of various initiatives across Solutions Delivery as agreed with Team Lead for complete and successful delivery. • Provide functional expertise within his/her skills to assist delivery team members, and foster collaboration within Technology. • Provide issue response and root cause analysis on work assigned by Team Lead and Project Lead. • Planning, designing and conducting Unit and System Integration Tests, correcting errors and re-testing to deliver an error-free product. • Reacting quickly and as necessary to live software errors and service problems, limiting downtime and resolving the problem during project handover. • Report progress, delays and risks on assigned activities to Project Lead and Team Lead. • Raise awareness when existing code, systems or processes do not meet current quality expectations and standards. • Maintain code and all related artifacts in source control; perform code merges and resolve conflicts as defined by development process, update documentation and automated tests. • Develop code, configuration files, build scripts, schemas or other artifacts as assigned by Team Lead. • Develop system integration test to verify the code running in its functional environment. • Work with the Project Lead and Team Lead to schedule features into Releases. • Create implementation plans and Change Management Requests as assigned. • Maintain accurate feature status during development by the agreed upon SLA. • Verify build and deployment completeness of the features owned in the QA environment before making it available for Testing. • Review the feature requirements as presented by the Business Analyst and the delivery team, in context of the overall project feature set and existing implementation. Translate requirements to technical concepts. • Contribute to the logical/physical data models, class diagrams, activity diagrams, sequence diagrams and UI prototypes. • Assist QA and production testing and deployment; assume ownership of the work until it passes successful Production Verification Test. • Test all code, content, build and unit test changes in the lowest environments first, if such environments exist. • Taking part in reviews of own work and leading reviews of colleagues’ work. Technical Knowledge • Strong data warehousing and OLTP system knowledge from database/ETL development perspective. • Strong Oracle database knowledge including database design, development (package, procedure, functions, indexes) • Database code (SQL and PLSQL) performance tuning skills • Datastage 8.1 knowledge required • Unix commands and shell scripting knowledge • Big Data – Hadoop, Hadoop Spark • NoSQL Databases: MongoDB, Cassendra *Needed some details for submission process -* *Full Legal Name : Contact Number : Email ID : Current Location : * *Relocation :* *Last 4 digit of SSN : Skype ID : DOB(MM/DD) : * *Availability to Join : * *Work authorization :* *Education, University, Year:* *Regards* *Vishal Ji Awasthi* *Srimatrix Inc.* [image: Logo.png] E-Mail:*vis...@srimatrix.com <vis...@srimatrix.com>* Phone: *214-227-9311(Direct)* Web: www.srimatrix.com