| Database Developer Local to CA at San Jose, California, USA |
| Email: [email protected] |
|
Title: Sr. Database Developer Location: San Jose, CA (hybrid) Visa: USC, GC Contract C2C/w2/1099 Description : We are seeking a skilled Oracle Database Developer with strong experience in SQL, PL/SQL and database technologies to join our dynamic team. The role is responsible for the design, development, coding, testing, debugging and documentation of datawarehouse/database/business intelligence applications. Duties include hands-on new development as well as support, maintenance, or enhancement of existing applications. Translate business requirements into technical specifications. Design and implement ETL (Informatica) process using SQL, ETL tool and Linux scripting to deliver high quality solutions. Strong data analysis, advance SQL query writing skill and resolving the defects by working across multiple teams Collaborate with other development teams to manage interdependency, set up test cases, debug and maintain data quality. Be able to lead and develop Informatica PowerCenter ETL complex flows connecting to heterogenous database such as oracle/MS SQL server. Develop complex oracle procedures ,functions, and packages to support database applications(API calls / DW reporting ) Conduct both proactive and reactive performance tuning activities during course of development of new applications and existing legacy applications. Code solutions and unit test to deliver a requirement/story per the defined acceptance criteria and compliance requirements. Required skills/experience Primary Skill- Oracle SQL / PLSQL 8+ years of professional experience with SQL/PLSQL 6+ years Informatica or other ETL tool Understand Data Federations, Data Lake, Data Mesh and Advance Cloud concepts. Experience automating ETL with job scheduling tools. Autosys Preferred Experience working with large data sets using big data solutions such as Hadoop, Spark etc. is a plus Preferred skills/experience Document and communicate required information for deployment, maintenance, support, and business functionality. Strong experience in Informatica, Datawarehousing, data architecture, databases and writing/optimizing advanced SQL queries in a business environment with large-scale, complex datasets Contribute to existing test suites (integration, regression, performance),analyze test reports, identify any test issues/errors, and triage the underlying cause. Using Trino, Starburst or similar vendor tool exposure would be a plus Characteristics of the top performer Self starter, able to work on fast paced complex setup, able to function independently and deliver the work by proactively resolving the impediments. Demonstrate exceptional analytical skills and problem solving skills; excellent organizational, communication skills A good team-player who seeks input and involves others in his/her communications; a person who values and cultivates relationships. An individual with a demonstrated ability to get things done and make things happen; a person who is resourceful, seizes opportunities and is an innovator. Kind Regards, Syeda Hajra | Absolute IT | Senior Technical Recruiter 116 Village Blvd Suite 200 Princeton New Jersey 08540 Absolute IT Direct: (609) 934 3457 [email protected] https://www.linkedin.com/in/syeda-hajra-a96813245/ www.absoluting.com -- Keywords: information technology green card wtwo microsoft procedural language California Database Developer Local to CA [email protected] |
| [email protected] View All |
| 09:31 PM 02-Dec-24 |