Vacancy expired!
Software Guidance & Assistance, Inc., (SGA), is searching for a Datawarehouse/Database Developer for a Contract assignment with one of our premier Financial Services clients in Jersey City, NJ . Responsibilities :
- Review, understand, interpret and transform clearly defined technical specifications into data warehouse, database and/or business intelligence solutions
- Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
- Perform problem analysis, structured analysis, design and programming techniques
- Use Data Modeling, Database Query Optimization and Data Access techniques and concepts
- Use Database knowledge in areas of import and export, users, roles, privileges, schema and object management, session monitoring, etc.
- Code, maintain, test and provide code reviews for developed processes and procedures (e.g. queries, scripts, stored procedures, database objects, indices, triggers, etc.)
- Apply strong performance tuning knowledge in SQL to interpret plans, identify bottlenecks in queries and remediate them
- Apply strong knowledge in Python and Shell Scripting required for file processing and database connections
- Work proactively to solve issues and problems
- Create use cases and assist in UAT testing efforts for the developed solutions
- Document, effectively track and resolve issues in a timely manner during the development and testing phases (work with the team and end users as appropriate)
- Provide weekly progress reports of work performed
- Work with the project team to assist in other aspects of the project
- Follow and adhere to development standards, the software development lifecycle, vendor application / project standards and guidelines
- Embrace the opportunity to take on special projects outside of specific roles and responsibilities
- Closely interact with onshore stakeholders and onshore teams on a regular basis.
- Oracle: SQL, PL/SQL (Mandatory)
- Unix Scripting
- Python Scripting
- AutoSys
- T-SQL, MS SQL
- Oracle: Warehouse Builder, Data Integrator
Vacancy expired!