• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 2nd Sep 2025

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 shell 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.