Job Title- Software Engineer - PLSQL, Cloud technologies
Leverage emerging technologies and provide solutions to enable Customer Satisfaction, drive Scale & Efficiency and Business Results.
The Purpose of This Role
Data Engineering & Exchange group within Workplace Solutions Business Unit is focused on building and maintaining the Enterprise Data environments like Operational Data Store, Warehouse and Data Lake which are essential for business reporting and analytics capability. Our technology teams interact regularly with Business Analysts, Architects, Data Modelers, Scrum Master and other engineers from various teams across the globe to deliver the solutions which will delight our customers.
The Value You Deliver
As a Software engineer, you will be responsible for
The Skills that are Key to this roleTechnical / Behavioral
Analyzing the function requirements given by Business/Systems Analysts and determining the impact to the existing applications.
Developing and maintaining Informatica workflows for movement of the data between various source and target environments.
Developing and maintaining Oracle stored procedures per the business requirements.
Participate in scrums and stands up's .
Working with other stakeholders like Quality assurance and support teams to deliver the quality code as per the release timelines.
The Skills that are Good To Have for this role
Oracle SQL/PLSQL - Primary
Oracle Database Architecture
Experience in Oracle Database Programming using PL/SQL, SQL, Database Design (both Physical and Logical), Database Modeling, Oracle Tuning & Optimization.
Experience in creating Procedures, Packages, Functions, Triggers views, Cursors, PL/SQL Collections and optimizing query performance and other database objects using SQL, PL/SQL.
Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
Enforcing data integrity using integrity constraints and database triggers.
Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
Experience working with cloud technologies and building solutions using Azure/AWS is strongly preferred
Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Experience in numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, Backup and Recovery Planning, Testing and Implementation.
Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
Informatica - Secondary
Good understanding and working knowledge on Tasks, Sessions, Workflows and Worklets
Working knowledge of Connections, Parameters, Variables, Mappings and Mapplets
Working with Different types of transformations and user-defined functions
Workflow migration and Deployment
Optimization of workflows
Exposure to UNIX Environment
Working knowledge of basic commands and shell scripting
You should be able to effectively communicate on emails and/or orally with team members and stakeholders
You should be able to quickly learn and adapt to new technologies
How Your Work Impacts the Organization
Understanding of Agile methodology and working in scrum teams
Experience on using tools like JIRA, Jenkins
WS (Workplace Solutions) helps our customers save and invest through workplace retirement savings plans, build lifetime relationships with customers and provide employers with cost-effective, integrated employee benefit solutions. WS serves customers online, over the phone, and through a nationwide network of investor centers. WS is also committed to helping drive employee retirement readiness by delivering leading-edge financial solutions to employers, including recordkeeping, cash management products and services and personal advisory services (PAS). The Expertise We're Looking For
Bachelor degree in Computer science or any other discipline
Oracle PLSQL, Informatica and UNIX,Azure/AWS
: Manyata ,Bangalorei Shift timings
: 11:00 am - 8:00pm Certifications:
Fidelity Investments is an equal opportunity employer.