Lead, SW Eng

Northern Trust

8 - 10 years

30 - 35 Lacs

bengaluru

Posted:2 months ago| Platform:

Apply

Skills Required

data modeling rdbms consulting control-m plsql scheduling asset management unix shell scripting financial services python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Consults with Business Unit and IT management and staff on all phases of the project development cycle.
Helps to design major systems and their subsystems utilizing a solid understanding of available technology, tools and existing designs.
Provide technical expertise to support and enhance core data services platform
Operates independently; has in-depth knowledge of business unit / function
As subject area expert, provides comprehensive, in-depth consulting and leadership to team and partners at a high technical level
Carries out activities that are large in scope, cross-functional and technically difficult
Role is balanced between high level operational execution and development, and execution of strategic direction of business function activities.
Ensure code meets standards and tested appropriately in the platform
Be part of platform transformation journey and help in reengineering and improve the current set of applications
experience working in large data warehousing projects, implementing data warehouses, data marts, ETL, BI solutions etc.
Strong understanding of dimensional design techniques, star and snowflake schemas, building facts, dimensions, implementing SCD, various types of facts and dimensions etc.
Experience in data modeling practices in designing optimized solutions in 3NF, Data Vault and Dimensional models.
Ability to lead the creation and review of reusable, config driven and efficient ETL/ELT pipelines. Ensure that ETL processes are highly optimized for performance, cost-efficiency and scalability
Ability to guide and lead a team of data engineers and drive the implementation of data ingestion, curation and delivery from end to end
Ability to work closely with Data Governance team to ensure compliance, alignment with data governance policies and guidelines, data security, privacy regulations etc. Maintain a strong focus on data quality, data lineage and data access controls.
Strong experience with RDBMS, writing complex SQL and SQL Optimization
Strong and Proven Hands-On Experience in Snowflake Cloud DB, Databricks
Expertise in PL/SQL or equivalent scripting, Unix Shell scripting, Python etc.
Experience with scheduling and batch orchestration tools like Control-M
Experience in Azure cloud services such as Azure ADF, Azure DevOps, Logic App, Azure Functions , Azure Databricks, Azure Storage etc. or equivalent services in AWS or GCP.
Experience in managing data security and designing secure data solutions.
Experience with Agile development methodologies and a track record of successfully delivering projects in an Agile environment.
Experience with data visualization tools such as Power BI, Tableau etc.
Working experience in creating AI/ML solutions
Understanding of Asset Management, Financial Markets, Investment Vehicles, Market Participants, Investment Management and Accounting, ESG Investment etc.

More Jobs at Northern Trust

ServiceNow Developer

Pune, Maharashtra, India

4 - 9 yrs

Salary: Not disclosed

Sr. Associate SW Eng

Pune

1 - 3 yrs

INR 3 - 5 Lacs

ServiceNow GRC Tech Lead

Pune

12 - 15 yrs

INR 8 - 12 Lacs

Sr Analyst, Cyber Sec IT RiskM

Pune

2 - 3 yrs

INR 9 - 12 Lacs

Sr Analyst, Cyber Sec ThreatMgmt

Pune

2 - 3 yrs

INR 7 - 8 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.