Nissan is a pioneer in Innovation and Technology. With a focus on Mobility, Operational Excellence, Value to our Customers and Electrification of vehicles, you can expect to be part of a very exciting journey here at Nissan.
Nissan is going after a massive Digital Transformation backed by leading technologies across the organization globally. We are committed to building a diverse, entrepreneurial organization, and our current team is a strong evidence of that.
Our people are what drive the business forward. At Nissan Digital, you will be part of a dynamic team with ample opportunities to grow and make a difference.
We are looking for an ETL Developer with 4-7 experience who can assist in the process of maintaining all the relevant sources of data and ensuring that it is being stored properly.
He / she is involved in developing the ETL processes and is involved in designing and preparing the codes that meet the program specifications.
Involved in coding, testing, implementing, debugging and documenting the complex programs.
Creating proper technical documentation in the work assignments.
Understands the business needs and designs programs and systems that match the complex business requirements and records all the specifications that are involved in the development and coding process.
Ensures that all the standard requirements are met and is involved in performing the technical analysis.
Responsible for assisting the project manager by compiling information from the current systems, analyzing the program requirements and ensuring that it meets the specified time requirements.
Resolves complex problems associated with the designed programs.
Skills and Qualifications
Strong experience in a BI / Data Warehouse environment with involvement in design, development, implementation, troubleshooting and support of ETL process using Informatica and an additional ETL tool.
Experience in developing Data Marts, Data warehousing and Operational Data Store (ODS) on any of the databases or Hadoop environments.
Should be having good experience with DWH concepts, and other DWH related terms.
Should have expertise in Informatica Power center and good to have knowledge of Informatica Cloud services.
Expertise in using advanced transformations such as Union, Normalizer, Aggregator, Joiner, Ranks transformation.
Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.
Should be well versed with migration strategies by manual and automated processes.
Should have experience in supporting the environment team for all the migrations, and other activities.
Extensive knowledge of business intelligence best practices, processes, and methodologies.
Good to have programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using SQL or T-SQL.
Experience in DB administration is a plus.
Highly committed, motivated, enthusiastic and a natural team player.
Excellent interpersonal, communication skills (both verbal and written), and ability to interact with and effectively address concerns.
Excellent prioritization, time management, analytical, and organization skills - able to determine what needs to be done and gets it done.
Experience with SQL Server database administration, preferred.
Team Foundation Server experience or any version control and scheduling tools like Autosys, TWS etc.
Experience working in an Agile Environment, preferred.
Drive your career forward and join the company leading the technology and business evolution in the automotive industry.
Trivandrum Kerala India