Data Engineer PL SQL
KeySkills
-
PL/SQL,
SQL Optimization,
Database Design & Data Modeling (OLTP)Functions,
Procedures,
Views,
Triggers,
GraphQL API Development,
Kafka & KSQL,
CDC Tools (Qlik / Attunity / Kafka),
AWS Cloud Services,
Cloud Console & CLIs (PostgreSQL,
SQL Server,
SQL Server Management Studio (SSMS),
DBeaver,
PgAdmin.,
Job Description
- Roles and Responsibilities:
- Design, develop, and maintain complex PL/SQL procedures, functions, triggers, and views for OLTP systems.
- Write optimized SQL queries and improve the performance of existing database components.
- Perform database design, data modeling, and schema creation aligned with OLTP workflows.
- Build, enhance, and maintain data pipelines, including streaming data solutions.
- Handle data ingestion, transformation, and integration from multiple sources using CDC tools (Qlik/Attunity, Kafka).
- Work on GraphQL APIs, enabling efficient and scalable data access.
- Collaborate with cloud teams to manage and optimize AWS cloud database services.
- Monitor, troubleshoot, and tune performance issues in streaming pipelines and cloud configurations.
- Work with tools like SQL Server Management Studio, DBeaver, PgAdmin, and cloud CLIs for database management.
- Follow best coding standards, documentation practices, and ensure data security and integrity.
- Collaborate with cross-functional teams to understand requirements and deliver high-quality data solutions.
Job Details
Experience :
8 To 10
Number Of
Vacancies :
10
Job Type :
Permanent
Industry Type : IT/Software
Salary
:
8 Lac - 12 Lac++
P.A
Education Summary
UG :
Any UG Degree
PG :
Any PG Degree
Contact Details
Contact
Person :
NA
Contact
Number :
1206629494
e-mailId :
rashmi.mishra@birlasoft.com
Address :
Birlasoft (India) Ltd.8th Floor, A - Wing, Prince Infocity II,No.283 / 4, Rajiv Gandhi Salai (OMR),Kandanchavadi, Chennai,Tamilnadu, India
Office Location
Central Jakarta No 1234, Jakarta, IndonesiaOracle OTM Lead
Experience -
10 to 15
Assistant Manger
Experience -
3 to 7
Key Skills -
aml transaction monitoring,
risk based transaction monitoring,
suspicious activity analysis,
money laundering detection,
terrorist financing detection,
tax evasion analysis,
correspondent banking monitoring,
payment service provider psp monitoring,
alert investigation,
case investigation,
complex tm investigations,
financial crime typologies,
structuring,
layering,
mule activity detection,
fec behavior analysis,
high risk merchant monitoring,
customer behavior analysis,
transaction pattern analysis,
ultimate beneficial owner analysis,
originator and beneficiary analysis,
geographic risk assessment,
sanctions and aml compliance,
regulatory compliance,
bank aml policies,
first line of defense,
escalation management,
suspicious activity escalation,
audit ready documentation,
investigation narratives,
evidence collection,
quality assurance reviews,
quality control qc,
subject matter expert sme support,
case management tools,
aml systems,
workflow tools,
osint research,
open source intelligence,
adverse media screening,
regulatory reporting support,
sla management,
productivity and quality metrics,
continuous improvement,
stakeholder collaboration,
peer mentoring,
risk assessment judgment,
independent decision making,
regulatory adaptability,
change management,
banking regulations,
regulation e,
regulation z,
cfpb guidelines,
facta compliance,
fcra compliance.,
Oracle AWS Run Support Lead
Experience -
8 to 10
.NET and SQL Server Developer
Experience -
0 to 2
Key Skills -
SQL Server,
Stored Procedures,
Views,
Triggers,
User Defined Functions,
SQL Profiler,
Performance Tuning,
SQL Server Jobs,
SSIS,
C#,
.NET Framework 2.0,
.NET Framework 3.0,
.NET Framework 3.5,
.NET Framework 4.0,
.NET Framework 4.5,
Web API,
SOA Services,
Azure,
Azure Functions,
Azure Service Bus,
Angular,
React JS,
Vue JS.,