Sr. Oracle PL/SQL Engineer
Apply on
This is a hybrid contract to hire opportunity in Hartford, CT. W-2 hourly only. Cannot accept candidates who will require sponsorship now or in the future. No C2C.
Our financial services client's Enterprise Data Organization is seeking a Sr. Data Engineer/Tech Lead. We are seeking a talented professional with a proven track record of engineering and operationalizing a next generation analytics solution suite using Oracle PL/SQL, Cloud (AWS), and Big Data Technologies. Our ideal candidate will leverage deep technical expertise and strong communication skills to deliver both invest and maintenance projects within the Enterprise portfolio.
Responsibilities include but are not limited to:
-Ability to create, troubleshoot, enhance complex ETL like Oracle PL/SQL and SSIS code packages
-Ability to lead and operate in cloud environment involving AWS, Snowflake and migrate data assets to cloud
-Data integration and experience in distributed data systems expert to effectively linking, transforming and transferring of data between multiple applications on Prem or Cloud-based
-Provides highly technical consulting and leadership in identifying and implementing new uses of information technologies that assist the functional business units in meeting their strategic objectives
Qualifications:
-Bachelor s degree in Computer Science or a related discipline and 7 or more years experience in IT systems analysis and application program development, or an equivalent combination of education and work experience
-5+ years strong Database Developer experience using Oracle PL/SQL stored procedures, packages, functions, querying, testing, and deploying
-1-3 years experience of migrating assets to cloud - AWS and Snowflake environment
-5+ years of data analysis, manipulation and development
-1+ years of experience in the insurance or investment industry
-Strong SQL skills
-Knowledge of Oracle, Unix/Linux Shell scripting, Autosys scheduling tool, Sub Version, and Github /Jenkins (CI/CD) version control Tools
-Strong data warehouse applications knowledge in financial/insurance domain
-Knowledge of Data Modeling and Database design is key to this role
-Ability to design, implement, and oversee ETL processes
-Familiarity with emerging data centric technologies such as data virtualization
-Ability to choose and effectively utilize data wrangling technologies
-Exposure to cloud, Python/ Pyspark, Shell Scripting (e.g. AWS, S3, UNIX, Python, Snowflake, etc.) and learning/adapting to future technologies is preferred but not required.