Job Title : Oracle Database Developer Local )Location: NYC - HybridJob Type : Hybrid !Duration : 12 monthsOpening : 1 Opening !Assignment DetailsSenior database developer with strong data analytical skills and write complex queries to retrieve data for the business needs. Develop stored procedures, packages, and load large volumes of data using SPARK, Python, SQL Loader from .CSV files. Develop and publish the data on demand or scheduled and generate user reports using Power BI. Work independently and collaborate with teams, motivated and able to deliver end to end solutions.Skills & Requirements5+ years of experience in Oracle database developer with strong RDBMS skills - SQL querying, writing stored procedures, triggers, functions, views, user privileges, object privileges, etc. Strong data analysis and design skills. Has done performance tuning of stored procedures and queries. Knows ETL processes to load large volumes of data at speed, e.g. SQL Loader.3+ years of experience In Power BI developing front end reports. Has experience in python and Linux environment and knows basic Unix commands. Experience working with team in Agile methodology.Cloud experience is a plus, Strong data analysis skills, design, and coding experience in AMI (Advanced Metering Infrastructure) / Utility industry is a plus. Work independently and collaborate with teams, motivated and able to deliver end to end solutions. Good communication skill to both technology folks and business partners. Quick learner, adaptable, has the right attitude to work across teams to find and deploy solutions. Committed to timely and quality deliverables..Python, XML, SPARK, C#, Java Scripting, SPLUNK
- Database Development and SQL Skills: Please explain your experience with Oracle database development and RDBMS concepts?. What are the differences between user privileges and object privileges in Oracle? Have you worked with SQL Loader to load large volumes of data? Can you share your approach to handle data loading efficiently?
- Data Analysis and Design Skills: a. How do you approach data analysis and design tasks? Can you provide an example of a successful data analysis project you've worked on?
- Power BI and Front-End Reporting: a. Tell us about your experience with Power BI and developing front-end reports b. How do you ensure that the reports you create are intuitive and provide actionable insights for business users? c. Have you integrated data from different sources into Power BI reports? How do you handle data transformation and cleaning?
- Collaboration and Agile Methodology: a. How do you typically approach collaboration with other team members? b. Have you worked in an Agile development environment before? How do you adapt to changing requirements and priorities in Agile projects?
- Cloud Experience and Advanced Metering Infrastructure (AMI)/Utility Industry Knowledge: a. Do you have any experience or knowledge of the Advanced Metering Infrastructure (AMI) or the utility industry? How does this experience align with the role's responsibilities?