Senior Software Engineer

Mphasis (Pune, MH, India) 20 days ago

Role: Python – Senior Software Engineer

Work Location: Pune / Bangalore

Technical Skills:

  • 5+ Years of experience in Python, Snow flex, Informetica
  • ETL development in Informatica
  • You get a detailed exposure to end to end ETL testing knowledge and the process followed here and a detailed exposure to heterogeneous databases – SQL Server, Oracle 10 g etc.
  • You get an exposure to Data warehouse tool - Informactica, SSIS etc.
  • Will be designing, developing and responsible for implementation in Snowflake.
  • Will be loading from disparate data sets and translating complex functional and technical requirements into detailed design. Will also perform analysis of vast data stores and uncover insights
  • Strong experience in building data warehouse solutions using Python.
  • Strong ETL performance-tuning skills and the ability to analyze and optimize production volumes and batch schedules.
  • Experience in SQL, PL/SQL / T-SQL
  • Experience with ETL, SFTP/SSH, Unix/Linux, as well as Git or other version control system

Good To Have

  • 4+ Years of experience in ETL Developer role with deep knowledge of Informatica tool.
  • Experience with Celery, RESTful APIs and server-side APIs integration
  •  Expertise in operational data stores and real time data integration 
  • Experience with Development Methodologies, Databases Platforms and Data Modeling tools (ERwin/Model Manager) 
  • Expert level skill in modelling, managing, scaling and performance tuning high volume transactional database.

Process Skills:

  • Experience in Python language and Cloud Implementation like AWS/GCP
  • Knowledge in Cloud technologies
  • Proficiency with Data Modeling tools such as Erwin/ER Studio.
  • Experience with ETL tools like Python and Informatica tools
  • Proficiency in master data management (MDM) projects and solutions.
  • Proficiency with high volume OLTP Databases and large data warehouse environments.
  • Experience and knowledge of optimizing database performance and capacity utilization to provide high availability and redundancy
  • Understanding of Agile and its implementation for Data Warehouse Development
  • Strong experience with SQL Server Management Studio, Advanced T-SQL and SQL Server Databases

Senior Software Engineer

Apply On Company Site
Back to search page