Job Description
Job Description
Role : Senior SQL Developer with Integrated Eligibility Experience
Location : Providence, RI
Duration : 6 months
Required Skills :
Database and Programming Proficiency :
- Minimum of 7 years of experience with Oracle databases, capable of writing complex SQL queries and developing complex PL / SQL objects, including DML and DDL.
- Strong experience with database and SQL performance tuning.
- Proficient in data modelling and data visualization tools (Preferred Tableau / Power BI)
- Working knowledge of ETL practices (Extract, Transform, and Load) (Preferred - Informatica, Pentaho)
- Excellent understanding of database management systems (DBMS)
- Strong troubleshooting debugging skills with complex DML
- Expert level SQL querying and database manipulation with very large data sets
- Ability to debug and troubleshot logical and functional coding errors
Development Tools and Methodologies :
- Familiarity with code repositories, ideally Git.
- Experience with continuous integration tools, preferably Jenkins.
- Knowledge of relational database designs, ISDM methodologies, database security (role-based), and query tools like TOAD, SQL Developer, or SQL Navigator.
Technical and Analytical Skills :
- Proficiency in Unified Modeling Language (UML) for documenting system architecture.
- Ability to solve complex problems creatively and anticipate issues with software designs or specifications.
- Excellent interpersonal skills to establish effective working relationships, collaborate with team members, and communicate technical concepts clearly.
Preferred Knowledge, Skills & Abilities :
- 5 Years of Integrated Eligibility experience. Experience developing reports submitted to federal agencies. (SNAP / TANF / Medicaid)
- Design, Develop, Maintain, and support of various database-driven reporting initiatives
- Strong Data Validation, Quality Assurance, and Referential Integrity skills
- Experience with Enterprise Workflow Management Tools such as JIRA and ServiceNow
- Advanced Understanding to Data Visualization Technologies such as Tableau
Certifications and Agile Practices :
- Oracle certification(s) are a plus.
- Familiarity with Agile methodologies, particularly Scrum, XP, and Kanban.
Web and Front-End Development :
Experience in XML, CSS, and JavaScript frameworks (such as JQuery, AngularJS, NodeJS, or React) for web development.
Education : Bachelor's degree in information technology, Data Analytics, Computer Science with 7 -10 years of relevant experience
Apply At :
Please send your resume and a cover letter to Susmita Sahu (Susmita at irginc dot net)
To contact me click "View Profile" for the contact number.