Oracle Data Architect

Title: Oracle Data Architect

Location: Minneapolis, MN

Duration: 12+ Months-Long term

Job Description:
Overall experience of  10 years in design and architecture of Oracle Data Warehouse

Required skills:
Good experience  working on Data Modeling, DW Concepts, database schemas and tables

Good experience working on materialized views, stored procedures

Good experience on informatica power center expertise

Candidates for this role MUST have some experience on Unix shell scripting.


Data Engineer

Data Engineer

Minnetonka, MN

6 months contract

LOCALS preferred

Required Qualifications:
• Bachelor’s degree in related area or equivalent experience
• 2+ years of data engineering
• 5+ years of full lifecycle application, software development experience
• 2+ years of SDLC experience in an Agile environment.
• 4+ years of modern programming language such as Python, Java, Scala.
• Working knowledge of the following business and technology concepts: APIs, CI/CD, Big Data, data architecture and governance
• Experience with Jenkins, GitHub, Big Data technologies like Spark
• Experience using IDEs such as Eclipse, JBoss, IntelliJ
• Relational database experience
• Experience ingesting and working with large and complex datasets
• Experience gathering requirements from end users
Preferred Qualifications:
• Bachelor’s degree in Computer Science, Engineering, or Technology
• Experience with Cloud technologies and platforms such as Docker, OSE, Kubernetes, AWS, and Azure
• Taleo knowledge
• Experience with disaster and recovery models
• DevOps experience

ETL Consultant

Job Title:-       ETL Consultant
Location:-      Hoboken, NJ

Duration:-       Full Time Permanent Position(No C2C)


Key Skills: Informatica ETL development , PL/SQL,  Strong familiarity of data warehouse projects and Data Modeling, Data Architect.

•         Follow specifications provided by the Data Architect for development of Informatica based solutions for Data Integration/Migration in both OLTP and Data Warehouse environments.
•         Assist with impact analysis of changing upstream processes to Data Warehouse and Reporting systems.
•         Assist with design, testing, support, and debugging of new and existing ETL and reporting processes.
•         Work with other developers, data architects, DBAs, project managers, and client business users to develop specifications and resolve client questions around problems and enhancements.
Candidate skill Requirements:
• 6-10 years of  IT experience as in ETL developer using Informatica 9.x or above
• Any reporting tool (e.g.OBIEE) knowledge is a plus.
• In depth working experience of relational database ( e.g. Oracle and Sql server)
• Well versed with Data warehousing Concepts and its design by using Star and Snowflake Schema methodologies.
• Should be strong in writing complex SQL queries and PLSQL programs
• Analyzing business requirements, designing/modifying system processes to meet the analytical capability needs and communicating them to the rest of the application development & data warehouse team.

Database Developer

Job Description
Database Developer
San Jose, CA
Bachelor’s degree or foreign equivalent in Computer Science or related field and 5+ years of experience in database development preferably using any PostgreSQL flavors. Alternately candidate having strong experience with PL/SQL development can be consideredExpert SQL writing and query skillsScripting experience using Python/Shell scripts is a plusHands on ETL experienceExperience with Snowflake and/or Teradata is a plus

JavaScript Developer

JavaScript Full Stack Developer
Location: Minneapolis, MN
Client: Wells Fargo
Duration: 24 months
Required Qualifications:
Excellent attention to detail
5+ years of large-scale web application development using Java Framework
Expert knowledge and considerable development experience with at least two or more of the following: Java, HTML, AJAX, JavaScript or other web development languages or standards
You have a strong understanding of object-oriented design and how to implement your designs in Java
Ability to build web applications including graphic elements, overall organization and navigational structure, layout, development, usability of web pages and forms for ease-of-use
Advanced knowledge of common design patterns and when they should be used
5+ years of MS SQL server experience in designing, coding and delivering database applications on multiple MS SQL Server versions (V2014 to V2020)
5+ years of experience with SQL Server database design
5+ years experienced in configuring and maintaining the performance of large / critical MS SQL Server database applications
Experience in writing and debugging complex SQL Stored Procedures
Experience in ETL tools (SSIS, Informatica) and database integration with Oracle, SQL Server, and other databases
Knowledge of multi-threading and messaging workflows is a strong plus
Minimum of 3 years of experience using GitHub
Experience with Jenkins is preferred
Experienced in the use of JIRA and Confluence on a daily basis
Excellent troubleshooting and debugging skills
You can analyze a feature story and design a robust solution for it and create specs for complex business rules and calculations
The Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology
Ability to develop accurate estimates and assist team and project managers with the estimation process
Ability to understand business problems and articulate a corresponding solution
Ability to work with all levels of developers in different time zones
Ability to manage mission critical or highly available platforms or applications
Excellent verbal, written, and interpersonal communication skills
Excellent in creating visually dynamic presentations to demonstrate before and after results
Adaptability – Adapts to change, is open to new ideas, takes on new responsibilities, handles pressure, and adjusts plans to meet changing needs
Proactive team player with a can-do attitude

Data Modeler/Architect

Role: Data Modeler/Arhcitect

Location : Menlo Park, CA

Duration : 8+ Months

Skill : Data modeler/PLSQL

Mandatory skills: oracle DB, PL/SQL, Data Modelling

Works with Software developers, and DBAs to build consolidated data model and architect data migration solution –

•             Understand source data and map them to business rules

•             Prepare Logical data model and Physical data model.

•             Manage metadata for data models

•             Architecting the data migration solution focusing development of reusable components

•             Analyze data migration requirements, source data, target data model

•             Recommends the migration tools or  recommendations for ensuring optimized performance for the migration process

•             Design data migration strategy

•             Oversee and guide the development, testing and cutover for data migration

•             Facilitates incorporation of best practices and lessons learned from other engagements

•             Oversee and guide the development, testing and cutover for data migration

•             Participate in reviews and weekly meetings