Software Engineer

10 Applied
Job Description



Job Description:

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


  • 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 Key to this role
Technical / Behavioral

  • 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

  • UNIX

    • Exposure to UNIX Environment

    • Working knowledge of basic commands and shell scripting

  • Behavioral

    • 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

The Skills that are Good To Have for this role

  • Understanding of Agile methodology and working in scrum teams

  • Experience on using tools like JIRA, Jenkins

How Your Work Impacts the Organization
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

Location: Manyata ,Bangalorei
Shift timings: 11:00 am - 8:00pm Certifications:

Fidelity Investments is an equal opportunity employer.

JOB TYPE

Industry

Other

Roles

At Fidelity, we are focused on making our financial expertise broadly accessible and effective in helping people live the lives they want. We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. Fidelity India has been the Global Inhouse Center of Fidelity Investments since 2003 with offices in Bangalore and Chennai. For information about working at Fidelity, visit India.Fidelity.com.

People Also Considered

Data Not Available

Career Advice to Find Better