Innovations technological

Role: PL/SQL Technical Lead

Location: Austin, TX

Duration:  long  term

Responsibilities

- Analysis of user requirements and coming out with good technical solutions

- Creating design and implementation/deployment instructions document

- Support team if required w.r.t. troubleshooting

- Ability to write optimized code and work independently

- Experience of working in Agile projects

- Manage delivery of a team and plan/assign work for members

            - Take part in discussions with business on new functionalities to be built in. Understand user requirements and come out with corresponding functional and non-functional system requirements.

 Mandatory skills

- Oracle PL/SQL

            - DOS commands'

Good to have skills

            -Control M

Role: ETL Test Lead

Location:

Duration: long term

Skills: ETL Exp, Complex queries in SQL, Unix

Job Description:

Accountable for developing the high level Test Strategy and then developing and executing the detailed System and Acceptance Test Plans. Accountable for determining and transitioning the ownership of relevant test artifacts, (documents, test cases, test beds, test environments, etc.) to ensure environmental cleanup, future use, maintenance, obsolescence.

Required: 7-8 years of experience in ETL Testing in large projects. Familiarity of the SCRUM/AGILE methodology is a must. Understanding and ability to write complex queries in Sybase, DB2, Flat File, MySQL MainFrame File. Hands on experience in using SQL analytical functions to manipulate data and validate transformation. Experience in data setup including creating test data and data mockup for various sources like Flat File, Data base and MainFrame files. Understanding of ETL concepts and experience validating Data Marts, Online Transactions Processing (OLTP) and predictive analysis.

Should be able to drive the work on his own and do thorough white box testing.

Nice to have - Automating data validation SQLs using Unix script • Hands on experience in scheduling and running jobs