Senior Software Engineer - ETL Developer

Company Description

Our Parent Organization, NEC Corporation, is a 25 billion Company with offices spread across the globe. 
NEC is a multinational provider of information technology (IT) services and products, headquartered in Tokyo Japan with 122 years of experience in evolution with technology and innovation. It is recognized as a ‘Top 50 Innovative Company’ globally

NEC Corporation has established itself as a leader in the integration of IT and network technologies while promoting the brand statement of “Orchestrating a brighter world.” 
NEC enables businesses and communities to adapt to rapid changes taking place in both society and the market as it provides for the social values of safety, security, fairness and efficiency to promote a more sustainable world where everyone has the chance to reach their full potential. 
  

NEC Software Solutions (India) Private Limited!  is based in Mumbai (Worli & Airoli) and Bangalore with an employee strength of 1500+. 
It is one of the foremost providers of end-to-end IT services across various sectors. 
We work with diverse industry verticals which include publishing, media, financial services, retail, healthcare and technology companies around the world. Our customers range from two-person startups to $bn listed companies.
 

We have more than 30 years of experience in providing end to end IT services across the globe and have earned a reputation for delighting our customers by consistently surpassing expectations and helping them deliver robust, market-ready software products that meet the highest standards of engineering and user experience. 
Supported by more than 1300 exceptionally talented manpower, we are a hub for offshore support and technology services

Experience : 4+ years

Location : Worli

Job Description :

Essential Skills

• Design, develop, and manage ETL workflows to integrate data from various sources into PostgreSQL databases.
• Develop scripts and queries to extract data from multiple sources, transform it to meet business requirements, and load it into PostgreSQL.
• Collaborate with data architects to design and implement optimized data models and schemas for efficient querying and storage.
• Monitor and optimize ETL jobs and PostgreSQL queries to ensure minimal downtime and high performance.
• Implement data quality checks and validation processes to ensure data integrity throughout ETL processes.
• Document ETL processes, workflows, data transformations, and data lineage for transparency and reproducibility.
• Design and develop dynamic dashboards and reports using Tableau, Power BI, and Amazon Quicksight to visualize data and provide actionable insights.
• Implement row-level security on dashboards and reports to ensure data confidentiality and compliance with data governance standards.
• Collaborate with stakeholders to gather and analyse requirements, understanding the client and business needs to deliver tailored data solutions.

Utilize cloud platforms for data analysis and ensure that all data practices are compliant with industry standards for data security and accuracy.

Technologies

Hands-on

Experience (Years)

Postgres 3+

MongoDB 3+

SQL (Views, SPs, Joins etc) 3+

AWS Quick Sight 2+

AWS DB Services 2+

Document DB 2+