Software Engineer - ETL

  • Gurugram
  • Moodys
At Moody's, we unite the brightest minds to turn today’s risks into tomorrow’s opportunities. We do this by striving to create an inclusive environment where everyone feels welcome to be who they are—with the freedom to exchange ideas, think innovatively, and listen to each other and customers in meaningful ways. If you are excited about this opportunity but do not meet every single requirement, please apply! You still may be a great fit for this role or other open roles. We are seeking candidates who model our values: invest in every relationship, lead with curiosity, champion diverse perspectives, turn inputs into actions, and uphold trust through integrity. Title: SE– Database/ETL Engineer Responsibilities Responsible for owning the design/development aspects of database/ETL operations of multiple critical ratings applications in MIS Tech Must be able to operate effectively and collaboratively with a team of skilled professionals with wide variety of skillsets and establish a cordial/healthy relationship Analysis of the business and technical requirements to define and design the database/ETL service interfaces required to support the requirements Planning, engineering, design, implementation and managing database/ETL services for technologies in scope Collaborate with the developers and application leads/architects to deliver solutions based on Moody’s standards and requirements Partner with application support and development teams to deliver resilient and cost-effective solutions that meet demanding business requirements Provide stability to the current architectural solutions and explore opportunities to redesign/rewrite components to make the solutions robust, reliable and resilient Play a key role in sunsetting some of the legacy applications/processes by carefully evaluating the inter-dependences and impact analysis and migrating to modern data platforms in the future Lead the developers in the team by guiding them in a direction that is aligned with Moody's future vision from technology/culture perspective Enabling an environment of continuous learning, knowledge sharing, and teamwork Qualifications Bachelor’s in Engineering/Computer science 4+ years of total software development experience Experienced with Linux and Window’s operating platforms a must Demonstrate strong and hands-on experience and background in database principles and concepts Strong experience in designing and developing large-scale data solutions with solid understanding of data modeling, data processing, data warehousing and best practices Proficient in SQL and writing/understanding stored procedures, packages and PL/SQL programming in general At least 7 years of hands-on experience with at least one of the databases including Postgres, Oracle, Teradata, DB2, Sybase etc. Proficient in database performance tuning with clear understanding of indexing, partitioning, analyzing SQL plans, optimizer, hints etc. Expertise in Extract-Transform-Load(ETL)/Extract-Load-Transform(ELT) concepts with clear understanding in each of the stages and relevant tools/technologies At least 2 years of hands-on expertise with ETL tools like Informatica, Datastage, Talend etc. and should be able to justify the experience with good examples of design/development of robust ETL processes Exposure to any cloud platforms (AWS/GCP/Azure) and knowledge on data engineering/processing on cloud using tools/technologies like Python, Spark, Glue, Lambda etc. Strong background in Data Profiling, Data Analytics workloads and their role in design/development of data related processes Ability to work with multiple teams involved in applications end to end design, to understand and clearly articulate the data pipelines and intricacies/inter-dependencies involved Provide support/guidance to the development teams during the analysis, development, review and testing processes Good communication and inter-personal skills Moody’s is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, sexual orientation, gender expression, gender identity or any other characteristic protected by law.