Help us maintain the quality of jobs posted on PowerToFly. Let us know if this job is closed.
Job Details
Experience Level: Experienced Hire
Categories:
- Engineering & Technology
Location(s):
- Tower -11, (IT/ITES) SEZ of M/s Gurugram Infospace Ltd, Vill. Dundahera, Sector-21, Gurugram, Haryana, Gurugram, Haryana, 122016, IN
- 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
- 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
About the Company
Moody's
New York City, NY, United States
In a world shaped by increasingly interconnected risks, Moody's helps customers develop a holistic view of these risks to advance their business... Read more